Getting Invalid Results From Purchase Order Line Level Close Entry Events - Amounts are not Balanced
Last updated on JANUARY 31, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.
When processing PO line level close the EE process causes invalid results.
When budget check/entry event is run after selecting one of the PO lines for close the line that is marked for close creates unbalanced POPOST entries. Before the PO line is closed there are seq 1 and 2 entries on EE_PO_ACCTG_LN, that balance each other out. But after closing, only the seq 1 entry is posted.
This only happens on a PO Line close. When the entire PO is closed the accounting is correct. Also, if a change is made to increase one of the lines requiring a budget check and entry event the accounting is created correctly.
It should either not post any of these entries (as it is closed) or post both seq 1 and 2 so that they net to 0.
The issue can be reproduced at will with the following steps:
1. Create PO with 2 lines (Purchasing > Purchase Orders > Add/Update PO's)
2. Approve and Budget Check
3. Run Entry Event (Purchasing > Purchase Orders > Entry Event Request)
4. Dispatch PO
5. Go to Buyers Workbench and select the PO line for close (Purchasing > Purchase Orders > Buyer's Workbench)
6. Budget Check
7. Run Entry Event
8. Query EE_PO_ACCTG_LN. Seq 2 is not posted.
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