My Oracle Support Banner

Sales Upload Is Not Loaded To TRAN_DATA Table With RTLOG ORG SYS As 'OMS' (Doc ID 3048097.1)

Last updated on SEPTEMBER 17, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 to 24.1 [Release 24.0 to 24.1]
Information in this document applies to any platform.

Symptoms

When attempting to run uploadsales
the following error occurs.

ERROR
-----------------------
uploadsales~20240904074906~POPULATE_POSUPLD_STATUS~ MERGE /*+ USE_HASH(s, sps) */INTO svc_posupld_staging s
ERROR at line 1:
ORA-30926: unable to get a stable set of rows in the source tables


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Setup STORE_DAY and STORE_DATA for a virtual store with SYSTEM_CODE as 'OMS'
2. Push RTLOG API (JSON) [REST Service]
3.Run the required batches to have the data in SA_TRAN_HEAD and SA_TRAN_ITEM and TRAN_DATA table.

Make Sure Account_for_sale FL and account_for_sale RL


Cause

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
Symptoms
Cause
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.