Item Missing From FUTURE_COST Table (Doc ID 2045913.1)

Last updated on JANUARY 22, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.
Checked for relevance on 23-January-2017

Symptoms

When an item/loc combination has a primary cost pack associated, the following behaviour is observed:


Steps to Recreate:

Scenario 1 – Used an item for which future cost already exists for an old active date (less than the vdate)

  1. Check the existing records in FUTURE_COST for the regular item (100000796) and its primary_cost_pack (100000809)
  2. Create a cost change for the component
  3. Execute the 3 process batches:
    a. ./fcthreadexec $UP
    b. ./prepost $UP fcexec
    c. ./fcexec $UP
  4. Check again the records in FUTURE_COST table
  5. Note that when we created a cost change for the item/loc which has a primary_cost_pack associated, the existing line on FUTURE_COST is being deleted.


Scenario 2 – Created an item using the “New from Existing”

  1. Execute the 3 processes in order to populate the initial costs in FUTURE_COST table
  2. Check the existing records on FUTURE_COST for the regular item (120005252) and its primary_cost_pack (120005261)
  3. Create a cost change for the component
  4. Execute the 3 process batches
  5. Check again the records in FUTURE_COST table
  6. Conclusion: The existing future cost is not being deleted as in the first scenario, but none of the cost changes of the items that have primary_cost_pack associated were inserted in FUTURE_COST table. The only line inserted corresponds to a location for which the item hasn’t any primary_cost_pack associated.


Scenario 3 – Created an item using the 'New' Option

  1. Execute the 3 processes in order to populate the initial costs in FUTURE_COST table
  2. Check the existing records on FUTURE_COST for the regular item (120005279) and its primary_cost_pack (120005287)
  3. Created a cost change for the component
  4. Execute the 3 process batches
  5. Check again the records in FUTURE_COST table

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