below
for all the solution.
Explanation:
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:
Financials
Subledger Accounting
Manage User Defined Formulas.
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.
Enter the formula using Oracle’s formula syntax:
CASE
WHEN {Transaction Amount} * 0.05 >= 10 THEN {Transaction Amount} * 0.05
ELSE 10
END
Click Validate to check for errors.
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.
