EGL 9.2: GLPCLOSE Fails With SQLRT Error In GLPCFWDB-FB000 INSERT ERR Rtncd=8010 Msg=Column Not Found or rtncd=904 msg=ORA-00904: "A"."POSTED_TRAN_CR": invalid identifier

(Doc ID 2251750.1)

Last updated on JUNE 21, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run COBOL Close process, the following error occurs.

ERROR
-----------------------
GLPCFWDB_I_FWDBLED
12:52:00.722 7275 0.016 0.000 #27 RC=0 COM Stmt=INSERT INTO PS_LEDGER_BUDG (BUSINESS_UNIT,LEDGER,ACCOUNT,ALTACCT,DEPTID,OPERATING_UNIT,PRODUCT,FUND_CODE,CLASS_FLD,PROGRAM_CODE,BUDGET_REF,AFFILIATE,AFFILIATE_INTRA1,AFFILIATE_INTRA2,CHARTFIELD1,CHARTFIELD9,CHARTFIELD8,CHARTFIELD7,CHARTFIELD6,CHARTFIELD5,CHARTFIELD4,CHARTFIELD2,CHARTFIELD3,BOOK_CODE,GL_ADJUST_TYPE,BUDGET_PERIOD,SCENARIO,CURRENCY_CD,PROJECT_ID,STATISTICS_CODE,PROCESS_INSTANCE,DATE_CODE,FISCAL_YEAR,ACCOUNTING_PERIOD,POSTED_TOTAL_AMT,POSTED_TOTAL_DR,POSTED_TOTAL_CR,POSTED_BASE_AMT,POSTED_TRAN_AMT,POSTED_TRAN_DR,POSTED_TRAN_CR,BASE_CURRENCY,DTTM_STAMP_SEC) SELECT 'US001',A.LEDGER,A.ACCOUNT,A.ALTACCT,A.DEPTID,A.OPERATING_UNIT,A.PRODUCT,A.FUND_CODE,A.CLASS_FLD,A.PROGRAM_CODE,A.BUDGET_REF,A.AFFILIATE,A.AFFILIATE_INTRA1,A.AFFILIATE_INTRA2,A.CHARTFIELD1,A.CHARTFIELD9,A.CHARTFIELD8,A.CHARTFIELD7,A.CHARTFIELD6,A.CHARTFIELD5,A.CHARTFIELD4,A.CHARTFIELD2,A.CHARTFIELD3,A.BOOK_CODE,A.GL_ADJUST_TYPE,A.BUDGET_PERIOD,A.SCENARIO,A.CURRENCY_CD,A.PROJECT_ID,A.STATISTICS_CODE,0000134951,A.DATE_CODE,2017, 0,A.POSTED_TOTAL_AMT, 0.0, 0.0,A.POSTED_BASE_AMT,A.POSTED_TRAN_AMT,A.POSTED_TRAN_DR,A.POSTED_TRAN_CR,A.BASE_CURRENCY,'2017-03-16 12:51:11.360' FROM PS_CLO_ENBD_TMP001 A WHERE BUSINESS_UNIT='US001' AND LEDGER IN ('BUDGETS','FORECAST','BD_ACTUALS') AND (POSTED_TOTAL_AMT<>0 OR POSTED_BASE_AMT<>0)
12:52:00.730 7276 0.000 0.000 #27 RC=8010 EXE
12:52:00.743 7277 0.016 0.000 #0 RC=8010 ERR rtncd=8010 msg=Column not found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create YE Closing Rule using Ledger Template BUDGET
2. Run request GL > Close Ledgers > Request Ledger Close
3. Select GLPCLOSE COBOL process
4. Process ends with error

See replication steps attached.

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