Updating Order With Custom Template Causing Price Override
(Doc ID 2973271.1)
Last updated on SEPTEMBER 14, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
In MFCS 19.3.016.1.2
Updating order with custom template causing price override
When an order is updated using the custom template, SVC_ORDDETAIL.UNIT_COST incorrectly updated. This is causing an Invoice to PO Cost Mismatch in IMCS due to cost variances. The PO price in MFCS does not match the Invoice (and order price) from SCM.
Steps To Recreate:
1. Have a PO in 'W' status with multiple items so you can have different values in ORDLOC.UNIT_COST field for the PO.
2. Using CUSTOM_PURCHASE_ORDER_TEMPLATE, try to set PO status to 'A' and just update Order Details using Action as 'Update' with no change in values on the worksheet for Order Details.
3. Notice that SVC_ORDDETAIL.UNIT_COST is updated to same value for all the items.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |