RGRARG: FSG Completes with Error, Rgrsap.Rgrsxp: ORA-01722: Invalid Number

(Doc ID 579655.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle General Ledger - Version 12.0 and later
Information in this document applies to any platform.
Executable:RGRARG - Financial Statement Generator


Symptoms

  

Note: This document is archived, please refer to the published <document 453190.1> RGRARG: FSG Completes with Error Rgrsap.Rgrsxp: ORA-01722: Invalid Number

  


FSG completes with error. The following error is found in the log file:

select offset.PERIOD_NAME,
offset.PERIOD_YEAR,
offset.PERIOD_NUM
from GL_PERIOD_STATUSES offset,
GL_PERIOD_STATUSES poi,
GL_PERIOD_TYPES ptype
where poi.PERIOD_NAME = 'AD2-09'
and offset.PERIOD_TYPE = poi.PERIOD_TYPE
and poi.period_type = ptype.period_type
and offset.PERIOD_NUM = 1
and poi.period_year * ptype.number_per_fiscal_year +
poi.period_num + 0
>= offset.period_year * ptype.number_per_fiscal_year + 1
and poi.period_year * ptype.number_per_fiscal_year +
poi.period_num + 0
<= offset.period_year * ptype.number_per_fiscal_year +
ptype.number_per_fiscal_year
and offset.application_id = poi.application_id
and offset.set_of_books_id = poi.set_of_books_id
and poi.set_of_books_id = '&def_sob_id'
and poi.application_id = '101'
:
rgrsap.rgrsxp: ORA-01722: invalid number .

Changes

Upgraded to R 12.

Have applied <Patch 5725043>

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