My Oracle Support Banner

EGL 9.2: GL Recon GLRN_CREATE Fails With "Conversion failed when converting the varchar value '2017-12-31' to data type int" on MS SQL Database (Doc ID 2447360.1)

Last updated on SEPTEMBER 17, 2018

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 create GL Reconciliation, the following error occurs.

ERROR
-----------------------

(GLRN_ASSGN.prcsAct.autoAppX) (SQL)
UPDATE PS_GLRN_RECON_TBL SET GLRN_RECON_STATUS = '5' WHERE GLRN_SET =
'CASH_BAL_US' AND GLRN_RULE = 'CASH_BAL' AND AS_OF_DATE = '2017-12-31' AND
PROCESS_INSTANCE = 127837  AND BUSINESS_UNIT = 'US001'  AND ((DTTM_STAMP_SEC
< '2017-12-31' - 30) OR DTTM_STAMP_SEC IS NULL)
/
-- Row(s) affected: 0
-- 10:25:39.257 Process 127837 ABENDED at Step GLRN_ASSGN.prcsAct.autoAppX (Action SQL) -- RC = 8601
ROLLBACK
/
-- 10:25:39.307 SQL Error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Conversion failed when converting the varchar value '2017-12-31' to data type int. (SQLSTATE 22005) 245



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigation: Main menu > General Ledger > Perform Reconciliation
1. Create Recon Rule and ensure the following Ledger Options are used:
 - If No Activity in Past 30 Days
 - Create Recon and Auto Approve
2. Create Reconciliation Set for above Rule
3. Run Create Recon

Replication attached.

Changes

 

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
Changes
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.