Error in SATOTALS_CYCLE_JOB - processStoreDayTotals~~103~RET-0103: generic function processing error~MERGE in package SA_BUILD_TOTAL_SQL.INSERT TOTAL Total ID: T_ACCRUAL
(Doc ID 2996370.1)
Last updated on JANUARY 08, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and laterInformation in this document applies to any platform.
Symptoms
On : 23.1 version, ReSA Others
Following error in the job_audit_logs for SATOTALS_CYCLE_JOB:
2023-12-11T23:12:03,158 [Thread-2394] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: satotals_1~20231211231203~processStoreDayTotals~~103~RET-0103: generic function processing error~MERGE in package SA_BUILD_TOTAL_SQL.INSERT_TOTAL Total ID: T_ACCRUAL
2023-12-11T23:12:03,159 [Thread-2394] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Mon Dec 11 23:12:03 Program: satotals: PID=12212: Thread 1 - Aborted in process
2023-12-11T23:12:03,202 [Thread-2394] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: batch_satotals~20231211231203~satotals~Errors encountered. Check error file.
2023-12-11T23:12:03,208 [Thread-2394] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Mon Dec 11 23:12:03 Program: batch_satotals: PID=11904: Aborted in satotals
The issue can be reproduced with the following steps:
1. Run the SATOTALS_CYCLE_JOB
2. See that it fails on processStoreDayTotals
Changes
NA
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 |
Changes |
Cause |
Solution |
References |