Unit Cost Changes Does Not Get Published To RIB
(Doc ID 2989401.1)
Last updated on NOVEMBER 27, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 to 23.1 [Release 23.1]Information in this document applies to any platform.
Symptoms
UnitCost changes at ITEM_LOC_SOH are not flowing to RIB. The root cause indicates towards POM Nightly schedule.
As part of Nightly schedule, the SCCEXT job (which updates the UnitCost in ITEM_LOC_SOH) runs after the publishing triggers are disabled (by DISABLE_RIB_PUB_TRIGGER_JOB). So, none of the changes flows to ITEM_LOC_MFQUEUE tables.
The cost changes in MFCS are getting lost in this process.
Steps to Recreate:
- Create and approve a CostChange.
- Run DISABLE_RIB_PUB_TRIGGER_JOB batch completed. All RMS publishing triggers are now disabled.
- Run SCCEXT and SCCEXT_POST. CostChange moved to ‘E’ (Executed) status.
- Check in ITEM_LOC_MFQUEUE that nothing got populated.
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 |