EGL 8.9+: GLPCLOSE Process Running in SQLRT Error in GLPCFWDB-FB000 INSERT When PS_LEDGER.AFFILIATE <> ' ' and InterUnit Is Not Used. (Doc ID 1297121.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.9 and later
Information in this document applies to any platform.
****Checked for Relevance on 15-AUG-2012****
****Checked for Relevance on 20-JAN-2014****

Symptoms

On : 8.9 version and later, Closing

When attempting to run GLPCLOSE the following error occurs.

ERROR
-----------------------
SEVERE ERROR IN PGM:(5820,6) PI(123456) Program(GLPCFWDB) SQLRT error in GLPCFWDB-FB000 INSERT.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Navigate to General Ledger > Close Ledgers > Request Ledger Close.

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