Approved Price Changes Are Not Being Made To 'Executed' Status After Running PriceEventExecution Batch
Last updated on JUNE 07, 2017
Applies to:Oracle Retail Price Management - Version 12.0.5 and later
Information in this document applies to any platform.
The issue is specific to India Localization customers only.
Checked for relevance on 04-April-2014
Checked for relevance on 07-June-2017
Price Changes effective on vdate + 1 are not moved to 'Executed' status from 'Approved' status when running PriceEventExecutionbatch in 12.0.5 IN India Localization Environment.
RPM Oc4j log has the following error :
Steps to Recreate:
1) Create few Regular Price Changes effective 'Vdate+1'
2) Execute RPM_PRICEEVENTEXECUTION batch
3) Few price changes are observed to have remained in 'Approved' status.
Due to this the Selling_Retail in RPM_ITEM_MRP_DETAILS table is not updated with the latest Price Change.
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