Post R12 Upgrade Financial statement Generators fails with ORA-01722: invalid number.

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

Resolution:

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]