| Oracle® Application Integration Architecture Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release Implementation Guide Release 11.1 Part Number E27415-04 |
|
|
PDF · Mobi · ePub |
| Oracle® Application Integration Architecture Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release Implementation Guide Release 11.1 Part Number E27415-04 |
|
|
PDF · Mobi · ePub |
This chapter provides an overview of the process integration for item balance update and discusses:
Item balance update process integration
Solution assumptions and constraints
Agile Product Lifecycle Management (PLM) interfaces
Oracle E-Business Suite interfaces
Core Application Integration Architecture (AIA) components
Integration services
Agile PLM is the master for part and product information. Oracle E-Business Suite manages certain business related information related to the parts such as quantity on hand. This business information is regularly updated in Oracle E-Business and it is important to provide visibility to this information in the product development environment (PLM).The process integration for item balance update supports the update of quantity on hand and item availability
The item balance and availability information from Oracle E-Business Suite is updated in Agile PLM as part of the manufacturing update process for product information synchronization through a batch process. The term item applies to both parts and documents in Agile PLM.
The item balance information is stored in Oracle E-Business Suite in three attributes:
Reserved Quantity
Available Quantity
On-hand Quantity
These three attributes are not available in the delivered application of Agile PLM. To update the item balance information from these three attributes, flex-fields in Agile PLM are configured and mapped. This configuration information is entered in the AIAConfigurationProperties.xml file.
The update of item balance information from Oracle E-Business Suite to Agile PLM is performed as a batch process.
The item balance update process includes:
Item balance information (that is on hand quantity) is modified in Oracle E-Business Suite.
This modification could be done in specific organizations or in a single Oracle E-Business Suite organization. You can designate, as a part of a configuration parameter, a single Oracle E-Business Suite organization from which all item attribute information is always retrieved. In such a case, it is not necessary to have Agile PLM multi-sites.
The input for this process consists of a batch of item on hand quantity or balance information with their unique identifiers and values that need to be updated in Agile PLM.
The batch process for publishing the changed information initiates at a specified frequency, which is configurable.
Note:
While the update to information in Agile is normally driven through the scheduled batch processes, it is also possible to trigger the information update event from Oracle E-Business Suite through the Integrations Administrator and running the Publish Engineering Change Order Updates function.
The process retrieves the last date and time where the item information update process completed successfully.
The process retrieves the list of items whose on hand quantity has changed after the last successful run.
In addition, it retrieves the list of mapped attribute values for these items. The data is retrieved from one or more organizations as per site-org mappings or from the configured single organization.
Item balance information can exist in multiple organizations in Oracle E-Business Suite. Any change in any of the three types of attributes (reserve quantity, available quantity or on hand quantity) may take place in just one, or in a few, or in all organizations. Oracle E-Business Suite determines which organization corresponds (maps) to which flex-field in Agile PLM using the Domain Value Map (DVM) AGILE_TARGET_SITE_MAPPING.
In the case of a single site environment:
Sites are mapped to the Oracle E-Business organizations through a specified P2 attribute (example, P2.ebiz Org)
Item balance information is retrieved from the specified organization and updated in the mapped attributes in Agile
In case an item is mapped to multiple organizations, the values from the first Organization in the transformed XML file are picked up for update
In the case of multi-site environment:
The attribute to be updated is defined on the Site tab of the item in Agile PLM.
Based on the update of the item attribute value in an Organization, the change is reflected in the mapped attribute in the corresponding Site.
The process updates the information in Agile PLM.
If the complete update is processed successfully, the process updates the date and time of last successful run. If the update for an item fails, the system continues to process other items in the batch. A list of all errors encountered when processing the batch are accumulated and logged.
Figure 3-1 illustrates the integration sequence for item balance update from Oracle E-Business Suite to Agile PLM:
The following exception conditions create error messages for this integration process:
Insufficient privilege to discover, read, add attachment to or update attributes on the Change object
Invalid field value (indicate the field for which the value is incorrect, and the value that is being passed on to the field)
Change object does not exist
Error when adding attachment
Figure 3-2 illustrates the item balance update integration services orchestration:
Table 3-1 lists the activities involved in the item balance update integration services orchestration:
Table 3-1 Activities in Item Balance Update integration services orchestration
| # |
Activity | Remarks |
|---|---|---|
|
1 |
Publish Item Balance concurrent program is initiated. |
The Publish Item Balance concurrent program in Oracle E-Business Suite invokes UpdateItemBalanceListEbizReqABCSImpl. |
|
2 |
UpdateItemBalanceListEbizReqABCSImpl invokes ItemBalanceEBS. |
An invoke activity in UpdateItemBalanceListEbizReqABCSImpl invokes UpdateItemBalanceList operation on ItemBalanceEBS with UpdateItemBalanceList EBM as input. |
|
3 |
ItemBalanceEBS invokes UpdateItemBalanceListAgileProvABCSImpl. |
ItemBalanceEBS sends UpdateItemBalanceListEBM message as input to the UpdateItemBalanceListAgileProvABCSImpl service. |
|
4 |
UpdateItemBalanceListAgileProvABCSImpl invokes Agile PLM's Item Balance Web service. |
UpdateItemBalanceListAgileProvABCSImpl transforms UpdateItemBalanceListEBM to the AgileUpdateItemBalanceListABM message and invokes the UpdateItemList service operation on Agile PLM Web Service to update Item On-Hand Quantity information from Oracle to Agile PLM. AgileUpdateItemBalanceListResponseABM is returned to the UpdateItemBalanceListAgileProvABCSImpl service. Note: The UpdateItemBalanceAgileProvABCSImpl composite uses the oracle/wss_http_token_client_policy client security policy while calling the ItemABS service hosted on the Agile server. The security credentials for this are stored in the csf-key AgileWebServicesKey on Fusion Middleware (FMW). The Agile username and password need to be setup correctly so that the Agile service is invoked successfully from the AIA composite in the FMW layer. |
|
5 |
UpdateItemBalanceListAgileProvABCSImpl sends the response to ItemBalanceResponseEBS. |
UpdateItemBalanceListAgileProvABCSImpl transforms AgileUpdateItemBalanceListResponseABM to UpdateItemBalanceListResponseEBM and returns it to ItemBalanceResponseEBS. |
|
6 |
ItemBalanceResponseEBS sends UpdateItemBalanceListResponseEBM to UpdateItemBalanceListEbizReqABCSImpl. |
UpdateItemBalanceListEbizReqABCSImpl sends the response to the concurrent program in Oracle E-Business Suite. |
If item balance information must be retrieved from multiple organizations in Oracle E-Business Suite, the following constraints apply for an end-to-end process integration:
Agile PLM multisites must be configured.
A one-to-one mapping between the Agile PLM sites and Oracle E-Business Suite organizations exists.
This is derived from the AGILE_TARGET_SITE_MAPPING DVM.
The attributes to be updated with Oracle E-Business Suite data are on the Sites tab of the item if the Agile PLM multisites are configured.
Alternatively, customers can designate, as a part of configuration parameters, a single Oracle E-Business Suite organization from which available quantity information is always retrieved. In such a case, you do not need to have Agile PLM multisites. Any Title Block or Page Two attribute can be updated with Oracle E-Business Suite data in such a case.
All changes are interfaced to only one destination system.
With the current release of Agile PLM, attributes are applied at the master data level.
This means that an attribute cannot have different values across different part revisions.
Only the item number is used to query the item to be updated and all updates are made to the latest released revision of the item.
Note:
New item creation is not part of the scope for this activity. The assumption is that the item exists in both Agile PLM and Oracle E-Business Suite, by means of a prior New Part Introduction or independent offline load processes.
Table 3-2 lists the Agile PLM Web Services Definition Language (WSDL) files:
Table 3-2 Agile PLM Web Services Definition Language (WSDL) files
| Interface | Description |
|---|---|
|
UpdateItemBalanceListAgileProvABCSImpl |
|
|
ItemABS.wsdl |
Used to update an item balance information in Agile PLM |
Table 3-3 lists the Agile PLM XML Schema Definition (XSD) files:
Table 3-4 lists the Oracle E-Business Suite WSDL files:
Table 3-4 Oracle E-Business Suite WSDL files
| Interface | Description |
|---|---|
|
UpdateItemBalanceListEbizReqABCSImpl |
|
|
QueryItemBalanceListEbizAdapter.wsdl |
Used for the OA adapter "INV_EBI_ITEM_PUB.GET_ITEM_BALANCE" pl/sql function call |
Table 3-5 lists the Oracle E-Business Suite XSD files:
Table 3-5 Oracle E-Business Suite XSD files
| Interface | Description |
|---|---|
|
UpdateItemBalanceListEbizReqABCSImpl |
|
|
ItemBalanceABM.xsd |
ABM for ItemBalanceABO |
|
ItemBalanceABO.xsd |
Created based on the input from the Concurrent Program to the BPEL process and output to the Concurrent Program from the BPEL process |
|
APPS_INV_EBI_ITEM_PUB_GET_ITEM_BALANCE.xsd |
The input and output ABM for the PL/SQL API call are defined in this XDS. The package used is INV_EBI_ITEM_PUB.GET_ITEM_BALANCE |
|
CommonEbizComponents.xsd |
Defines common ResponseType element |
Table 3-6 lists the industry components for the process integration for item balance update:
Table 3-6 Industry Components for Item Balance Update
| Component | Name |
|---|---|
|
Enterprise Business Object (EBO) |
ItemBalanceEBO |
|
Enterprise Business Message (EBM) |
UpdateItemBalanceListEBM UpdateItemBalanceListResponseEBM |
|
Enterprise Business Service (EBS) |
ItemBalanceEBS ItemBalanceResponseEBS |
Table 3-7 lists the core components locations:
Table 3-7 Core Component Locations
| Component | Name |
|---|---|
|
EBO and EBM XSD files |
$AIA_HOME/AIAMetaData/AIAComponents/EnterpriseObjectLibrary/Core/EBO/ $AIA_HOME/AIAMetaData/AIAComponents/ ApplicationObjectLibrary /Ebiz/Release1/Core |
|
WSDL files |
$AIA_HOME/apps/AIAMetaData/AIAComponents/ EnterpriseBusinessServiceLibrary /Core/EBO/ $AIA_HOME/AIAMetaData/AIAComponents/ ExtensionServiceLibrary/Ebiz $AIA_HOME/AIAMetaData/AIAComponents/ApplicationConnectorServiceLibrary/Ebiz/V1 |
For detailed documentation of individual EBOs and EBMs, click the AIA Reference Doc link on EBO and EBM detail pages in Oracle Enterprise Repository.
For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack 11g Release 1, "How to Access Oracle AIA Content in Oracle Enterprise Repository."
EBOs can be extended, for instance, to add new data elements. These extensions are protected and will remain intact after a patch or an upgrade.
For more information, see Oracle Fusion Middleware Concepts and Technologies Guide for Oracle Application Integration Architecture Foundation Pack 11g Release 1, "Understanding Extensibility."
Table 3-8 lists the Oracle E-Business Suite and Agile PLM components:
Table 3-8 Oracle E-Business Suite and Agile PLM Components
| Services | Oracle E-Business Suite (Requester) | Agile PLM (Provider) |
|---|---|---|
|
ABMs |
ItemBalanceABM.xsd |
AgileUpdateItemBalanceListABM AgileUpdateItemBalanceListResponseABM |
|
Application Business Connector Service (ABCS) |
UpdateItemBalanceListEbizReqABCSImpl |
UpdateItemBalanceListAgileProvABCSImpl |
|
EBS |
ItemBalanceEBS |
ItemBalanceResponseEBS |
|
Adapter service |
QueryItemBalanceListEbizAdapter |
--- |
Table 3-9 lists the core components locations:
Table 3-9 Core Component Locations
| Component | Location |
|---|---|
|
Application Business Objects, ABM, and Common XSD files |
$AIA_HOME/AIAMetaData/AIAComponents/ ApplicationObjectLibrary /Agile PLM/V1/schemas $AIA_HOME/AIAMetaData/AIAComponents/ ApplicationObjectLibrary /Ebiz/V1/schemas $AIA_HOME/AIAMetaData/AIAComponents/ ApplicationObjectLibrary /Ebiz/Release1/Core |
|
WSDL files |
$AIA_HOME/AIAMetaData/AIAComponents/ ApplicationObjectLibrary /Agile PLM/V1/wsdls $AIA_HOME/AIAMetaData/AIAComponents/ ApplicationObjectLibrary /Ebiz/wsdls $AIA_HOME/AIAMetaData/AIAComponents/ ExtensionServiceLibrary/Ebiz $AIA_HOME/AIAMetaData/AIAComponents/ApplicationConnectorServiceLibrary/Ebiz/V1 |
The integration services for the item balance update are:
ItemBalanceEBS
UpdateItemBalanceListEbizReqABCSImpl
UpdateItemBalanceListAgileProvABCSImpl
ItemBalanceEBS is the Enterprise Business Services (EBS) that exposes the following operations related to the item availability attributes update integration on the ItemBalanceEBO.
The following list itemizes the routing rules:
ItemBalanceEBS service
UpdateItemBalanceList: Routes the UpdateItemBalanceListEBM to the UpdateItemBalanceListAgileProvABCSImpl
ItemBalanceResponseEBS service
UpdateItemBalanceListResponse: Routes the UpdateItemBalanceListResponseEBM to the UpdateItemBalanceListEbizReqABCSImpl
This service is called when a participating application needs to update multiple item balance attributes on their system such as on-hand quantity from Oracle E-Business Suite. This is a push from Oracle E-Business Suite to the other participating application through a batch process.
The process includes:
The requester ABCS, defined as a synchronous process, receives a list of item IDs from the Oracle E-Business Suite concurrent program.
The list contains the IDs that have last_update_date greater than the last run date of the concurrent program.
The requester Business Process Execution Language (BPEL) process filters the list of IDs to a list of IDs that are present in the cross-reference tables in the Fusion Middleware (FMW) layer.
This provides a list of Items that are in the Agile PLM application. The original list of Item IDs can contain items that are from non-Agile PLM sources as well.
The BPEL process then makes an OA Adapter call out that calls the PL/SQL API, which provides the details of the sent item.
This is an ItemBalance Application Business Message (ABM).
A transformation converts the ABM to an EBM.
An asynchronous request-delayed response call is made to the ItemBalanceEBS with the ItemBalanceListEBM.
This service is routed to the appropriate provider.
The BPEL instance is reactivated from dehydration store when the asynchronous call returns from the provider and provides the status of the transaction back to the caller concurrent program (because that is a synchronous call).
It is a scheduled call and is invoked from the back end, not from the user interface (UI); hence, it does not affect performance.
· The concurrent program logs the status of this call.
UpdateItemBalanceListAgileProvABCSImpl is used to facilitate the communication between ItemBalanceEBS and Agile PLM Web service used for updating the item quantity information in a batch mode in Agile PLM.
The process includes:
The UpdateItemBalanceListAgileProvABCSImpl receives UpdateItemBalanceListReqMsg, which contains UpdateItemBalanceListEBM.
The transform operation is called to convert UpdateItemBalanceListEBM into AgileUpdateItemBalanceListABM.
AgileUpdateItemBalanceListABM is sent as input to the Web service operation UpdateItemList (Coarse Grained APIs in Agile PLM) to update items in Agile PLM.
AgileUpdateItemBalanceListResponseABM is received on the successful run of the Coarse Grained API.
The transform operation is called to convert AgileUpdateItemBalanceListResponseABM to UpdateItemBalanceListResponseEBM, which is returned as output of this BEPL process.
If the UpdateItems service operation fails on the Agile PLM side, a new fault is generated and is sent across with an appropriate error message.
|
 Copyright © 2001, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
