PO_LINE_DIST_NP Does Not Update BUDGET_LINE_STATUS When Updating CF On Budget String

(Doc ID 2345563.1)

Last updated on JANUARY 04, 2018

Applies to:

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

Symptoms

On : 9.2 version, Other

ACTUAL BEHAVIOR
---------------
PO_LINE_DIST_NP does not update BUDGET_LINE_STATUS when updating CF on Budget String

When a user updates their chartfield string, the PO_POENCNP is not updated. This causes the Sales tax to be recorded to the wrong budget journal string.

* Attached is a copy of query results for each transaction change from our Test Environment (refreshes daily from Production)
* I was able to replicate this in DEMO. Let me know if you would to attach similar documentation from DMO.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Set up Sales Tax for BU to be NonProrated

1. Create a PO with sales tax & Budget Check
2. Run query against PO_LINE_DIST_NP
3. View Commitment Control > Review Budget Exception > Activity Log for PO_POENCNP
5. Change some of the PO's CF keys in the budget string & Budget Check
6. Run Query against PO_LINE_DIST_NP
---------------- BUDGET_LINE_STATUS is still "V" and CF Keys are not updated
7. View Commitment Control > Review Budget Exception > Activity Log for PO_POENCNP
---------------- CF Keys are Not Updated
8. Update the QTY on PO Line & Budget Check
9. Run Query against PO_LINE_DIST_NP
--------------- BUDGET_LINE_STATUS is now "N" and CF Keys are updated
10. View Commitment Control > Review Budget Exception > Activity Log for PO_POENCNP
--------------- CF Keys are Updated

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the account changes on the PO_POENCNP, this makes the tables out of sync.

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