PO_Dispatch Abends at Step PO_DISPATCH.MAIN.STEP09 (PEOPLECODE) -- RC = 8 (Doc ID 2023388.1)

Last updated on SEPTEMBER 09, 2024

Applies to:

Symptoms

 If you copy in a requisition that was created from a backorder in inventory to a purchase order it brings in the order number from the MSR.  This in turn causes an abend in PO-DISPATCH, unique constraint.

Error:

SQL error. Function:  SQLExec Error Position:  0 Return:  805 - ORA-00001:
unique constraint (EMDBO.PS_PODISPHS_TAO4) violated Statement:  INSERT INTO
PS_PODISPHS_TAO4 (PROCESS_INSTANCE, BUSINESS_UNIT, PO_ID, SHIPTO_ID, DESCR ,
BUSINESS_UNIT_OM, ORDER_NO, ORDER_INT_LINE_NO, SCHED_LINE_NBR,
SHIP_TO_CUST_ID, EFF_STATUS, COUNTR Y, ADDRESS1, ADDRESS2, ADDRESS3,
ADDRESS4, CITY, NUM1, NUM2, HOUSE_TYPE, ADDR_FIELD1, ADDR_FIELD2, A
DDR_FIELD3, COUNTY, STATE, POSTAL, GEO_CODE, IN_CITY_LIMIT) SELECT
PO.PROCESS_INSTANCE, PO.BUSINESS_ UNIT, PO.PO_ID, PO.SHIPTO_ID, PO.DESCR,
PO.BUSINESS_UNIT_OM, PO.ORDER_NO, PO.ORDER_INT_LINE_NO, PO.S CHED_LINE_NBR,
PO.SHIP_TO_CUST_ID, LOCATION.EFF_STATUS, LOCATION.COUNTRY, LOCATION.ADDRESS1,
LOCATIO

SQL error in Exec. (2,280) PO_DISPATCH.PO_Dispatch_Data.OnExecute Name:getShipTo  PCPC:5767  Statement:100

Called from:PO_DISPATCH.PO_Dispatch_Data.OnExecute  Name:fillHeader  Statement:299
Called from:PO_DISPATCH.MAIN.GBL.default.1900-01-01.Step09.OnExecute Statement:2

Process 42254 ABENDED at Step PO_DISPATCH.MAIN.Step09 (PeopleCode) -- RC = 8

42254 PO_DISPATCH MAIN Step09 PeopleCode 8

Steps to reproduce the issue:

1.  Setup the system to allow ad hoc requisitions created from MSRs  BU XXXXX

     Navigation: Inventory >Fulfill Stock Orders > Fulfillment Rules > Setup Fulfillment

2.  Added inventory BU XXXXX, this Distribution Network is used on the Ship To Location setup
     Navigation: Set Up Financials/Supply Chain >  Common Definitions >Shipping and Receiving > Distribution Network

3.  Setup Requisition Loader defaults
     Navigation:Set Up Financials/Supply Chain> Product Related > Procurement Options >Purchasing > Requisition Loader Defaults

4.  Validate Ship To Location and Distribution Network
     Navigation: Set Up Financials/Supply Chain> Product Related >Procurement Options> Purchasing> Ship To Locations

5.  Add Inventory BU
     Navigation: Set Up Financials/Supply Chain > Security > Unit by User ID

6.  Create an MSR that will create a backorder which will in turn create a requisition
     Navigation: Inventory > Fulfill Stock Orders > Stock Requests > Create/Update Stock Request

7.  Reserve the MSR
     Navigation:Inventory > Fulfill Stock Orders > Stock Requests > Reserve Materials Process

8.  Review the Fulfillment Information for the MSR
     Navigation: Inventory > Fulfill Stock Orders >Review Fulfillment >Information Stock Requests

9.  Run Replenishment to create the requisition
     Navigation: Inventory >Replenish Inventory >Create Replenishment Requests 

10. Run Requisition Loader Process

11. Open new requisition and add a supplier or it will error out

12. Copy the requisition to a new purchase order

13. Add a new line to the purchase order

14. Run this query
     SELECT A.BUSINESS_UNIT, A.PO_ID, A.ORDER_NO
     FROM PS_PO_LINE_SHIP A
     WHERE ( A.BUSINESS_UNIT = 'US001'
     AND A.PO_ID = 'PO number created')

15. Notice on the output that there is an Order No on the line created from the requisition that was copied.  This is the issue.  If you have one line with an order no and one line without dispatch will abend.

16. Run PO_DISPATCH, POXMLP ( I did not check POPO005)
17. ABENDED at Step PO_DISPATCH.MAIN.Step09 (PeopleCode) -- RC = 8

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.