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

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.

A banking organization is currently using different transaction systems for various types of loans, including vehicle loans, personal loans, education loans, and housing loans. You have been appointed as a consultant to implement Accounting Hub Cloud.
Which THREE points should you remember while registering the source system for the organization?

• A. Use separate subledgers to provide more security across applications
• B. Use separate subledgers to ensure less data processing in each run
• C. Summarized Transaction type information cannot be sent for accounting transformation
• D. Use separate subledgers to share sub-ledger accounting rules
• E. A transaction type and its associated transaction data typically relate to a single document of transaction

Your client 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. They want to retrieve the value of the Natural Account segment directly from the source system and are seeking your advice on this requirement.
Which TWO should you factor into your advice on how to register the source system using the spreadsheet template to meet your client requirement?

• A. Natural Account should be defined as a "Text" type source
• B. Natural Account should be defined as a "Long Text" type source
• C. Chart of Accounts Value column should be updated with a value of "Yes"
• D. Natural Account should be defined as a "Number" type source

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?

• A. Chart of accounts segment
• B. Value sets
• C. Segment values
• D. Lookup types

Your customer wants to enter subledger journals in adjusting periods using the ADFDi spreadsheets.
Which TWO statements are true about entering journals in adjusting periods?

• A. If the accounting date falls in both the non-adjustment and adjustment periods, the value of the accounting period in the Journal Entry page defaults to the non-adjustment period
• B. Defaulted Period cannot be overwritten
• C. Defaulted Period can be overwritten
• D. If the accounting date falls in both the non-adjustment and adjustment periods, the value of the accounting period in the Journal Entry page defaults to the adjustment period