Inserted value too large for column: "NOT_FOUND" Error when Creating ECO in Agile (Doc ID 1324569.1)

Last updated on JANUARY 27, 2017

Applies to:

Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite - Version 3.1 to 3.1 [Release 3.1]
Information in this document applies to any platform.

Symptoms

When trying to synchronize a ECO from Agile to E-Business Suite, the following error is captured in the CreateEngineeringChangeOrderListEbizProvABCSImplProcess raw xml:

</db:NAME_VALUE_TABLE_ITEM><db:NAME_VALUE_TBL_ITEM><db:PARAM_NAME>ASSIGN_DEFAULT_TEMPLATE_FROM_ICC</db:PARAM_NAME><db:PARAM_VALUE>F</db:PARAM_VALUE></db:NAME_VALUE_TBL_ITEM></db:NAME_VALUE_TBL></db:P_ECO_OBJ_LIST_ITEM></db:P_ECO_OBJ_LIST></InputParameters></part></createECOABM></input><fault>
<bpelFault><faultType>0</faultType><bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'ECOService' failed due to: Set object error.
Error binding the value of parameter P_ECO_OBJ_LIST.
An error occurred when binding the value of parameter P_ECO_OBJ_LIST in the APPS.INV_EBI_CHANGE_ORDER_PUB.PROCESS_CHANGE_ORDER_LIST API. Cause: java.sql.SQLException: Inserted value too large for column: "NOT_FOUND"
Check to ensure that the parameter is a valid IN or IN/OUT parameter of the API. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-17072" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.
</summary></part><part name="detail"><detail>Inserted value too large for column: "NOT_FOUND"</detail></part><part name="code"><code>17072</code></part></bindingFault></bpelFault></fault><faultType>



The soa_server1_diagnostic1.log shows similar error also:

[2011-05-14T20:39:51.934-07:00] [soa_server1] [ERROR] [] [oracle.soa.adapter] [tid: [ACTIVE].ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 7fe8c552f8ea9868:-61bfb952:12fe45849ca:-8000-000000000006008c,0:1:100000374] [APP: soa-infra] JCABinding=> CreateEngineeringChangeOrderListEbizAdapter:CreateEngineeringChangeOrderListEbizAdapter [ ECOService_ptt::ECOService(createECOABM,createECOResponseABM) ] Could not invoke operation 'ECOService' against the 'Oracle Applications Adapter' due to: [[
BINDING.JCA-11808
Set object error.
Error binding the value of parameter P_ECO_OBJ_LIST.
An error occurred when binding the value of parameter P_ECO_OBJ_LIST in the APPS.INV_EBI_CHANGE_ORDER_PUB.PROCESS_CHANGE_ORDER_LIST API. Cause: java.sql.SQLException: Inserted value too large for column: "NOT_FOUND"
Check to ensure that the parameter is a valid IN or IN/OUT parameter of the API. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-17072" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

Changes

This is a new installation of the 'Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite'.

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