My Oracle Support Banner

Data Model Has Default Values Set for DIM_LOB and DIM_ORG_STRUCTURE Primary Keys in 6.1.1 But Not in 8.0.2 (Doc ID 2381455.1)

Last updated on APRIL 02, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.1 to 8.0.2 [Release 6 to 8]
Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1.1 to 8.0.2 [Release 6 to 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

On : 8.0.2 version

Profitability Management (PFT) Data Model has DATA_DEFAULT values set for Primary Keys in 6.1.1 but not present in 8.0.2 PFT Data Model.
Can this difference be ignored in 8.0.2 data model?

Examples:
select TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, NULLABLE, DATA_DEFAULT from USER_TAB_COLUMNS where TABLE_NAME in('DIM_LOB', 'DIM_ORG_STRUCTURE') and COLUMN_NAME in('N_LOB_SKEY','N_ENTITY_SKEY');

 

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!


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