PO Dispatch Process Fails in Case of Replacement Work Order & Separate Change Order

(Doc ID 2276581.1)

Last updated on JUNE 13, 2017

Applies to:

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

Symptoms


Steps to Reproduce the Issue:

Replacement Workorder’s – PO Dispatch
1.Navigate to Manage Service Work Orders and add a new Work Order
2.Provide information in Details Tab and Cost tab and Save the Work Order .
3.Once the Work Order is saved, Work Order ID is generated and the Work Order is ready to be submitted.
4.In order to submit a Work Order, Activities have to be defined.
Define activities by visiting activities hyperlink under Cost Tab.
5.Provide activity for the WorkOrder and save .
6.If there are any Pre Approval Tasks, please complete them by visiting the Task Check List Hyperlink at the bottom right of the page.
7.Complete all eligible tasks and save and click on SERVICE WORK ORDER DETAIL hyperlink to go back to the Work Order.
8.After clicking on Submit, Work Order has to be approved in case of Approval Workflow and the Purchase Order is ready to be processed.
Click on Process Purchase Order.
9.Click on Cost Tab and click on Quick Source hyperlink to source PO.
10.Go to Sourcing Options tab and check whether PO Dispatch is on and then Click on Run Push Button.
In Order to release a Work Order, the PO sourced must be dispatched.
11.On successful RUN, the Process would Stage the Purchase Order successfully.
12.Click on Release Button
13.After release
14.Assigning New Resource
15.Replaced Work Order with new Service Provider
16.Once the Replaced Work Order is saved, Work Order ID is generated and the Work Order is ready to be submitted.
17.In order to submit a Work Order, Activities have to be defined.
Define activities by visiting activities hyperlink under Cost Tab.
18.Provide activity for the WorkOrder and save .
19.If there are any Pre Approval Tasks, please complete them by visiting the Task Check List Hyperlink at the bottom right of the page.
20.Complete all eligible tasks and save and click on SERVICE WORK ORDER DETAIL hyperlink to go back to the Work Order.
21.Click on Release Button
22.After Release, the Replacement Work Order has been released.
23.Existing Work Order has not been terminated.
24.Original PO gets linked to new replacement work order but PO amounts do not change.
25.Process a change order on the PO through Buyer Mass change. (PO number is indicative, not taken from above steps )
26.It will update the Buyer ID on the PO and put it in Approved status.
27.If we execute PO dispatch process, it failed with following error

Return: 1427 - ORA-01427: single-row subquery returns more than one row
  Statement: update ps_pohdrext_tao23 set work_order_id = ( SELECT WORK_ORDER_ID FROM PS_SPF_WORDERREC WO WHERE PS_POHDREXT_TAO23.BUSINESS_UNIT = WO.BUSINESS_UNIT AND PS_POHDREXT_TAO23.PO_ID = WO.PO_ID AND PS_POHDREXT_TAO23.PROCESS_INSTANCE = :1) WHERE EXISTS ( SELECT 'X' FROM PS_SPF_WORDERREC WO WHERE PS_POHDREXT_TAO23.BUSINESS_UNIT = WO.BUSINESS_UNIT AND PS_POHDREXT_TAO23.PO_ID = WO.PO_ID AND PS_POHDREXT_TAO23.PROCESS_INSTANCE = :2)
  Original Statement: UPDATE %Table(POHDREXT_TAO) SET WORK_ORDER_ID = ( SELECT WORK_ORDER_ID FROM PS_SPF_WORDERREC WO WHERE %Table(POHDREXT_TAO).BUSINESS_UNIT = WO.BUSINESS_UNIT AND %Table(POHDREXT_TAO).PO_ID = WO.PO_ID AND %Table(POHDREXT_TAO).PROCESS_INSTANCE = :1) WHERE EXISTS ( SELECT 'X' FROM PS_SPF_WORDERREC WO WHERE %Table(POHDREXT_TAO).BUSINESS_UNIT = WO.BUSINESS_UNIT AND %Table(POHDREXT_TAO).PO_ID = WO.PO_ID AND %Table(POHDREXT_TAO).PROCESS_INSTANCE = :1)



Error:
----------
ErrorReturn-> 280 - SQL error in Exec. (2,280) PO_DISPATCH.PO_Dispatch_Data.OnExecute Name:getWorkOrderID PCPC:14575 Statement:264
ErrorReturn-> 280 - SQL error in Exec. (2,280) PO_DISPATCH.PO_Dispatch_Data.OnExecute Name:getWorkOrderID PCPC:14575 Statement:264
Called from:PO_DISPATCH.PO_Dispatch_Data.OnExecute Name:fillHeader Statement:312
Called from:PO_DISPATCH.MAIN.GBL.default.1900-01-01.Step09.OnExecute Statement:2


Business Impact: Loss of functionality

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