My Oracle Support Banner

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.


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")



To view full details, 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 a vibrant support community of peers and Oracle experts.