Step-by-Step Guide to Create an Account Rule with 3 Priorities in Oracle Fusion
Step 1: Navigate to Manage Account Rules
Log in to Oracle Fusion with appropriate privileges for Subledger Accounting.
Go to Setup and Maintenance.
In the Functional Setup Manager (FSM), navigate to:
Financials
Subledger Accounting
Manage Account Rules.
Step 2: Create the Account Rule
Click Create to add a new Account Rule.
Enter the following details:
Name: Revenue Account
Subledger Application: AHC Billing
Process Category: AHC Billing
Event Class: AHC Billing
Event Type: Customer Billing, Customer Pay In, Customer Refund, Customer Settlement
Rule Type: Account
Click Save, then proceed to define Priorities.
Step 3: Define Three Priorities for the Revenue Account Rule
Now, define three priorities for determining the revenue account:
Priority 1: Derived from Transaction Type
Click Add Row to define Priority 1.
Set Priority Order as 1.
Define Condition:
If Transaction Type = 'Customer Billing', then Account = 4000 (Revenue Account)
Source Type: Use Transaction Type as the basis.
Click Save.
Priority 2: Derived from Customer
Click Add Row to define Priority 2.
Set Priority Order as 2.
Define Condition:
If Customer Category = 'Wholesale', then Account = 4010 (Wholesale Revenue)
Source Type: Use Customer Category as the basis.
Click Save.
Priority 3: Default Revenue Account
Click Add Row to define Priority 3.
Set Priority Order as 3.
Define Condition:
Default Revenue Account = 4999 (for any other transactions)
Source Type: Use Constant Value.
Click Save.
Step 4: Validate and Assign the Account Rule
Click Validate to ensure the rule has no errors.
Navigate to Manage Journal Entry Rule Sets.
Locate the AHC Billing Journal Entry Rule Set.
Assign the newly created Revenue Account Rule to the appropriate Journal Line Rule (such as Revenue or Income).
Click Save and Close.
Step 5: Test the Account Rule
Go to Subledger Accounting > Accounting Entries.
Generate accounting for different transactions:
Customer Billing should derive Account 4000.
Wholesale Customer Billing should derive Account 4010.
Other transactions should derive Account 4999.
Review and confirm that the correct accounts are assigned.
