My Oracle Support Banner

When New Supplier Is Added To Item Future Cost Data Is Not Pupulated (Doc ID 2500706.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


While adding a new supplier to a parent item using the RMS screen, the process is not populating the FUTURE_COST table with the new item / supplier / country relationship.
This is happening when the cost engine (cost_event_run_type_config) is configured to run 'ASYNC' for the event_type 'SC' - Item Supplier Country Location Relationship Changes.
If modifying the cost event run type to 'SYNC' the process works as expected and the future cost table gets populated with the new item / supplier / countries.

The issue can be reproduced at will with the following steps:

Before performing the test, make sure the run_type is set to 'ASYNC' on the cost_event_run_type_config for the event_type 'SC'.
1-Open Item Maintenance screen for an existing item
2-Under More Options, open the Suppliers screen
3-Add a new Supplier and Country to the item
4-Save all changes and close the maintenance screen
5-Confirm Future Cost table does not hold the new added Supplier


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.