Ora-00904: "dim_org_structure"."n_entity_id" Error Running T2T for FCT_LEDGER_STAT (Doc ID 1998879.1)

Last updated on APRIL 13, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics

Symptoms

On EFPA 8.0.0, when running the T2T_FCT_LEDGER_STAT, the following error is thrown:

ERROR

Log Message here 1: Wed 25 Mar 2015 03:36:25 PM IST||DEBUG||ClsUTableToTableLoad::Load, Query for fetching the number of rows : SELECT CASE WHEN count(1) = 1 THEN sum(inline_view.rec_count) ELSE count(1) END FROM ( SELECT COUNT(1) rec_count FROM VW_FSI_D_MGMT_LEDGER INNER JOIN DIM_ORG_STRUCTURE ON (VW_FSI_D_MGMT_LEDGER.N_ENTITY_ID = DIM_ORG_STRUCTURE.N_ENTITY_ID AND DIM_ORG_STRUCTURE.F_LATEST_RECORD_INDICATOR = 'Y') INNER JOIN DIM_LOB ON (VW_FSI_D_MGMT_LEDGER.N_LOB_ID = DIM_LOB.N_LOB_ID AND DIM_LOB.F_LATEST_RECORD_INDICATOR = 'Y') INNER JOIN DIM_ORG_UNIT ON (VW_FSI_D_MGMT_LEDGER.ORG_UNIT_ID = DIM_ORG_UNIT.N_ORG_UNIT_ID AND DIM_ORG_UNIT.F_LATEST_RECORD_INDICATOR = 'Y') INNER JOIN DIM_GL_ACCOUNT ON ( VW_FSI_D_MGMT_LEDGER.GL_ACCOUNT_ID = DIM_GL_ACCOUNT.N_GL_ACCOUNT_ID AND DIM_GL_ACCOUNT.F_LATEST_RECORD_INDICATOR = 'Y') INNER JOIN DIM_PRODUCT ON (VW_FSI_D_MGMT_LEDGER.PRODUCT_ID = DIM_PRODUCT.N_PRODUCT_ID AND DIM_PRODUCT.F_LATEST_RECORD_INDICATOR = 'Y') INNER JOIN DIM_COMMON_COA ON (VW_FSI_D_MGMT_LEDGER.COMMON_COA_ID = DIM_COMMON_COA.N_COMMON_COA_ID AND DIM_COMMON_COA.F_LATEST_RECORD_INDICATOR = 'Y') LEFT OUTER JOIN FSI_EXCHANGE_RATE_HIST ON FSI_EXCHANGE_RATE_HIST.FROM_CURRENCY_CD = VW_FSI_D_MGMT_LEDGER.ISO_CURRENCY_CD AND to_char(FSI_EXCHANGE_RATE_HIST.EFFECTIVE_DATE,'YYYYMMDD') = to_char(VW_FSI_D_MGMT_LEDGER.AS_OF_DATE,'YYYYMMDD') AND FSI_EXCHANGE_RATE_HIST.TO_CURRENCY_CD = 'USD' WHERE 1=1 AND VW_FSI_D_MGMT_LEDGER.AS_OF_DATE = to_date('20150325','YYYYMMDD') ) inline_view
Error Msg :-> ORA-00904: "DIM_ORG_STRUCTURE"."N_ENTITY_ID": invalid identifier

SetFetchDetails failed
Log Message here 1: Wed 25 Mar 2015 03:36:25 PM IST||SEVERE||ClsUDBConnect::executeCountQuery, Error, unable to execute count(*) query. ERROR Message: ORA-00904: "DIM_ORG_STRUCTURE"."N_ENTITY_ID": invalid identifier


There is no DIM_ORG_STRUCTURE.N_ENTITY_ID column in the Profitability 8.0 Erwin Data model.

The issue can be reproduced at will with the following steps:
1. Run the 8.0 T2T_FCT_LEDGER_STAT

Cause

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 hundreds of Community platforms