Dequeing the B2B Generated EDI-XML from AQ using the Apps Adapter gives "ORABPEL-11811 Error while trying to prepare and execute an API" with "ORA-06531 Reference to uninitialized collection "
Last updated on NOVEMBER 03, 2017
Applies to:OracleAS Adapters - Version 10.1.3.1 to 10.1.3.1 [Release AS10gR3]
Oracle B2B 10g (Business to Business) - Version 10.1.2.3.0 and later
Oracle(R) BPEL Process Manager 10g - Version 10.1.3.1 to 10.1.3.1 [Release AS10gR3]
Information in this document applies to any platform.
***Checked for relevance on 31-Aug-2011***
Using 10.1.3.1.0, a BPEL process polling an AQ for EDI-XML input (which was generated by Oracle B2B) throws the following error:
Error while trying to prepare and execute an API.
An error occurred while preparing and executing the APPS.XX_BPEL_WRITEEDIDATA2ORACLESER.OE_ORDER_PUB$PROCESS_ORDER API.
Caused by: ORA-06531: Reference to uninitialized collection
ORA-06512: at "APPS.XX_BPEL_WRITEEDIDATA2ORACLESER", line 1
Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable.
Seen in the case where:
- Input file is an EDI 850 document. This input file is placed in a directory (in the machine where Oracle B2B is installed) polled by B2B. In the B2B system the trading partner ACME (Remote) and GlobalChips (host) are set up using the File 1.0 protocol. The necessary setup, such as defining the Business Action, Trading Partners, Document Definition, Creating / Deploying the Agreement, and Deployment are done in B2B.
- The Oracle B2B generates the EDI-XML using EDI adapter and puts in the Advanced Queue which is part of the B2B schema configured during the installation and configuration of Oracle Integration B2B.
- The BPEL process (EDI850InboundService.bpel) dequeues the document from the AQ using the AQ adapter with Consumer name (Document Routing as set up in B2B) QueueName=IP_IN_QUEUE.
- The BPEL Process EDI850InboundService.bpel then invokes the Oracle Apps adapter to create a sales order in Oracle Apps.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms