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 |