ECO Messages From Agile erroring with ORA-01400

(Doc ID 1360428.1)

Last updated on OCTOBER 20, 2016

Applies to:

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

Symptoms

When attempting to transfer an ECO from Agile to Ebiz,
the following error appears in the raw xml audit of the CreateQueueService BPEL process.

Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [InsertIntoQueue.EcoQueue].
Caused by java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PLMPIP"."ECO_QUEUE"."OBJECT_REFERENCE")

 

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