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

Last updated on APRIL 24, 2015

Applies to:

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

Symptoms

On : 12.1.3 version, Setup forms and programs

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 = 156357.
       Total number of records created for periods = 238.
       Total number of records created for periods in GL_DAILY_BALANCES=0.
       Total number of records created in frequencies=156595.
rgogst: completed the update of rg_table_sizes for gl_code_combinations.
       gl_code_combinations has 30345090 records.
rgogst() encountered an error returning from errexit:
ERROR: ORA-01455: converting column overflows integer datatype
             
rgoptm: encountered an error returning from rgogst()

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