Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
COA Segment Values based on Security Rules — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

COA Segment Values based on Security Rules

Received Response
16
Views
2
Comments
edited Mar 26, 2021 12:43PM in Reporting and Analytics for ERP 2 comments

Summary

COA Segment Values based on Security Rules

Content

We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role, which is assigned to the user.

For Example, COA Segment 1 has values 1 to 10

Values 1 to 5 are assigned to Role A which is assigned to User A

Values 6 to 10 are assigned to Role B which is assigned to User B

 

When User A is running the BI Report then he/she should only see Values 1 to 5 in the output

We have used the fnd_flex_xml_publisher_apis.process_kff_combination_1 function but it is taking 15 mins to give the output for only 3 rows

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!