My Oracle Support Banner

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 FEBRUARY 22, 2018

Applies to:

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


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.

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


Steps to reproduce:


Submit the report and check the log file for error




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.