Operator Information (OPRID) Not Stored When Buyer Approves Purchase Order Acknowledgement (EDX) (Doc ID 2008702.1)

Last updated on JULY 07, 2015

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When the Buyer approves the EDX Purchase Order Acknowledgement (POA) by clicking the Approve button in page Manage PO Acknowledgements, the Reviewed flag is automatically checked but the Operator ID field (OPRID) is not populated in the PO_HDR_EC table.

 


Steps to Replicate Issue:

1. SETTINGS
-Enable XML Publisher
-Buyer Accepted POA Sources and All Other Sources - selected
-POA Required - selected
-EDX POA
Node E910G2AU is active for Purchase_Order_Dispatch and Purchase_Order_Acknowledgment.
Queue definition - Purchase Order - status Run.
Services, handlers, service operations - Purchase Order Dispatch, Purchase Order Acknowledgement = active.
Batch Publish Rules for PO Dispatch- Status is Active. Chunking Rule ID is Business Unit.
Record Mapping, Batch programs.
Map Chunking Rules for Business Unit- Status is Active.
POA Routings - Active.
Vendor settings - POA is required.

2. FLOW
I. Create PO with mentioned vendor, buyer and items and dispatch through EDX method.
-Go to PeopleTools- Integration Broker- Handler Tester. In the handler tester, open the PURCHASE_ORDER_ACKNOWLEDGEMENT and click the button “Convert tree to xml”. Use a sample XML for EDX data entry.
-Execute Event, returned result should be Done.
-Go to Manage PO Acknowledgements and click Search. Enter the Purchase Order Link. 1 EIP is generated. Page is PO_POA_HDRERR_STG.
-Pick a status and click Approve without checking Reviewed. Reviewed is automatically checked when clicking Approve.
-Check in SQL Developer table PS_PO_HDR_EC. OPRID is not populated.

II. Create a second scenario with another PO with the same vendor, buyer, items, BU. Dispatch it through EDX, change it through Handler Tester.
-Go to Manage Purchase Orders. Check Reviewed before clicking Approve.
-Check in SQL Developer table PS_PO_HDR_EC. OPRID is populated when Reviewed box is checked before approving.

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