EGL: Consolidation For Summary Ledger Fails With Multiple Errors When Separate DR/CR Is Enabled.

(Doc ID 1596264.1)

Last updated on JANUARY 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.

Symptoms


Issue:
-------

When attempting to run the consolidation process (GLPOCONS) for summary ledgers the following error encountered if separate DR/CR is enabled.

Error:
------
Error 1:
SQLRT error in GLPOELIM-VB200 S_CLOGBAL SELECT.
SQLRT error in GLPOPLOG-JA000 UPDATE MESSAGE.


Error 2:
2. SQLRT error in GLPOSLED-CA000 INSERT LED TMP:


Error 3:
3. SQLRT error in GLPOSLED-EE000 INSERT SUM LED.

Steps to Replicate:
---------------------
1. Navigate to General Ledger > Consolidate Financial Data > Consolidation > Request Consolidation and run GLPOCONS.
Process is running in Error and Message Log is showing:
SQLRT error in GLPOELIM-VB200 S_CLOGBAL SELECT.
SQLRT error in GLPOPLOG-JA000 UPDATE MESSAGE.

2. To fix SQLRT error in GLPOELIM-VB200 S_CLOGBAL SELECT customer has to define Balancing Chartfields for the Summary Ledger.
Since you cannot define Balancing Chartfields for Summary Ledger online, run the following SQL:

UPDATE PS_LED_GRP_FLD_TBL
SET BALANCE_FLAG = 'Y'
WHERE LEDGER_GROUP= 'Z_ACTDEP'
AND CHARTFIELD IN ('BUSINESS_UNIT','CURRENCY_CD');

3. Run the consolidation process again.
Process is running in Error again and Message Log is showing:
SQLRT error in GLPOSLED-CA000 INSERT LED TMP.

4. To fix SQLRT error in SQLRT error in GLPOSLED-CA000 INSERT LED TMP customer has to define the separate dr/cr fields to allow nulls. Run the following SQL:
ALTER TABLE PS_Z_ACTDEP_TMP MODIFY(POSTED_TOTAL_DR NULL, POSTED_TOTAL_CR NULL, POSTED_TRAN_DR NULL, POSTED_TRAN_CR NULL);
ALTER TABLE PS_Z_LEDGER_ACTDEP MODIFY(POSTED_TOTAL_DR NULL, POSTED_TOTAL_CR NULL, POSTED_TRAN_DR NULL, POSTED_TRAN_CR NULL);

5. Run the consolidation process again.
Process is running in Error again and Message Log is showing:
SQLRT error in GLPOSLED-EE000 INSERT SUM LED.


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