My Oracle Support Banner

Are There Changes to the Primary Key Index for the STG_GL_DATA Table in 8.1 Version? (Doc ID 2894650.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Oracle Insurance Allocation Manager for Enterprise Profitability - Version 8.1.1.1 to 8.1.1.1 [Release 8.1]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)
Primary Key (PK) Index
ERwin Data Model

Goal

Have merged the 8.1 PFT and 8.1 FTP data models with current base 8.0.7 data model and created a final merged data model. As part of the data model merge a new composite Primary Key  (PK_578) got added to the STG_GL_DATA table. This primary key was not existing on that table before the data model merge. Also note, six new columns have been added to the STG_GL_DATA table as part of the data model merge out of which three of those new columns are part of the composite Primary Key. Below are the six new columns:

LINE_OF_BUSINESS_CODE (Not NULL column with No default value and also part of the Primary Key)
F_IBF_ACCOUNT_IND (Not NULL column with default value 'N' and also part of the Primary Key)
V_CUST_REF_CODE
V_GL_BOOK_CODE
V_INTERNAL_CUST_REF_CODE (Not NULL column with default value 'MSG' and also part of the Primary Key)
V_ISO_COUNTRY_CD

PK_578: (V_LV_CODE, V_GL_CODE, F_CONSOLIDATION_FLAG, V_BRANCH_CODE, V_SCENARIO_CODE, V_CCY_CODE, V_PROD_CODE, V_FINANCIAL_ELEMENT_CODE, V_COMMON_COA_CODE, FIC_MIS_DATE, V_GAAP_CODE, V_ORG_UNIT_CODE, N_DATA_FEED_ID, V_COST_DRIVER_CODE, LINE_OF_BUSINESS_CODE, V_DATA_ORIGIN, F_IBF_ACCOUNT_IND, V_INTERNAL_CUST_REF_CODE)

While analyzing the data, have queried the STG_GL_DATA table and there are duplicate records for the Primary Key (excluding the new three columns which are part of the PK).

How should the PK index be updated?

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
References


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