My Oracle Support Banner

Encumbrances Are Not Liquidated Correctly (Doc ID 2452841.1)

Last updated on SEPTEMBER 27, 2018

Applies to:

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

Symptoms

User creates a PO, budget check, and dispatch it.

Create a voucher for partial amount and post.

Add a new KK Ledger under Ledgers for a Unit and then change order the PO for an amount increase.

After the closing the PO the lines the encumbrances are not liquidating correctly.


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


Scenario 1:
1. Create PO for $100.00 and budget check and dispatch.
2. Create a Voucher for the PO for $20.00 budget check and post.
3. Add a new KK ledger under ledgers for a Unit
4. Do a change order on the PO increasing the amount to $150.00
5. Close the PO.
6. Verify that PO is not liquidated correctly on all the lines

Scenario 2:

Referenced budget amount is not updated correctly when a new commitment control ledger is added after the PO is created.

The liquidation amount left on the new ledger is updated on all the ledgers.

The SQL that updates the liquidation amount on PS_KK_ACTIVITY_LOG or PS_KK_LIQUIDATION is ignoring the LEDGER/LEDGER_GROUP criteria in the where clause and updating the same amount on all the ledgers.

1. Create PO for $100.00 and budget check and dispatch.
2. Create a Voucher for the PO for $20.00 budget check and post.
3. Add a new KK ledger under ledgers for a Unit
4. Do a change order on the PO increasing the amount to $150.00
5. Create Voucher for $80.00 and finalize.
6. Budget check and post the voucher
7. Verify that referenced budget amounts are not correct.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.