My Oracle Support Banner

No Data for Security Enabled FSG Reports for Responsibility with No Security Rules (Doc ID 758890.1)

Last updated on JANUARY 12, 2021

Applies to:

Oracle General Ledger - Version 11.5 to 12.1 [Release 11.5.0 to 12.1]
Oracle Report Manager - Version 12.0.5 and later
Information in this document applies to any platform.
Oracle Report Manager - Version: 12.0.5
This problem can occur on any platform.

Symptoms

If report is submitted in Report Manager with 'Flexfield Segment Security', No data appears for User who does not have any Segment security rule assigned. However data appears fine for those who have Security rules assigned.

e.g: Customer submits a report in Report Manager and enables 'Flexfield Segment Security'. Consider the following Users:
User1 : Has a Segment Security rule assigned which has access only to XX.
User2 : Has a Segment Security rule assigned which has access only to YY and ZZ.
User3 : Has no Segment Security rule assigned.

When User1 views the report, only XX appears in the Expansion list.
When User2 views the report, only YY and ZZ appear in the Expansion list.
When User3 views the report, none of the values appear as User does not have any Security Rule assigned to him.

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


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