PO Uploaders Always Putting Entry In Deal_calc_queue For Any Update On PO (Doc ID 3019797.1)

Last updated on APRIL 30, 2024

Applies to:

Symptoms

On : 19.3 version, Merch - Procurement

ACTUAL BEHAVIOR
---------------
Prod: PO uploaders always throws putting entry in deal_calc_queue

We have a massive problem where we see that any form of update through PO uploaders (be it the base PO uploader or a custom PO uploader) is always putting an entry in deal_calc_queue table. If you do any updates to the PO using any PO uploader, it always throws a warning message 'Applicable deals will be applied to this order during the next batch run.'

Now this a big implication. Our business do not want the unit cost on the items in the PO to change. Whenever business does a cost change, they always ensure that Order Recalculation does not happen. This however means that the supplier cost on the item has changed. Now, when PO updates are done later through PO uploaders, because of the entry in deal_calc_queue, it seems orddscnt batch is updating the unit cost on the PO with the latest supplier cost. This impacts Invoice Matching, WAC (when receipted) and other business processes as well when this information is sent downstreams. The supply chain team has been advised not to use PO uploaders further for PO updates until this is resolved, hence this is a P1.

Can you please check if this is a bug or not that why any form of PO update through uploaders would create an entry in deal_calc_queue when the same updates done through UI is not creating any entry in deal_calc_queue? What can be done to avoid the same?

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a PO in RMS and approve it. Do not ship the PO.
2. Create a Cost change on the item in the PO (same supplier) with order re-calculation not enabled.
3. After nightly batch run, check the unit cost on the PO, it should not have changed.
4. Use the PO uploader to update any field on the PO. it throws a warning 'Applicable deals will be applied to this order during the next batch run.' and creates an entry in deal_calc_queue table.
5. After next nighty batch, check the unit cost on the PO. it is updated now.

Cause

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