My Oracle Support Banner

EGL 9.2: Year End Close Process(GLPCLOSE) Fails With 'ORA-00904: "A"."POSTED_TRAN_CR": invalid identifier' Error In GLPCFWDB-FB000 INSERT (Doc ID 2251750.1)

Last updated on FEBRUARY 06, 2019

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

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.