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.

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

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
Goal
Solution


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