Error ORA-01427 & JBO-27122: While Submitting Reports From Report Manager Responsibility (Doc ID 2926819.1)

Last updated on FEBRUARY 16, 2023

Applies to:

Oracle Report Manager - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Steps to Reproduce the Issue:

Step#1

Prerequisites:

1. The Ledger is having Accounting Structure with minimum two different Key-Flex-Fields(KFF) sharing same Value-set(VS). As an example, Company and Intercompany segments are using same company value-set as XX_Company_VS.

2. At the Report Manager> Security Workbench use the same value-set (XX_Company_VS) for User to Value security of a Financial Statement Generator(FSG) report.

Step#2

Run the report:

Responsibility: Report Manager

Navigation: Report Submission> Simplified FSG Submission> [Search with FSG Report Name]> [Select the FSG report]

Step#3

Review the exception details:

Java Exception Details:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Error ORA-01427 & JBO-27122: While Submitting Reports From Report Manager Responsibility (Doc ID 2926819.1)

Applies to:

Symptoms

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!