My Oracle Support Banner

EGL9.2: Create GL Reconciliation (GLRN_CREATE) Process Fails With "Conversion failed when conve rting the varchar value 'yyyy-mm-dd' to data type int. (SQLSTATE 22005)" Error (Doc ID 2447360.1)

Last updated on APRIL 23, 2019

Applies to:

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

Symptoms

Issue:
-------

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 to Replicate:
---------------------

1. Navigation: Main menu > General Ledger > Perform Reconciliation. 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.