PO Encumbrance Balance Zero (0.00) On PO Inquiry Page (Add/Update POs) (Doc ID 2281888.1)

Last updated on JUNE 29, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

PO Encumbrance balance zero (0.00) on PO Inquiry page (Add/Update POs)

After budget checking, certain purchase orders showing zero (0) encumbrance balance.

When looking at backend page: PO_LINE_INQ field PO_INQ_WRK.ENCUM_BALANCE.RowInit PeopleCode pointed to PS_PO_ENCUM_DIS_VW as source for encumbrance balance.

Looking at table PS_PO_KK_VW.ENCUM_BALANCE field pointed to KK_LIQUIDATION.FOREIGN_AMOUNT. See attachment for table info. (KK_LIQUIDATION_9632.xls).

Looking at configuration Ledgers For A Unit (Set Up Financials / Supply Chain -> Business Unit Related -> General Ledger -> Ledgers For A Unit -> Commitment Control Options tab) we see that detail Ledger group ACTUALS has Commitment Control Detail Ledger DETAIL checked off. 

In KK_LIQUIDATION table there is no rows for DETAIL ledger group. However, there is row for CAP_DETAIL, CAP_EXP and CAP_SUM.

How does this DETAIL row get populated?


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see encumbrance on PO's project related when the detail flag is not set.  

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