My Oracle Support Banner

Missing Items In FUTURE_COST Table (Doc ID 1538694.1)

Last updated on FEBRUARY 21, 2019

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 a regular item and its primary_cost_pack
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  and its primary_cost_pack
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 and its primary_cost_pack
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

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