Free Oracle 1z0-1060-25 Practice Exam with Questions & Answers

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.

To create Journal Line Rules (JLR) in Oracle Fusion, follow these step-by-step instructions:

Step 1: Navigate to the Manage Subledger Journal Entry Rule Sets Page

Log in toOracle Fusion Applicationswith a user that has privileges to configureSubledger Accounting Rules.

Go toSetup and Maintenance.

In theFunctional Setup Manager (FSM), select:

Financials

Subledger Accounting

Manage Journal Line Rules

Step 2: Create the "Interest Receivable" Journal Line Rule

ClickCreateto add a new Journal Line Rule.

Enter the following details:

Name: Interest Receivable

Subledger Application:AHC Loan

Event Class:AHC Loan

Event Type:Loan Origination, Interest Accrual, Payment

Account Class: (Choose the appropriate account class, such as "Receivable" or a custom account class)

Line Type: Debit

Description: (Optional, enter something like “Recognizes interest receivable”)

UnderConditions, define rules if needed to filter transactions for this Journal Line Rule.

Save and Close.

Step 3: Create the "Interest Income" Journal Line Rule

ClickCreateagain to add the second Journal Line Rule.

Enter the following details:

Name: Interest Income

Subledger Application:AHC Loan

Event Class:AHC Loan

Event Type:Loan Origination, Interest Accrual, Payment

Account Class: (Choose an appropriate account class, such as "Revenue" or a custom account class)

Line Type: Credit

Description: (Optional, enter something like “Recognizes interest income”)

UnderConditions, define rules if needed to filter transactions for this Journal Line Rule.

Save and Close.

Step 4: Validate and Deploy the Rules

Navigate toManage Accounting Methods.

Find the accounting method used for theAHC Loansubledger.

Attach the newly createdJournal Line Rulesto the appropriateJournal Entry Rule Set.

Validate the changes and submit them for approval.

Once validated, deploy the accounting method.

Step 5: Test the Journal Line Rules

Navigate toSubledger Accounting > Accounting Entries.

Generate accounting for a testLoan Origination, Interest Accrual, or Paymenttransaction.

Verify that the correct Journal Entries are created:

Interest Receivable (DR)

Interest Income (CR)

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.