PV_REQ_LN_XREF. KEY1_FLD_VAL Appears To Get Modified by Approval Workflow Framework (AWE) Leading To Incorrect Information Getting Dispatched To Vendor. (Doc ID 1515098.1)

Last updated on MARCH 10, 2016

Applies to:

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

Symptoms

In testing with a direct connect vendor the PV_REQ_LN_XREF.KEY1_FLD_VAL is getting changed to the value of the first line when using workflow. This will lead to incorrect information getting dispatched to the vendor.

 

Replication steps:

  1.   Setup AWE for Requisitions
  2.   Setup Direct Connect for external supplier
  3.   Create Requisition
  4.   Select Web and punchout to vendor site
  5.   Select items and return Cart content to PeopleSoft
  6.   On Review and Submit tab click on Save and Preview
  7.   SELECT * FROM PS_PV_REQ_LN_XREF WHERE REQ_ID is test requisition
  8.   Note KEY1_FLD_VAL and see that they were the original part IDs brought in from supplier
  9.   Go back to requisition and click on Submit button routing the requisition to the approver
  10.   Again SELECT * FROM PS_PV_REQ_LN_XREF WHERE REQ_ID is test requisition
  11.   Note KEY1_FLD_VAL has now changed to the value of the first line; both line now have the same number.

 

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