PO With No Change Order Is Updated as Having One After running PO_DISPATCH that Includes Both a PO with NO Change Order and One with a Change Order (Doc ID 2887924.1)

Last updated on MARCH 06, 2023

Applies to:

Symptoms

A PO that DOES NOT have a change order on it is recorded as having a change order on it after running PO_DISPATCH that included both a PO with NO change order and one with a change order.


Steps
1) Go to Setup Financials / Supply Chain -> Business Unit Related -> Purchasing -> Purchasing Options. Click on Dispatch Method.

2) Ensure that Transmit Change Orders is selected. Click ok and when returned to the main page, save.

3) Now go to Suppliers -> Supplier Information -> Add/Update -> Suppler and choose any supplier. Click on correct history. Click on Address tab.

4) Scroll down on the page and enter an email id. Click on the Location tab.

5) On the location tab click on Procurement

6) On the procurement page, scroll down and click on Dispatch methods

7) On the procurement page, change the PO dispatch method to email. Click ok at the bottom of the page and when returned to the main supplier page, click on save.

8) Create a PO using the BU/Supplier changed in previous set up steps. Budget check and/or approve if your set up requires it. (AWE and KK not necessary for this replication.) DO NOT DISPATCH.

9) Create a 2nd PO exactly like the previous one. Budget check and/or approve if your set up requires it.

10) Dispatch the **2nd** PO ONLY. Choose POXMLP on the process scheduler request page. Purchasing -> Purchase Orders -> Dispatch POs

11) Pull the PO back up note that status = Dispatched. Click on the Change Order icon

12) Enter comments in the PO Reference field and save the PO. Add reason code info and click on OK.

13) Review the PO header. PO Status is set back to approved and change order = 1

14) Now dispatch BOTH POs together using BU/Supplier ID/Date options and approved status. Click on Run. Choose POXMLP again.

15) Query the PO_DISPATCHED table for both POs

Note that the first PO – that DID NOT have a change order done it has CHNG_ORD_BATCH = 1 and it should NOT. Also note that PO_DISPATCHED.FILENAME has the correct change order suffix captured for the first PO in the results. In this case 0. The issue is with PO_DISPATCHED.CHNG_ORD_BATCH – which is 1 for the first row.

Please see replication steps here.

Disclaimer: In the <images, examples, video> and/or the attached document, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database.  Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle.

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.