Purchase Orders (PO) are Stuck IN PROCESS After Change Request Data for the PO Has Been Purged (Doc ID 280877.1)

Last updated on JULY 05, 2023

Applies to:

Symptoms

PO's are stuck IN PROCESS that are connected to Requisition Change Requests that have been submitted for the Requisition.

Steps to Reproduce the issue
---------------------------

1. Create a requisition in iProcurement with an item that will automatically get created on a purchase order. The requestor should have an e-mail associated to
their id (both HR and in System Administrator).

2. Make sure the requisition is approved.

3. Once approved, the requisitioner should receive an e-mail notification of the approval.

4. Verify that a purchase order is created and approved.

5. The requisitioner makes a change to the requisition and submits that change.

6. Verify that the requisition change is approved.

7. Once approved, the buyer should receive a notification that there is a change request for the purchase order.

8. Purge Obsolete Workflow Runtime Data concurrent program is run for all Requisition and PO workflow item types

9. The buyer tries to accept the purchase order change and the error occurs:

ORA-20002: 3103: Attribute 'RESPONDER_USER_NAME' does not exist for item
'POREQCHA/322980-2471-1074'.

10. The PO is now remaining IN PROCESS status.

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.