My Oracle Support Banner

Price Change Ends ORA-01407: Cannot Update ("RMS01"."RPM_FUTURE_RETAIL_GTT"."SELLING_RETAIL_CU (Doc ID 3049553.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

Oracle Retail Pricing Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Goal

On: RPCS/RPM 19.3.020.5 version

Price Change for a style/differentiator for a zone goes into Conflict Checking with the below error:

sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-01407: cannot update ("RMS01"."RPM_FUTURE_RETAIL_GTT"."SELLING_RETAIL_CURRENCY") to NULL@2RPM_ROLL_FORWARD_SQL.RPM_RF_SELLING_RETAIL ORA-01407: cannot update ("RMS01"."RPM_FUTURE_RETAIL_GTT"."SELLING_RETAIL_CURRENCY") to NULL

Please help us to understand the error and fix the same?
 

Solution

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
Goal
Solution
References


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