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.

Last updated on FEBRUARY 22, 2018

Applies to:

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

Changes

Cause