R12 GLBALFIX GLUBLFXB Script Fails With ORA-00904: "FIX"."LEDGER_ID": invalid identifier (Doc ID 756987.1)

Last updated on JULY 18, 2017

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GLBALFIX
GLUBLFXB.pls


Goal

In order to run GLBALFIX script, you have run the prerequisite scripts.
GLUBLFXB.pls fails with :

LINE/COL ERROR
-------- -----------------------------------------------------------------
4654/5 PL/SQL: SQL Statement ignored
4658/18 PL/SQL: ORA-00904: "FIX"."LEDGER_ID": invalid identifier
4668/5 PL/SQL: SQL Statement ignored
4672/18 PL/SQL: ORA-00904: "FIX"."LEDGER_ID": invalid identifier


SQL> desc gl_balance_fix_gt
there is no column ledger_id in the below table that is referred as FIX in the script

Name Null? Type
----------------------------------------- -------- ----------------------------
SET_OF_BOOKS_ID NOT NULL NUMBER(15)
CODE_COMBINATION_ID NOT NULL NUMBER(15)
ACCOUNT_TYPE NOT NULL VARCHAR2(1)
BAL_SEG_VALUE NOT NULL VARCHAR2(200)
PERIOD_NAME NOT NULL VARCHAR2(15)
EFFECTIVE_PERIOD_NUM NOT NULL NUMBER(15)
PERIOD_YEAR NOT NULL NUMBER(15)
QUARTER_NUM NOT NULL NUMBER(15)
PERIOD_NUM NOT NULL NUMBER(15)
CURRENCY_CODE NOT NULL VARCHAR2(15)
ACTUAL_FLAG NOT NULL VARCHAR2(1)
ACCOUNT_COMBO VARCHAR2(2000)
BUDGET_VERSION_ID NUMBER
ENCUMBRANCE_TYPE_ID NUMBER
PROBLEM_TYPE_CODE NOT NULL VARCHAR2(30)
NEW_BALANCE_DR NUMBER
NEW_BALANCE_CR NUMBER
OLD_BALANCE_DR NUMBER
OLD_BALANCE_CR NUMBER
NEW_BALANCE_DR_BEQ NUMBER
NEW_BALANCE_CR_BEQ NUMBER
OLD_BALANCE_DR_BEQ NUMBER
OLD_BALANCE_CR_BEQ NUMBER

How to overcome this error message?

Solution

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