Missing Items In FUTURE_COST Table (Doc ID 1538694.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.1.4.4 to 13.1.6 [Release 13.1]
Information in this document applies to any platform.

Symptoms

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


Steps to recreate:

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

1) Check the existing records on FUTURE_COST for the regular item (100000796) and its primary_cost_pack (100000809)
2) Created 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 that we have on future_cost table

When created a cost change for the item/loc which as 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) Created a cost change for the component
4) Execute the 3 process batches
5) Check again the records that we have on future_cost table

Conclusion: the existing future cost isn’t being deleted like happened on the first scenario, but none of the cost changes of the items that have primary_cost_pack associated were inserted on future cost table. The only line inserted corresponds to a location, which 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 that we have on 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