My Oracle Support Banner

UAT1: Data Conversion Tool: Pricing Clearance Loading Is Stuck (cutover Rehearsal) (Doc ID 3070807.1)

Last updated on FEBRUARY 05, 2025

Applies to:

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

Goal

On : 24.1 version, Merch-Cross Pillar

Data Conversion Tool: Pricing Clearance loading is stuck ?

We are in the middle of data conversion in UAT1 environment as part of cutover rehearsal.The RPM_CLEARANCE load is stuck without loading any data to the core tables.

Group: Pricing Clearance
Entity: RPM_CLEARANCE


1. Import from file and Data Validations Completed.
2. It is stuck on "Business Validation" and load screen. The loading of Pricing Clearances is stuck. In spite of several hours it is in "In Progress" status.
3. We have tried to kill the session and re do the process few times, but each time it is stuck at the same query.

INSERT INTO RPM_DC_CLEARANCE_VALIDATION (CLR_DC_ROWID, ITEM, LOCATION) ....

 

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.