Future Dated Costs In FUTURE_COST Table Are Deleted (Doc ID 2150404.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.0 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.

Symptoms

Future dated costs in FUTURE_COST table are deleted ir-respective of the country which has been deleted corresponding to the supplier.

Steps To recreate:

  1. Create item with 2 suppliers "2400" and "2200" and 2 countries each "US" and "CA".
  2. Create cost change for supplier 2400 with effective date "30-JUN-2016".
  3. Move vdate to june 15 to be in the middle of active date of creation of item and cost change.
  4. Delete  country CA for supplier 2400.
  5. Records of active_date 30-jun-16 were deleted as well even if the origin_country_id was 'US'.

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