Cost Change Upload Through Induction Does Not Show up On The Cost Change Tables (Doc ID 2244828.1)

Last updated on MARCH 29, 2017

Applies to:

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

Symptoms


When performing a cost change upload via induction (source spreadsheet / destination RMS tables), the data is not created or updated in the COST_SUSP_HEAD/COST_SUSP_DETAIL tables, and thus remaining in the SVC_COST_SUSP_HEAD/SVC_COST_SUSP_DETAIL staging tables.


Steps to Reproduce:

  1. Configure the Cost change event type  to "SYNC" in COST_EVENT_RUN_TYPE_CONFIG table.
  2. Login into RMS Application.
  3. Navigate to Items ----> Item induction Screen.
  4. Select the action Upload , source as spreadsheet , destination as RMS tables , template type Cost Change.
  5. Upload a new cost change for an item.
  6. Verify the COST_SUSP_HEAD/COST_SUSP_DETAIL tables.
  7. Data is stuck in the staging tables SVC_COST_SUSP_HEAD/SVC_COST_SUSP_DETAIL.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms