Post EBS R12 Upgrade – Financial Statement Generators fail with ORA-01722

Tip of the week:

Issue: When Financial Statement Generator (FSG) reports are run after R12 .1.3 upgrade, they end in following errors.

1.  rgrsap.rgrsxp: ORA-01722: invalid number

2. rgrdpg.rgrdpg: Unable to read value for profile option RG_DEBUG_ON

3. PERF0005: Oracle error detected in get_def_ldgs – ORA-01403: no data found


1. Set the Profile option “FSG: Enable search Optimization” to ‘YES‘.

In R12.1.3 this profile option value MUST be set to YES. It is no longer used in R12.1.3, however having it set to NO can cause unpredictable and invalid results in reports.

2. Run the following command from $RG_TOP/patch/115/import/US

[applmgr]$ FNDLOAD apps/fnd 0 Y UPLOAD $RG_TOP/patch/115/import/rgnlssra.lct $RG_TOP/patch/115/import/US/b5922303.ldt RG_REPORT_STANDARD_AXES

This should resolve the issue.

 Reference MOS documents:

R12: FSG: PERF0005 Error Detected In GET_DEF_LDGS – ORA-01403: No Data Found Common Issues [ID 1368691.1]

R12: RGRARG FSG Completes with Error, rgrsap.rgrsxp: ORA-01722: Invalid Number [ID 579655.1]


About Sunthar Tharmalingam
Bio: Sunthar is an Oracle Certified Professional with over 14 years of experience in multifaceted architectural design and implementation of mission-critical global Oracle Applications. He provides technical leadership to the enterprise project teams and manages the comprehensive implementation life-cycle. Sunthar has exhaustive hands-on competencies in vital Oracle technologies such as Oracle E-Business Suite, Databases, OBI Applications, Oracle Identity Management and Webcenter suites. This Blog has been categorized according to the Oracle products that integrates with Oracle E-Business Suite. Should you wish to participate as an author for a related module or category please register as a member and mail me to let me know which category you would like to write under.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: