PO Encumbrance Balance Zero (0.00) On PO Inquiry Page (Add/Update POs)
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.
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?
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms