RPMMOVAVG Job Aborts With ORA-01438 Error

(Doc ID 2129791.1)

Last updated on NOVEMBER 01, 2017

Applies to:

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

Symptoms

RPMMOVAVG job is failing with the following error:

Error:


Steps to Recreate:
1. Make sure that there is data in IF_TRAN_DATA table for a given item / location / date such that the total sales exceeds 8 digits.
2. Run RPMMOVAVG job and notice the above error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms