Security Rule in R12

Security Rule allows restricting user access to various key flexfield segments list of value.

1. Enable security on the value set.To enable security for a value set, choose either Non-Hierarchical Security or Hierarchical Security for the Security Type.
With hierarchical security, a security rule that applies to a parent value also applies to its child values.

2. Navigate to System Administrator->Application->Flexfield->Key->Segments and query the Application,Title and Structure(Accounting flexfield structure)

3. Click on the segments button and after selecting the segment to which security rule is to be applied, click on open button.

4. Ensure that the “Security Enabled” check box is enabled.

5. Navigate to General Ledger Super User->Setup->Financials->Flexfields->Key->Security->Define

6. Query the Application,Title and Structure(Accounting flexfield structure).Then select the required Segment(Independent Segment)

7. Enter the Security Rule name,description and the error message that needs to be displayed.

8. Under security Rule Elements,select the segment values that needs to be included and excluded.By default all values will be excluded.From and To value can be selected same or a range(like From 100- To 300).Then save it.

9. Navigate to General Ledger Super User->Setup->Financials->Flexfields->Key->Security->Assign

10. Query the Application,Title and Structure(Accounting flexfield structure).Then select the required Segment(Independent Segment)

11. Select the application and responsibility to which security rule needs to be applied and set the Security Rule name under Security rules section.

12. Navigate to Responsibility against which security rule is set and try entering the segment value for security rule was set.

In above example,try navigating to iProcurement responsibility and try entering charge account.

It will allow to enter only values that are included for that segment.For others it will show the error message which we have set.

References:

https://govoracleapps.wordpress.com/2013/06/01/security-rule/

https://orafinappssetups.blogspot.com/2013/01/security-rules-in-r12.html

http://oracleapps88.blogspot.com/2011/08/gl-flexfield-security-rules.html