GL Cross Validation Rules in Oracle Fusion Cloud

Business Requirement : 

If Busines has Cost Center Segment values with Common for Balance sheet and this should not use for P&L Account 

Then business may require COA Restriction required for entering Cost Center as 000- Common and GL Project 0000-Common for all Expense and Revenue GL Account.

Go to System and Maintenance >  Manage Cross-Validation Rule

s

Create Rule :for Example

• Code: CC01_BS
• Description  Common(000)GL Costcenter Restriction for all Expense and Revenue Account
• Effective Date from
• Effective Date to
• Enable : yes
• Filter Conditions : Select where condition GL Account or any Segment on which base system should trigger cross validation rule.
• Ex: Filter Condition Details: account Greater than or equals to 30000000 ( Make sure if this is restricted Account for which Common cost center should not allow)

Condition Filter 1 Filter Conditions Defined Condition Details account Greater than or equals to 30000000 Error Message Name GL_CVR_1005121_300000922647489

Then enter Validation for which system to restrict or allow the Code for any segment:

For this case we need to excluse Common Cost center should not allow for Above GL Account greather than or equal to 30000000 

*Validation Filter	1 Filter Conditions Defined
Validation Details	costCenter Not equals to 000

Finally Check in journal page