PRC:PO: Purchase Order/Change Order Validation Error From BPM Notification (Doc ID 2886029.1)

Last updated on DECEMBER 31, 2023

Applies to:

Goal

Scenario/Question 1:
The user is currently testing a bulk update for POs via webservices.
The goal is to align PO distribution expenditure organization with the same from the project level.
Testing has been successful, change orders are created successfully.
We are now having issues with the failed change orders, which are going into cancelled status due to different reasons (requested no longer valid, deliver-to location isn't valid, value of the attribute Bill-to Location isn't valid, etc.)
This validation errors are visible in the BPM notification, but it is not feasible to go one by one in BPM Administrative Tasks and check, for obvious reasons.
We need to extract for all this failing change orders their validation errors.

Please let us know the table(s) from where we can extract the validation errors.

Question 2

To add to the bellow, the user already checked PO_ACTION_HISTORY, but there is only NOTE column populated with "The change order 10 has 1 or more validation errors. (PO-2055683)", without the necessary validation error details. Also, ERROR_CODE here is blank.
Checked also the WF tables (Ref Doc ID 2010398.1), but couldn't find validation errors there as well.

So how can we retrieve this validation error data for a specific change order which fails? Where is the data stored?
 

Solution

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