My Oracle Support Banner

R12: RGOPTM Program - Optimize Ends in Error ORA-01455: converting column overflows integer datatype (Doc ID 1987377.1)

Last updated on FEBRUARY 02, 2023

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:RGOPTM - Program - Optimizer

Symptoms

When run RGOPTM Program - Optimizer the following error occurs:

Error
-----
Gathering statistics.....
rgogst: gl_segment_frequencies is locked in exclusive mode.
All records have been deleted from gl_segment_frequencies.
rgogst: Total number of records created for segments = XXXXXX.
       Total number of records created for periods = XXX.
       Total number of records created for periods in GL_DAILY_BALANCES=0.
       Total number of records created in frequencies=XXXXXX.
rgogst: completed the update of rg_table_sizes for gl_code_combinations.
       gl_code_combinations has XXXXXXXX records.
rgogst() encountered an error returning from errexit:
ERROR: ORA-01455: converting column overflows integer datatype
             
rgoptm: encountered an error returning from rgogst()

Changes

 

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.