My Oracle Support Banner

RGRARG After Upgrade All FSG Reports Error With PERF0005: Oracle error detected in get_def_ldgs (Doc ID 1370590.1)

Last updated on JANUARY 25, 2021

Applies to:

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

Symptoms

NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

On : 12.1.3 version, Financial Statement Generator

When attempting to run RGRARG module: Financial Statement Generator the following warning/errors occur:

ERROR
-----------------------

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

2. Warning :Total width from all rows in the Row Order 64 exceeds the Column Set Margin 60

3. RG_RARG0005: No report is being generated because data access security restricts access to all ORGANIZATION values specified in the report definition.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Request
2. Run
3. FSG

Changes

Upgrade from 11i to r12.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.