My Oracle Support Banner

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 later
Information 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


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