My Oracle Support Banner

Cost Changes By Item And By Location For The Same Active_date (Doc ID 2994347.1)

Last updated on FEBRUARY 09, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Goal

Qn1:Why getting below error :
When uploading the cost change by location, the process is being kept as New status in the Data Loading Status screen but when validating the table RMS_ASYNC_RETRY you have this error message:
@0PACKAGE_ERROR@1ORA-64464: XML event error ORA-19202: Error occurred in XML processing In line 2 of orastream: LPX-00224: multiple occurrences of attribute "table:content-validation-name" found@2ITEM_INDUCT_SQL.process_s9t
 
Qn2:When Uploading the file getting error message "This cost change cannot be submitted or approved. At least one item/supplier combination exists in another event with the same active date and a status of Submitted, Approved, or Extracted."

This doesn't make much sense since they're at different levels we should be able to apply the cost exception for the same day, can you please validate this?
 

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


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