My Oracle Support Banner

Reasons For Error 'RET-0103: generic function processing error~INSERT in package SA_BUILD_TOTAL_SQL.INSERT_TOTAL' When Running SATOTAL Batch (Doc ID 1676735.1)

Last updated on AUGUST 16, 2022

Applies to:

Oracle Retail Merchandising System - Version 13.2.3.1 and later
Information in this document applies to any platform.

Purpose

The purpose of this note is to understand the reason for 'RET-0103: generic function processing error~INSERT in package SA_BUILD_TOTAL_SQL.INSERT_TOTAL' when running SATOTAL and the workaround that can be used to avoid this error. 

Questions and Answers

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
Purpose
Questions and Answers
 While executing the batch SATOTAL, the job fails with the following error. Why?
 What is the reason for the increase in the revisions in the SA_SYS_VALUE tables?
References


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