My Oracle Support Banner

PO Cost Picks Up Cost From ITEM_SUPP_COUNTRY Instead Of The Cost From ODS File (Doc ID 2542730.1)

Last updated on OCTOBER 07, 2019

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Goal

Purchase Order (PO) unit cost is not updated from ods file (svc_orddetail), instead it is ITEM_SUPP_COUNTRY.UNIT_COST which is incorrect if the service table is injected with Order details along with the cost of the items to be used for Purchase.

Steps to Recreate
1. Create a new Purchase Order ods file.
2. Notice purchase order uploaded to SVC_ORDHEAD and SVC_ORDDETAIL tables.
3. Notice SVC_ORDDETAIL.UNIT_COST is correct, from ods file.
4. Process the Purchase order into RMS.
5. Notice RMS ORDLOC.unit_cost contains different unit cost value.
6. Upon analysis, it is same value as ITEM_SUPP_COUNTRY.UNIT_COST.

Solution

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
Goal
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.