My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.