Home » Applications » Oracle Fusion Apps & E-Business Suite » what are the differences between security rule and cross validation rule in oracle general ledger
what are the differences between security rule and cross validation rule in oracle general ledger [message #193166] Fri, 15 September 2006 02:15 Go to next message
ogirala123
Messages: 4
Registered: August 2006
Junior Member
hi to all,

can any body give the differences between security rule and cross validation rule in general ledger.


byee,
sai.
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Transaltion Programe
Next Topic: Looking Job in Oracle 11i Apps ( mfg & Dist)
Goto Forum:
  


Current Time: Sun Dec 11 00:31:23 CST 2016

Total time taken to generate the page: 0.10496 seconds