Creating Account Combinations in Oracle Fusion Application

In this training article we will learn how to create account combinations in detail. We would also look carefully into the impact of cross validation rules on creation of account combinations.

Prerequisite Setup for creating account combinations:

Before creating account combinations we must configure the chart of account and value set values. In case we have specified dynamic insertion, then we are not required to create account combinations. However in case few restricted account combinations are required, we can go for it.

Creating account combinations:

Navigation- Select Implementation project from Setup & Maintenance area and go to Manage Account Combinations

Specify the chart of account and click on Add icon- 

Input the required code combinations and click on Save button. Thus the code combination is created. The code combination once created can’t be deleted. However in future if this code combination is not required, we can disable it from the above screen to avoid posting of any transaction against this combination.

What is the impact of Cross Validation rule on creation account combinations?

We can’t create account combination on the combinations where cross validation rule (CVR) has been defined. Let us test this in the following example. We will create a CVR rule on 01 Company which is not valid with 003 department as shown below-

Input Company equals 01 and click OK

Input validation filter of department 003 which is not valid and click on OK

The error message fed in CVR as “Department 003 is not valid with Company code 01”. Now let us try to create combination on Company code 01 with department code 003 as shown below-

We can see that the same error message pops up which was fed in CVR- “Department 003 is not valid with Company code 01”. Hence we see that once the CVR is defined we cannot create account combinations on the same code combinations.

Anjan Mukerji

Add comment