EGL: Creating Reconciliations ABENDED At Step GLRN_ASSGN.prcsAct.autoApp2 (SQL) -- RC = 8601 (108,52) (Doc ID 2110730.1)

Last updated on MARCH 16, 2023

Applies to:

Symptoms

On : 9.2 version, Functionality

Running Create Reconciliation process and get the following error:

ERROR
-----------------------
PSAESRV started service request at 11.44.39 2015-11-30


Create Reconciliation processing has begun. (5760,41)

Start request 1. (5760,39)

File: e:\....SQL error. Stmt #: 1703 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier "A.BUSINESS_UNIT" could not be bound.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt: UPDATE PS_GLRN_RECON_TBL SET GLRN_RECON_STATUS = '5' WHERE GLRN_SET = 'PREPAID' AND GLRN_RULE = 'PREPAID' AND AS_OF_DATE = '2015-01-01' AND PROCESS_INSTANCE = 111111 AND A.BUSINESS_UNIT = 'xxxxxx' AND CURRENCY_CD <> ' ' AND CALC_NET_AMT <= 200 AND CALC_NET_AMT >= (0 - 200)

Process 2283887 ABENDED at Step GLRN_ASSGN.prcsAct.autoApp2 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 11.44.39 2015-11-30



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup Account Recon Configuration.

2. In the Reconciliation Rule, check Auto Approve if Balance option, and select <= to value like 200.
2. Create Reconciliation Set.
3. Run Create Reconciliation process.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.