FSG Report Output Errors For Only Text Format With The Error PERF0005: Oracle Error Detected In get_def_ldgs - ORA-01403 And Warning : Ledger Segments Are Used In Definitions Of Both Columns And Rows. (Doc ID 1507599.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Financial Statement Generator

FSG RGRARG report errors with Text output option .All other output options work fine.

The error messge encountered is

Warning : ledger segments are used in definitions of both columns and rows.

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

<x get_def_ldgs() 20-AUG-2012 07:31:46

<x get_def_ldgs() 20-AUG-2012 07:31:46
rgrdrs List of default ledger id/name begin:

 

The system does not allow for the ledger segment to be removed from the columnset or the rowset and gives the following error-

 

Enter value in segment access_set_id before entering value in Ledger segment.
--------------------------------------------------------------
ORA-01407: cannot update ("RG"."RG_REPORT_AXIS_CONTENTS"."LEDGER_SEGMENT_TYPE") to NULL

--------------------------------------------------------------
FRM-40509: ORACLE error: unable to UPDATE record.

 

Steps to reproduce:

Reports--Request--Financial

Submit the report and check the log file for error







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