Monday, 11 November 2019

How to enable Oracle fusion report GL Level User Security Profile


Requirement: Oracle Report will give output for specific code combination only which is based on User Security profile option.


Step1: Required to create a parameter









Step2: Create Flexfield with following details. 















- Now when you run the report it will give output for only those account which is enabled at User Security profile for that user.
















Note:
1.       we have to use the table GL_CODE_COMBINATION_KFVS main Dataset table alias name in Code Combination Table Alias  name in configuration

2.       We can enable User Security profile on Dataset level only not on Parameter level using this process.


No comments:

Post a Comment