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 JULY 07, 2020
Applies to:
Oracle General Ledger - Version 12.1.3 and laterInformation in this document applies to any platform.
ORA-01403
FSG
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |