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)
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?
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');
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!