My Oracle Support Banner

Unit Cost Of Purchase Order Gets Updated Incorrectly When Using PO Induction (Doc ID 2478678.1)

Last updated on FEBRUARY 27, 2019

Applies to:

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

Symptoms

Unit cost of all the items on the purchase order is getting changed to the cost of first item in the template, when there are multiple items on the PO.

This issue will occur when unit_cost is configured as not mandatory field in S9T_TMPL_COLS_DEF table.

Steps To Reproduce:

  1. Ensure values in S9T_TMPL_COLS_DEF for PO Induction - TEMPLATE_KEY='PURCHASE_ORDER_DATA' and WKSHT_KEY='ORDDETAIL' and COLUMN_KEY='UNIT_COST' and MANDATORY='Y'.
  2. Create a new PO in approved status using PO induction (Upload Orders from File) having multiple items.
  3. Check ORDLOC data - unit_cost looks good.
  4. Update values in S9T_TMPL_COLS_DEF for PO Induction ( make unit_cost as not mandatory).
  5. Download the newly created Order using Order Download from RMS.
  6. Update the Order with status as 'W' And Re-Approve='Y' and upload again.
  7. Check ORDLOC data after upload. Note that unit_cost has been updated with a single value of first item.

 

Changes

 

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