How To Rectify Incomplete XREF_DATA Rows For A Failed ProcessEngineeringChangeOrderAgileReqABCSImpl Composite (Doc ID 1607084.1)

Last updated on MARCH 08, 2017

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.

Goal

In the Create Engineering Change Order flow from Agile to Ebiz when it errors after successfully committing the ECO in Ebiz the XREF_DATA rows may not be created appropriately.

The issue can be reproduced where Agile ChangeABS service is not available:
Ebiz rows are creating OK.
Agile rows are creating in TEMP xref_table_name's and not in non TEMP names.

How to rectify this so all XREF_DATA entries are created correctly?

Solution

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