My Oracle Support Banner

Model Upload Process Fails to Populate REV_COLUMN_PROPERTIES with Processing Key for Lookup Table Driver (Doc ID 2599734.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)

Symptoms

After setting up a Lookup Table with four columns having the Processing Key UDP in Erwin Data Modeler and running the Model Upload process, some of the columns are missing from the Lookup Table Driver user interface.

When checking REV_COLUMN_PROPERTIES, there is only one row for the Lookup Table with COLUMN_PROPERTY_CD = 15 (Processing Key).  The other columns setup as Processing Key columns are missing from this table.

Also, the following error exists in the Model Upload log from /<ftpshare>/<infodom>/logs:

Error while executing the query Failed Executing Batch: error occurred during batching: ORA-00001: unique constraint (<atomic user>.PK_AAI_ENTITY_ALTER_TRACE) violated

You expect all columns setup with the Processing Key UDP to have rows inserted into REV_COLUMN_PROPERTIES.  You do not know if the ORA-00001 is related to the issue.

Cause

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
Symptoms
Cause
Solution
References


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