My Oracle Support Banner

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 later
Information 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


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