My Oracle Support Banner

Load From STG_<Table> to FSI_D_<Table> Gets Error 'ORA-00904 "DIM_GENERAL_LEDGER_B"."GL_ACCOUNT_ID": invalid identifier' (Doc ID 3020824.1)

Last updated on MAY 16, 2024

Applies to:

Oracle Financial Services Cash Flow Engine Cloud Service - Version 23B and later
Oracle Financial Services Profitability and Balance Sheet Management Base Cloud Service - Version 23B and later
Oracle Financial Services Funds Transfer Pricing Cloud Service - Version 23B and later
Oracle Financial Services Profitability Management Cloud Service - Version 23B and later
Information in this document applies to any platform.
Oracle Financial Services Profitability and Balance Sheet Management Cloud Service (PBSMCS)

Symptoms

When executing the Instrument Data Loader to load data from STG_LIABILITY to FSI_D_LIBILITY, the Batch Task is Successful but no rows are loaded in the target table.

Reviewing the Batch log messages, the following error exists after the final merge is formed:

Error in the loader for STG_LIABILITY TO FSI_D_LIABILITY . ORA-00904:
"DIM_GENERAL_LEDGER_B"."GL_ACCOUNT_ID": invalid identifier ORA-06512: at
"PBSMDD.PKG_PROCESSING_DATA_LOADER", line 1003

The error causes the load to fail.

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.