Future Cost Records Being Deleted After Creating a Cost Change on Component Item (Doc ID 2082624.1)

Last updated on APRIL 24, 2017

Applies to:

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

Symptoms

When PRIMARY_COST_PACK was set up for a component item, creating a cost change on the component item is deleting existing records for component item from FUTURE_COST table.



Steps to Recreate:

  1. Create a component item and create a simple pack for it.
  2. Specify PRIMARY_COST_PACK for component item as the pack item created above.
  3. Make sure that COST_EVENT_RUN_TYPE_CONFIG.EVENT_RUN_TYPE = 'SYNC' for event type 'CC'.
  4. Create a cost change for component item effective on vdate + 1.  Approve the cost change.
  5. Notice that no new records are created in FUTURE_COST table.
  6. Advance vdate to vdate + 10.
  7. Create another cost change for component item effective on vdate + 1.  Approve the cost change.
  8. Notice that existing records for component item were deleted from FUTURE_COST table. This is incorrect.
  9. Create a cost change for pack item effective on vdate + 4.
  10. Approve the cost change.
  11. Notice that new records are created for both component and pack item 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