|
Re: what are the differences between security rule and cross validation rule in oracle general ledge [message #193204 is a reply to message #193166] |
Fri, 15 September 2006 04:55 |
vin_odks
Messages: 153 Registered: July 2006 Location: -
|
Senior Member |
|
|
Hi,
Security Rules :
Security rule defines the permissible Values for a Segment or Value set.
These rule can be Set to application,responsibility or User.
Advantages :User can use only the permitted Codes.
Example
Scenario: Suppose your account segment contains 10 Values.
and certain user needs to be given access to only 3 account values!!
Cross-Validation rules :
Cross validation rules determine the valid Code combination to be used for the Key flexfield.
Advantages
Prevent users from choosing the wrong combination!!
Scenario : Suppose your code combination is as follows :
Country-Location-City
The valid combination can be
UK-London-London
US-New york -New York
But,
It cannot be
UK-New york-New York !!!
Hope it is clear
Regards
Vinod
|
|
|
Re: what are the differences between security rule and cross validation rule in oracle general ledge [message #194599 is a reply to message #193166] |
Fri, 22 September 2006 20:25 |
mihirca
Messages: 6 Registered: September 2006
|
Junior Member |
|
|
Hi Sai
At a top level understanding, 'security rules' can restrict access to the defined segments/values for certain responsibilities while 'cross-validation' rules validate the correct code combinations between difference segment values.See scenario below:
================================================================
Scenario:
A Company has a 3 segment structure.
Segment 1 is Company Code
Segment 2 is Cost Centre
Segment 3 is Natural Account (GL Code)
There is a specific series for Manufacturing Cost Centres and another for Admin Cost Centres
Similarly there is a specific series for Natural A/cs for Manufacturing Exps and Admin Exps
There is a control A/c for 'Accounts Payable Control A/c'
================================================================
Now if you want to control that when a Mfg Cost Centr is selected the system should not allow Admin Natural A/c, you will use a 'cross-validation' rule to validate the eligible combinations for Segment 2 and Segment 3
If you want to restrict entries made to 'Accounts Payable control A/c' by persons from AR group; you will use a security rule and tell the system that the following responsibilitites (say AR User / AR Manager etc.) should not be ale to touch 'AP COntrol A/c'
Thanks
Mihir
|
|
|