GL:How to relax Security Rules

Filed Under  rule elements, Security rule

 

We tried to do an Inventory Miscellanous Transaction in a responsibility,EY Direct Sales – Shop User, but we were getting the following error.

This error message is coming from a Security Rule attached to this responsibility. To continue with this transaction we need to modify or remove the security rule.
Security rules

Responsibility: General Ledger
Navigation: Setup > Financials > Flexfields > Key > Security > Define

Enter
Structure: EY_ACC_FLEX (This is accounting flexfield structure)
Segment: Account

Click on Find.

Now as per the Security rule error above, we know that the account in question is 7113. Go into query mode by click on a field in Security Rules section and hitting F11. Enter the message that you had received earlier. We shall enter %7113% as we know this will return the Security Rule in the form.

Click on Ctrl+F11.

The rules elements include all accounts from 0000 to ZZZZ and excludes any account between 0000 to 7112 and 7114 to 9999. This in turn means that the included account values can be 7113 and anything greater than 9999 to less that ZZZZ.
The problem here is that the account 0000 is excluded whereas in that responsibility Oracle is internally picking up account 0000. So we need to include 0000. Change the first exclude section to 0001 to 7112.

Save the form.
You can directly remove the rule from the responsibility as well. Note the name of the Security Rule, Restrict_Drct Sales_Store_Shop. Click on Assign button.

You will get the list of responsibilities. Query for the Security Rule.

Hit Ctrl+F11

Now you can see the responsibility attached to the security rule. Delete this line and save the form.

Test the Miscellaneous Transaction again

Go to “EY Direct Sales – Shop User” and try to conduct the transaction again.

Now the Security Rule error message does not come up. The rule has been relaxed and removed.