QueryBillOffMaterialsListPIMAdapter Not Working (Doc ID 1321316.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Product Master Data Management Integration Base Pack - Version 2.5 to 2.5 [Release 2.5]
Information in this document applies to any platform.

Symptoms

On : 2.5 version, Other-MDM_PIM

When attempting to sync an item from PIM,
The process 'QueryBillOffMaterialsListPIMAdapter' is failing due to improper details in the sub process wsdl - 'QueryPartialBillOfMaterialsListPIMAdapter'

ERROR
-----------------------

<2011-03-07 11:47:02,835> <ERROR> <default.collaxa.cube.ws> <AdapterFramework::Outbound> file:/opt/Fusion/SOA/10.1.3/bpel/domains/default/tmp/.bpel_QueryBillOffMaterialsListPIMAdapter_1.0_6e4f72dac5bc343a16883617e1b1bc9e.tmp/QueryPartialBillOfMaterialsListPIMAdapter.wsdl [ QueryPartialBillOfMaterialsListPIMAdapter_ptt::QueryPartialBillOfMaterialsListPIMAdapter(InputParameters,OutputParameters) ] - Could not invoke operation 'QueryPartialBillOfMaterialsListPIMAdapter' against the 'Oracle Applications Resource Adapter' due to:
ORABPEL-11811
Error while trying to prepare and execute an API.
An error occurred while preparing and executing the APPS.AIA_MDMITEMBATCH.QUERY_BOM API. Cause: java.sql.SQLException: ORA-06550: line 1, column 29:
PLS-00302: component 'QUERY_BOM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[Caused by: ORA-06550: line 1, column 29:
PLS-00302: component 'QUERY_BOM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
]
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.

Cause

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