While doing an ePro Change Request, when you Decrease And Increase a Line the Decrease Gets Stuck In Pending/initialized. (Doc ID 2847971.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

Symptoms

The change request with just a decrease auto approves as it should since it does not need to resubmit through workflow. If we put in a change request for an increase line and decrease line, the decrease line does not auto approve and gets stuck in pending/initialized. Even if they approve the change order, the decrease line does not get picked up and approved.


The issue can be reproduced at will with the following steps:
1. Created a new multi-line requisition
2. Navigate to Monitor Approvals and approve the requisition
3. Manage Requisitions- The requisition is approved and budget checked.
4. Copy the requisition to a PO
5. Save the PO, budget check and dispatch it.
6. Navigate to Manage Requisitions and select Edit from Dropdown and click GO
7. Change the Qty on Line to 20 and Decrease the qty on line 3 to 25.
8. Enter reason code and click Ok
9. Line 1 is routed for approval. Line 3 does not require approval per the workflow setup.
10. Review Change Requests shows our requisition with Requisition Approval Status of Pending and Change Request Status of Initialize
11. Monitor Approvals—approve the requisition.
12. The Change Status for Line 1 is R and for Line 2 it’s I for initialize
13. Approve Change Requests- Approved the change order
14. Run Change Order process
15. After running the Change Order Process,  I reviewed the PV_CHNG_RST_DTL table where it shows the APPR_STATUS = ‘A’ for line item 1 and that is the one that I increased the dollar amount on. The REQ_CHNG_STATUS = ‘C’ for line item 1 and that is the one that I increased the dollar amount on.  For Line 3 that I decreased the dollar amount on, the APPR_STATUS remains ‘P’ and the REQ_CHNG_STATUS remains ’I’.    This tells me that the Change Order Process just ignores the decrease line because we have it set to not require approval when a decrease is done.  NOTE:  If you only do a decrease and not both an increase and a decrease, it works properly.  I believe it’s because the system does not require the line item decrease to be budget checked; therefore, not changing the APPR_STATUS to A from P.
 

Changes

Cause

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