My Oracle Support Banner

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.


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: -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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.