Oracle Accounting Hub Cloud 2025Implementation Professional - 1z0-1060-25 Exam Practice Test
Challenge 3: Manage User Define Formulas
TASK
Create User Defined Formula for Admin Charges
Subledger Application: AHC Billing
Process Category: AHC Billing
Event Class: AHC Billing
Event Type: Customer Billing, Customer Pay In, Customer Refund, Customer Settlement
TASK
Create User Defined Formula for Admin Charges
Subledger Application: AHC Billing
Process Category: AHC Billing
Event Class: AHC Billing
Event Type: Customer Billing, Customer Pay In, Customer Refund, Customer Settlement
Correct Answer:
See the Explanation 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 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.
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 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.
Your customer needs to generate journal entries for the insurance premium collected from the sale of policies.
The different components of the premium collected by the company include Basic Premium and Tax.
While uploading the transaction details containing both Basic Premium and Tax amounts, which transaction source would you use to link the transaction header and line information?
The different components of the premium collected by the company include Basic Premium and Tax.
While uploading the transaction details containing both Basic Premium and Tax amounts, which transaction source would you use to link the transaction header and line information?
Correct Answer: C
Vote an answer
In Functional Setup Manager, if setup data is segmented by a specific context, you can perform the setup task iteratively, such as assigning different ledger options to different primary ledgers.
Which action should you take to specify the context?
Which action should you take to specify the context?
Correct Answer: A
Vote an answer
Your client organization deals in providing loans to its customers. You are appointed as a consultant to implement Oracle Fusion Cloud Accounting Hub to standardize the accounting process. Your client has a requirement to retrieve the segment values for the debit and credit side of journal entries based on different criteria. You decide to create a mapping set to retrieve the value of the cost center segment based on loan type as the input source. Your client wants the values to be validated from a list while creating the input and output mappings.
Which two options allow the validation of input values on mapping sets?
Which two options allow the validation of input values on mapping sets?
Correct Answer: C,D
Vote an answer
Your client is involved in the sale of health, vehicle, and home insurance services. Currently, they process their transactions in a source system. You have been appointed as a consultant to implement Accounting Hub Cloud and standardize their accounting process. You decide to register their source system as a single application in Accounting Hub Cloud.
How many event classes will be generated by the system while registering the source system?
How many event classes will be generated by the system while registering the source system?
Correct Answer: A
Vote an answer
Your client has operations in the US and the UK, and they currently use a third-party billing system to process their transactions, such as Complete an Invoice, Record a Payment, Record Late Charges, and Recognize Revenue. As part of the Accounting Hub implementation, you have been asked to register the billing source system.
While registering the source system using the spreadsheet template, which TWO could be flagged as errors by the validation check process?
While registering the source system using the spreadsheet template, which TWO could be flagged as errors by the validation check process?
Correct Answer: A,B
Vote an answer
While creating an accounting method, you are unable to select a journal entry rule set for a combination of event class and event type.
What could be the reason for this issue?
What could be the reason for this issue?
Correct Answer: D
Vote an answer
Your client has implemented the Accounting Hub Cloud solution. They import their transaction data from the source system on a daily basis, and while doing so, some transactions are not being accounted properly. They want these invalid transactions purged and the correct transactions re-imported.
Which job would you submit to purge the invalid transactions?
Which job would you submit to purge the invalid transactions?
Correct Answer: A
Vote an answer
Your company is part of the financial services industry and manages various types of transactions, such as Notional Amount on Trade Positions, Premium Amount, Premium Settlement, and Premium Sweep in their source system. While analyzing their source transaction system, you are asked to propose an event model, based on the activities performed by the company.
According to your analysis, what should the Notional Amount on Trade Positions, Premium Amount, Premium Settlement, and Premium Sweep transactions be defined as while registering the source system?
According to your analysis, what should the Notional Amount on Trade Positions, Premium Amount, Premium Settlement, and Premium Sweep transactions be defined as while registering the source system?
Correct Answer: C
Vote an answer