Query Regarding Auto Generation of Common Column In AIA Xref Database

(Doc ID 1362106.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Customer Master Data Management Integration Base Pack - Version 2.5 and later
Information in this document applies to any platform.

Goal

Question 1:
By default the AIA PIP generates a value for the COMMON column in the Cross-References table during the execution of its flows.
Is it possible change this behavior for setting a NULL value or is mandatory always have a value for this column?

Question 2:
"During initial load using the AIA xref tool there is the parameter "-generate COMMON". Example:

xrefimport.sh -file ~/orginvsetup/Organization.xml -generate COMMON

1) In this case what is the algorithm used by the PIP to generate value for the COMMON column? Looking at the records created in XREF_DATA table it seems that are generated random values.

2) Is the same logic implemented by the PIP for the on-going flow?

3) What happen if this clause is not informed? Which will be the consequences?

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