Introduction to AIA PIP

What is AIA
Application Integration Architecture is an open, standards-based platform that is designed to ease integration of disparate applications into a unified enterprise architecture using service-oriented architecture (SOA). AIA provides an integration framework for enabling cross-application business processes, which spares organizations the effort of having to customize their applications to achieve the same end within a single, common application suite, such as Oracle E-Business Suite or Oracle Siebel applications. It can be used to link together Oracle applications, custom applications or any combination of enterprise legacy applications.

AIA Components

AIA consists of three components:

1. The Foundation Pack, 
2. Process Integration Packs and
3. Direct Integrations.

All of which use Oracle Fusion Middleware as the technology platform. The Foundation Pack sits on top of the Oracle SOA Suite to provide the common framework and object models; the Process Integration Packs are built on top of the Foundation Pack to facilitate composite business process integrations of two or more Oracle applications. Direct Integrations are a prebuilt tightly coupled data integration solution between two applications

Starting lot number prefix is required when Lot Control = Full lot control

While releasing a part from Agile getting below error.

Error: Starting lot number prefix is required when Lot Control = Full lot control

Cause You have to specify Lot Prefix in the  template when you have Lot Control=Full Lot Control.

Resolution Please correct the Item Templates in Oracle EBS and resubmit the ECO from AIA queue.

Err Msg INV INV_INVALID_ARG_NULL_VALUE

Error INV INV_INVALID_ARG_NULL_VALUE 

When an ECO being released from Agile PLM, getting below error in AIA PIP

Org Code MST ECO Name ECO00018 Err Msg INV INV_INVALID_ARG_NULL_VALUE


This could be because, category set which is being sent from Agile is not valid Oracle EBS.
You need check, if the category set is valid in Oracle EBS or not.

Use below code for the same,


SELECT    (segment1)|| '.'
       || (segment2)|| '.'
       || (segment3)|| '.'
       || (segment4)|| '.'
       || (segment5)|| '.'
       || (segment6)|| '.'
       || (segment7) cat_set,
       mc.segment1,
       mc.segment2,
       mc.segment3,
       mc.segment4,
       mc.segment5,
       mc.segment6,
       mc.segment7
  FROM mtl_categories_b mc
 WHERE     enabled_flag = 'Y'
       AND NVL (end_date_active, SYSDATE) >= SYSDATE
       AND    (segment1)
           || '.'|| (segment2)
           || '.'|| (segment3)
           || '.'|| (segment4)
           || '.'|| (segment5)
           || '.'|| (segment6)
           || '.'|| (segment7) LIKE     '&p_cat_set';


Make sure you have the category defined in Oracle and try to resubmit the ECO from AIA queue.