'Report Refreshed' Link in Promotion Planner Dashboard Throws an Error
(Doc ID 2954971.1)
Last updated on JUNE 13, 2023
Applies to:Oracle Retail Pricing Cloud Service - Version 19.2 and later
Information in this document applies to any platform.
Clicking 'Report Refreshed' link in Promotion Planner Dashboard is throwing an error.
This issue happens only for a specific department.
An application error has occurred
Steps to Recreate:
1. Navigate to Promotion Planner Dashboard.
2. Query the data for a department.
3. Notice that nothing is displayed.
4. Click 'Report Refreshed' link and notice "An application error has occurred" error.
Error from LOGGER_LOGS table:
sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-20006: cannot gather session
private statistics for RMS01.RPM_OI_ITEM_HELPER_GTT without truncating the
table@2RPM_OI_UTILITY_SQL.LOCK_STATS ORA-20006: cannot gather session private
statistics for RMS01.RPM_OI_ITEM_HELPER_GTT without truncating the table
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