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

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

ENVIRINMENT
----------------------
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

ISSUE
----------------------
GLPCLOSE runs to below error


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


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

Changes

 Upgrade to 9.2 PUM12

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