Oracle Accounting Hub Cloud 2025Implementation Professional 1z0-1060-25 Exam Questions with Experts Answers Updated Recently

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:

Financials

Subledger Accounting

Manage User Defined Formulas.

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.

Enter the formula using Oracle’s formula syntax:

CASE

WHEN {Transaction Amount} * 0.05 >= 10 THEN {Transaction Amount} * 0.05

ELSE 10

END

ClickValidateto check for errors.

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.

Step-by-Step Guide to Create an Account Rule with 3 Priorities in Oracle Fusion

Step 1: Navigate to Manage Account Rules

Log into Oracle Fusion with appropriate privileges for Subledger Accounting.

Go toSetup and Maintenance.

In theFunctional Setup Manager (FSM), navigate to:

Financials

Subledger Accounting

Manage Account Rules.

Step 2: Create the Account Rule

ClickCreateto add a newAccount 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

ClickSave, then proceed to definePriorities.

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

ClickAdd Rowto definePriority 1.

SetPriority Orderas1.

DefineCondition:

IfTransaction Type = "Customer Billing", thenAccount = 4000 (Revenue Account)

Source Type: UseTransaction Typeas the basis.

ClickSave.

Priority 2: Derived from Customer

ClickAdd Rowto definePriority 2.

SetPriority Orderas2.

DefineCondition:

IfCustomer Category = "Wholesale", thenAccount = 4010 (Wholesale Revenue)

Source Type: UseCustomer Categoryas the basis.

ClickSave.

Priority 3: Default Revenue Account

ClickAdd Rowto definePriority 3.

SetPriority Orderas3.

DefineCondition:

Default Revenue Account = 4999(for any other transactions)

Source Type: UseConstant Value.

ClickSave.

Step 4: Validate and Assign the Account Rule

ClickValidateto ensure the rule has no errors.

Navigate toManage Journal Entry Rule Sets.

Locate theAHC BillingJournal Entry Rule Set.

Assign the newly createdRevenue Account Ruleto theappropriate Journal Line Rule(such as Revenue or Income).

ClickSave and Close.

Step 5: Test the Account Rule

Go toSubledger Accounting > Accounting Entries.

Generate accounting for different transactions:

Customer Billingshould deriveAccount 4000.

Wholesale Customer Billingshould deriveAccount 4010.

Other transactionsshould deriveAccount 4999.

Review and confirm that the correct accounts are assigned.

Step-by-Step Guide to Create a Description Rule in Oracle Fusion

Step 1: Navigate to Manage Description Rules

Log in to Oracle Fusion with appropriate privileges for configuring Subledger Accounting.

Go to Setup and Maintenance.

In the Functional Setup Manager (FSM), navigate to:

Financials

Subledger Accounting

Manage Description Rules.

Step 2: Create a New Description Rule

Click Create to define a new Description Rule.

Enter the following details:

Name: AHC Billing Description Rule

Subledger Application: AHC Billing

Process Category: AHC Billing

Event Class: AHC Billing

Event Type: Customer Billing, Customer Pay In, Customer Refund, Customer Settlement

Description: Enter a meaningful description, such as:

"Auto-generated description for AHC Billing transactions."

Click Save, then proceed to define the logic.

Step 3: Define the Description Rule Logic

Under Conditions, define a formula using transaction attributes to generate meaningful descriptions dynamically.

Click Add Condition, then define the description using placeholders.

Example formula:

'Transaction Type: ' || {Transaction Type} || ', Customer: ' || {Customer Name} || ', Amount: ' || {Transaction Amount}

This rule constructs a description dynamically, showing:

Transaction Type

Customer Name

Transaction Amount

Example Output:

"Transaction Type: Customer Billing, Customer: John Doe, Amount: $500"

ClickValidateto ensure there are no syntax errors.

Step 4: Assign the Description Rule

Navigate toManage Journal Entry Rule Sets.

Locate theAHC BillingJournal Entry Rule Set.

Assign the newly createdDescription Ruleto the appropriateJournal Line Rule.

ClickSave and Close.

Step 5: Validate and Deploy the Rule

ClickValidateto check for errors.

Deploy the rule by submitting the changes.

Ensure the rule is attached to theAHC Billing journal entries.

Step 6: Test the Description Rule

Navigate toSubledger Accounting > Accounting Entries.

Generate accounting for different test transactions.

Verify that thejournal entry descriptionsmatch the expected format.