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 into Oracle Fusion with privileges to configure Subledger Accounting.
Go toSetup and Maintenance.
In theFunctional Setup Manager (FSM), navigate to:
Step 2: Create a New User Defined Formula
ClickCreateto 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.
ClickSave, then proceed to define the logic.
Step 3: Define the Formula Logic
Example Formula for Admin Charges:
AssumeAdmin Chargesare calculated as5% of Transaction Amount, with aminimum 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 toManage Account Rules.
Find theAdmin Charges Account Rule(or create one if needed).
In theCondition Definition, selectUser Defined Formulaas the Source.
ChooseAdmin Charges Formulaas the value.
ClickSave and Close.
Step 5: Validate and Deploy the Formula
ClickValidateto ensure correctness.
Deploy the formula by submitting the changes.
Attach the formula to relevantJournal Entry Rule Sets(if applicable).
Step 6: Test the User Defined Formula
Navigate toSubledger Accounting > Accounting Entries.
Generate accounting for different test transactions:
Example 1: IfTransaction Amount = $500, Admin Charges =$25(5% of 500).
Example 2: IfTransaction Amount = $100, Admin Charges =$10(since 5% of 100 = $5, but the minimum is $10).
Verify that theAdmin Chargesare correctly derived in accounting entries.
