R12: RGOPTM Program - Optimize Ends in Error ORA-01455: converting column overflows integer datatype
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
On : 12.1.3 version, Setup forms and programs
When run RGOPTM Program - Optimizer the following error occurs:
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()
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms