Step-by-Step Guide to Create a User Defined Formula for Admin Charges in Oracle Fusion
Step 1: Navigate to Manage User Defined Formulas
Log in to Oracle Fusion with privileges to configure Subledger Accounting.
Go to Setup and Maintenance.
In the Functional Setup Manager (FSM), navigate to:
Step 2: Create a New User Defined Formula
Click Create to define a new formula.
Enter the following details:
Name: Admin Charges Formula
Subledger Application: AHC Billing
Process Category: AHC Billing
Event Class: AHC Billing
Event Type: Customer Billing, Customer Pay In, Customer Refund, Customer Settlement
Data Type: Number
Description: Formula to calculate admin charges for billing events.
Click Save, then proceed to define the logic.
Step 3: Define the Formula Logic
Example Formula for Admin Charges:
Assume Admin Charges are calculated as 5% of Transaction Amount, with a minimum charge of $10.
CASE
WHEN {Transaction Amount} * 0.05 >= 10 THEN {Transaction Amount} * 0.05
ELSE 10
END
Step 4: Assign the Formula to the Required Accounting Rules
Navigate to Manage Account Rules.
Find the Admin Charges Account Rule (or create one if needed).
In the Condition Definition, select User Defined Formula as the Source.
Choose Admin Charges Formula as the value.
Click Save and Close.
Step 5: Validate and Deploy the Formula
Click Validate to ensure correctness.
Deploy the formula by submitting the changes.
Attach the formula to relevant Journal Entry Rule Sets (if applicable).
Step 6: Test the User Defined Formula
Navigate to Subledger Accounting > Accounting Entries.
Generate accounting for different test transactions:
Example 1: If Transaction Amount = $500, Admin Charges = $25 (5% of 500).
Example 2: If Transaction Amount = $100, Admin Charges = $10 (since 5% of 100 = $5, but the minimum is $10).
Verify that the Admin Charges are correctly derived in accounting entries.
