EGL9.2: Commitment Control Ledger/Activity Integrity (GLX8011) Report Displays No Results Due to Incorrect SETID Reference

(Doc ID 2372652.1)

Last updated on MARCH 12, 2018

Applies to:

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

Symptoms

Issue :

When running Commitment Control Ledger/Activity Integrity (GLX8011) Report, the following code is executed:

18: &RecActTAO = CreateRecord(Record.GL_R8011_VW);
19: &RecActTAO2 = CreateRecord(Record.KK_ACTIVITY_LOG);
20: &SetID = GetSetId(Field.BUSINESS_UNIT, KK_REPORT_AET.BUSINESS_UNIT, Record.GM_KK_EXP_VW, "");
Fetch Field: KK_REPORT_AET.BUSINESS_UNIT Value=50500
21: &SQLStr = "%SELECTALL(:1 A) WHERE A.BUSINESS_UNIT = :2 and Exists (Select 'X' From PS_LED_GRP_LED_TBL where Ledger = A.Ledger and Ledger_group = :3 and Setid = :4)";
22: &SQLStr = &SQLStr | KK_REPORT_AET.AE_WHERE_LONG1 | KK_REPORT_AET.AE_WHERE_LONG1;
Fetch Field: KK_REPORT_AET.AE_WHERE_LONG1 Value= and A.BUDGET_PERIOD = ' '
Fetch Field: KK_REPORT_AET.AE_WHERE_LONG1 Value= and A.BUDGET_PERIOD = ' '
23: &SQLSel = CreateSQL(&SQLStr, &RecActTAO, KK_REPORT_AET.BUSINESS_UNIT, KK_REPORT_AET.KK_LEDGER_GROUP, &SetID);
Cur#3.24019.notSamTran RC=0 Dur=0.000002 Open Cursor Handle=0000000000B7AB40
Fetch Field: KK_REPORT_AET.BUSINESS_UNIT Value=50500
Fetch Field: KK_REPORT_AET.KK_LEDGER_GROUP Value=CC_PRJ
Cur#3.24019.PFNDEV RC=0 Dur=0.000000 Bind-1 type=2 length=5 value=50500
Cur#3.24019.PFNDEV RC=0 Dur=0.000000 Bind-2 type=2 length=6 value=CC_PRJ
Cur#3.24019.PFNDEV RC=0 Dur=0.000001 Bind-3 type=2 length=5 value=50500

Therefore, when the "WHERE A.BUSINESS_UNIT = :2 and Exists (Select 'X' From PS_LED_GRP_LED_TBL where Ledger = A.Ledger and Ledger_group = :3 and Setid = :4)" is executed,
it returns no results due to the wrong SETID being populated in the prompt. 

- PS_GM_KK_EXP_VW:  Parent Budget (CC_PRJ) recorded under SetIDs <> SHARE
- PS_LED_GRP_LED_TBL:  Ledger Group (CC_PRJ) defined under SetID = SHARE

Expected Behavior:

It should be getting the SETID from the SET CNTRL REC for LED_GRP_LED_TBL and it would get the correct SETID result.

Steps to replicate :

1. Navigate to Commitment Control > Review Budget Activities > Budget Overview
2. Click 'Ledger/Activity Log Integrity' link

Note:  Support is unable to replicate the issue as demo data does not post any discrepancy between PS_LEDGER_KK and PS_KK_ACTIVITY_LOG tables.

Changes

 

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