EGL9.2: Upgrade Data Conversion ABENDED At UPG_GL.GLC04.InsLedFl - Record PS_LED_FLDS_TBL Missing Field LEDGER_GROUP (Doc ID 1939693.1)

Last updated on NOVEMBER 20, 2016

Applies to:

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

***Checked for relevance on 10-SEP-2016***


Symptoms

Issue:
-------


While upgrading from 9.1 to 9.2, Task 5-13-3: Performing Data Conversion Concurrently failed at step Step UPG_GL.GLC04.InsLedFl due to the missing record-field LED_FLDS_TBL.LEDGER_GROUP. This field does not exist in the database table PS_LED_FLDS_TBL.

Error:
------
 
Stmt #: 1703 Error Position: 408 Return: 904 - ORA-00904: "B"."LEDGER_GROUP": invalid identifier
Failed SQL stmt: INSERT INTO PS_LED_FLDS_TBL (SETID, LEDGER, FIELD_SEQUENCE, CHARTFIELD, RECNAME, RECNAME_NO_EFFDT, DETAIL_CHARTFIELD, HOW_FIELD_SPECIFY, TREE_NAME, TREE_LEVEL, BALANCE_FLAG) SELECT A.SETID, ' ', (B.FIELD_SEQUENCE+1), D.FIELDNAME, 'DATE_CODE_TBL', 'DATE_CODE_TBL', ' ', '1', ' ', ' ', 'N' FROM PS_LED_GRP_TBL A, PS_LED_FLDS_TBL B, PS_LED_TMPLT_TBL C, PSRECFIELDDB D WHERE A.SETID = B.SETID AND A.LEDGER_GROUP=B.LEDGER_GROUP AND B.CHARTFIELD='GL_ADJUST_TYPE' AND C.LEDGER_TEMPLATE = A.LEDGER_TEMPLATE AND D.RECNAME = C.RECNAME AND D.FIELDNAME ='DATE_CODE'
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt854-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 408 Return: 904 - ORA-00904: "B"."LEDGER_GROUP": invalid identifier

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