My Oracle Support Banner

EGL: GLPCLOSE Fails with SQLRT error in DB340-INSERT ACCT TMP (Doc ID 2026855.1)

Last updated on MARCH 02, 2018

Applies to:

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


Apps release and bundle level - FSCM 9.2 , Image 12
Tools version and patch level - 8.53.09
Database type and version - oracle 11g
Process scheduler OS version -Windows 2012 R2

GLPCLOSE runs to below error

10 11:25:11PM Processing requests started.
10 11:25:11PM Processing business unit CORP, Closing rule .
10 11:25:11PM Unclosing for fiscal year 2014, Ledger ACTUALS started.
40 11:25:12PM SQLRT error in DB340-INSERT ACCT TMP.
10 11:25:24PM File list for process instance 2848410 is empty. (63,103)
11:25:24PM Successfully posted generated files to the report repository

The issue can be reproduced at will with the following steps:
1. Upgrade to 9.2 PUM12
2. Run testing on ledger close.


 Upgrade to 9.2 PUM12


To view full details, 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 a vibrant support community of peers and Oracle experts.