EGL9.2: Create Reconciliation Process(GLRN_CREATE) Abends at Step GLRN_SET.InsURDet.InsURDet With 'ORA-00904: "A"."SETID": invalid identifier' (Doc ID 2194349.1)

Last updated on DECEMBER 08, 2016

Applies to:

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

Symptoms

Issue:
--------

Create Reconciliation Process(GLRN_CREATE) Abends at Step GLRN_SET.InsURDet.InsURDet when combining 2 Chartfields - Account and Affiliate in Assignment Level and referencing in the Recon Set.

Error:
--------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 257 Return: 9 04 - ORA-00904: "A"."SETID": invalid identifier Failed SQL stmt: INSERT INTO PS_GLRN_URCF_TAO4 (PROCESS_INSTANCE, GLRN_UNIT_OF_RECON, SETID, FIELDNA ME, FIELD_VALUE, GLRN_ASMNT_LEVEL) SELECT DISTINCT 81079, 'AC', A.SETID, 'AFFILIATE', A.AFFILIATE, ' ' FROM PS_AFFILIATE_VW A , PS_CFV_SEL_TAO4 B, PS_GLRN_RULE_CFV CFV WHERE A.SETID = ' ' and B.PROC ESS_INSTANCE = 81079 and B.FIELDNAME = 'AFFILIATE' and A.AFFILIATE = B.FIELD_VALUE AND CFV.GLRN_RULE = 'SMI' AND CFV.SETID = 'SHARE' AND CFV.EFFDT = TO_DATE('2014-01-01','YYYY-MM-DD') AND B.CFV_SET = CFV.CFV_SET


Steps to replicate:
------------------------
1. Define Assignment Levels for Accounts & Affiliate combination
2. Reconciliation Rule using Chartfield Value "SMI" (include all accounts and Affiliate (US001-USLE2)
3. Create Reconciliation Set to use Reconciliation Rue: SMI, Business Unit from - To "US001"
4. Run the Create Reconciliation Process
5. Got SQL error

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