FAH – Mock Certification Exam – Portal

1. Question

How many transaction event classes can be set up for a subledger uploaded to Accounting Hub Cloud?

Two
One
Three
Unlimited

2. Question

What attribute of a subledger journal entry is NOT transferred to GL?

Accounting class
Accounting lines
Accounted amounts
Supporting references

3. Question

What feature is NOT provided by Fusion Accounting Hub Reporting Cloud Service (FAHRC)?

Transfer Balances to FAH Reporting Cloud Service
Synchronize setup data from Oracle R12 E-Business Suite to FAH Reporting Cloud Service
Upload transaction data into FAH Reporting Cloud Service
Provide real-time visibility to financial reports in FAH Reporting Cloud Service

4. Question

What is the terminology that is used to identify the “Account Number’, ‘Original Balance’, and ‘Origination Date’ fields?

User Transaction Identifier
Attribute Identifier
Source System Identifier
System Identifier

5. Question

Given the business use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, in some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks” company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income.
How do you pass the calculated value for discount amounts in accounting rules to the corresponding journal line?

Assign it to an accounting method.
Assign it to an account rule.
Assign it to a transaction type.
Assign it to an accounting attribute.

6. Question

What is a user job role data context assignment?

Security privileges assignment to a user job role
Security data role context assignment to a user job role
Security data access context assignment to a user job role
Duty role context assignment to a user

7. Question

What automation option is NOT available when uploading transaction data to Accounting Hub Cloud?

ERP Integration Service
Oracle Web Center Content Client Command line tool
Oracle Virtual Web Center Services
Oracle UCM Web Services

8. Question

In the process of analyzing data from a source system you find that there are no reliable amounts that can be used to build a subledger journal entry. How can you resolve this challenge?

Use a custom formula in an account rule to derive amounts.
Use a custom formula in a description rule to derive amounts.
Use a custom formula in a journal line rule to derive amounts.
Use a custom formula in a supporting reference to derive amounts.

9. Question

Most of the accounting entries for transaction from the source system use TRANSACTION_AMOUNT as a source of the entered amount accounting attribute. For some events, you need to use the TAX_AMOUNT source.
At what level can you override the default accounting attribute assignment?

Journal Entry
Journal Entry Rule Set
Event Class
Journal Line Rule
Event Type

10. Question

Given the business use case:
‘Insurances for Homes’ company provides home insurance services. They have an in-house built system that processes insurance payments received from customers. The end result of the process consists of a listing of individual journal entries in a spreadsheet. They have requirements for get t ing all Journal entries in a secure and auditable repository. Access will be limited to selective staff members. Additionally, the company need to be able to report and view the entries using advanced reporting and analytical tools for segmenting, viewing and understanding data in the journal entries.
The line information may contain more than one line for the same header. When
uploading transactions, which is a way to differentiate each Journal line?

Assign a custom formula.
Assign an accounting attribute.
You do not need to do anything additional.
Assign a line classification or line type attribute.

11. Question

What is the recommended approach for a use case in which some parts of the transaction data must be processed before uploading them to Accounting Hub Cloud?

Use Oracle ERP Integration tool.
Use PaaS tools, for example, ICS – to perform ETL tasks.
Use Oracle OTBI tool.
Use a web service tool.

12. Question

You are explaining to an accountant that account override is an adjustment feature of Subledger Accounting.
Which two traits can help you explain this feature?

The account override feature provides an audit trail by preserving the original subledger journal entry.
The account override feature adjusts the original source transaction.
The account override feature is only intended to correct subledger journals that have been posted.
The account override feature allows users to record a reason for the adjustment.

13. Question

What can you override in a completed subledger journal entry?

The amounts
The descriptions
The account
The supporting Information

14. Question

There is a business requirement to display supporting information with some text and source value at the journal line level that will vary depending on the entered amounts for the line. What is the solution to implement this requirement?

Define line description rule with condition
Define journal line rules with conditions
Define journal entry rule set with condition
Define user transaction line identifier

15. Question

You have created a description rule. When you try to select this description rule to be displayed as a header description rule in a journal entry rule set, you are not able to find this rule in the list of values. What is the possible reason for NOT finding the rule?

The rule is built using a value set source.
The source does not return any value; therefore, the rule is not displayed.
The rule is built using a line level source.
The rule is built using a custom source.

16. Question

Given the business use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, in some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks* company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income.
How do you calculate discounts for use in the accounting rule?

Use flexfield
Use custom formulas
Use mapping set rules
Use analytical calculations

17. Question

‘Insurances for Homes’ company provide home insurance service. They have in-house built system that processes home insurance payments received from customers. The end result of the process consists of a listing of individual journal entries in a spreadsheet. They have requirements for get t ing all journal entries in a secure and auditable repository. Access will be limited to selective staff members. Additionally, be able to report and view the entries using an advanced reporting and analytical tools for slicing and dicing the Journal entries.
Which is a correct example for a formula to prorate amounts evenly across each period? Note that the NumberofGLPeriod is a predefined function that returns the number of non-adjustment accounting periods between two dates.

"Amount" *( NumberofGLPeriod ("Effective Date", "Last Day of Current Accounting Period") + 1)/ (NumberofGLPeriod ("Effective Date", "Expiry Date") + 1)
"Amount" – ("Last Day of Current Accounting Period" – "Effective Date" ) / ("Expiry Date" -"Effective Date")
"Amount" * ("Last Day ol Current Accounting Period" – "Effective Date" + 1) / (("Expiry Date" "Effective Date") + 1)
"Amount" * NumberofGLPeriod ("Effective Date", "Last Day of Current Accounting Period") / NumberofGLPeriod ("Effective Date", 'Expiry Date")

18. Question

Given the business use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, in some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks” company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income.
What do you do to enable costs flow from ‘New Truck’ to ‘Fix Truck’?

Enable intercompany balancing option
Enable balancing rules
Enable legal entity rule
Enable chart of accounts rule

19. Question

Note that the first segment is the primary balancing segment. Which statement is True regarding this subledger journal entry?

It is not balanced by balancing segment.
It is not balanced by entered currency.
It is not balanced by entered amounts.
It appears correct.

20. Question

21. Question

Given the business use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, In some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the Internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks* company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income. ‘New Trucks’ and’ Fix Trucks’ are located in the same country and share chart-of accounts and accounting conventions. How many ledgers are required to be set up?

Two primary ledgers
One primary ledger
One primary, one secondary ledger
One primary, one reporting currency ledger

22. Question

Given the business use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, in some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks” company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income.
What will the typical transaction information be at the header level?

Line Type
Currency
Amount
Customer Number

23. Question

Given the business requirement in the use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, in some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks” company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income.
What are the key transaction types mentioned in the use case?

Pay Insurance and Control Truck Services
Initiate Truck Rentals Contract and Pay Truck Maintenance
Purchase Trucks and Deploy Trucks
Purchase Trucks and Pay Out Trucks

24. Question

Given the business use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, in some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks” company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income.
What would the typical line information be?

Customer Number
Truck Type
Company
Transaction Date

25. Question

How do you enable diagnostics on subledger transaction sources?

Enable diagnostic profile
Enable diagnostic attribute
Enable diagnostic source
Enable transaction debug

26. Question

You have been assigned to troubleshoot a Create Accounting error.
What is the first step you need to take to use the diagnostics framework features?

Set the "SLA: Diagnostics Enabled" profile option.
Run Create Accounting again to generate journal entries for the events that ended in error.
Submit the Accounting Event Diagnostics process.
Run the Accounting Events Diagnostic Report.

27. Question

‘Insurances for Homes’ company provide home insurance service. They have in house built system that processes home insurance payments received from customers. The end result of the process consists of a listing of individual journal entries in a spreadsheet. They have requirements for getting all journal entries in a secure and auditable repository. Access will be limited to selective staff members. Additionally, be able to report and view the entries using an advanced reporting and analytical tools for slicing and dicing the Journal entries.
Insurance premium is to be recognized as income across the-coverage period of the insurance policy. How do you link the two journal lines in the recurring journal entries cases, so that these two journal lines are identified by the accounting process to create recurring Journal entries?

Recognition Journal class
Recurring Journal class
Accounting class
Multiperiod class

28. Question

‘Insurances for Homes’ company provide home insurance service. They have in-house built system that processes home insurance payments received from customers. The end result of the process consists of a listing of individual journal entries in a spreadsheet. They have requirements for getting all journal entries in a secure and auditable repository. Access will be limited to selective staff members. Additionally, be able to report and view the entries using an advanced reporting and analytical tools for slicing and dicing the journal entries.
Insurance premium Is to be recognized as income across the coverage period of the insurance policy. What are the two types of journal lines that need to be set up to generate recurring journal entries for insurance premium in each accounting period?

Offsets and Recognition
Deferral and Recognition
Reversal and Recognition
Multiperiod and Recognition

29. Question

Given the business use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, in some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks” company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income.
How can the automatic recognition of insurance income be implemented in Accounting Hub Cloud?

Set up multiperiod accounting journal lines.
Set up a transaction line reversal.
Create an adjustment journal entry.
Set up automatic Journal line reversal.

30. Question

A new source system has been registered into Accounting Hub Cloud. Users are actively using this new subledqer. Subsequently, the business signed up a contract with a new supplier. A new mapping value that maps suppliers with the accounts needs to be added. You make updates on the mappings in the existing mapping set rule by adding more mapping valued. After saving the update, what is the next required action?

Activate the journal entry rule set.
Activate the accounting method.
There is no required action. The mapping addition is complete.
Download a new transaction data template.

31. Question

Which is an alternate way to implement a mapping set rule?

Define a chart of account rule with conditions.
Define a lookup type rule with conditions.
Define a flexfield rule with conditions.
Define an account rule with conditions.

32. Question

Invoices received from a source system need to use a specific account based on 30 different expense types. However, if the invoice is from a certain supplier type, it needs to go to a default account regardless of the expense type.
What is the solution?

Create a 30 account combination rule with a condition of expense type.
Create an account rule with three rule elements using one for expense type mapping, one for condition of supplier type, and the other one without any condition.
Create two journal line rules with a condition of supplier type.
Create an account rule with 31 rule elements using one condition for each expense type and another for supplier type.

33. Question

Given the business use case:
‘New Trucks’ runs a fleet of trucks in a rental business In the U.S. The majority of the trucks are owned; however, in some cases, ‘New Truck’ may procure other trucks by renting them from third parties to their customers. When trucks are leased, the internal source code is ‘L’. When trucks are owned, the internal source code is ‘O’. This identifies different accounts used for the Journal entry. Customers sign a contract to initiate the truck rental for a specified duration period. The insurance fee is included in the contract and recognized over the rental period. For maintenance of the trucks, the “New Trucks* company has a subsidiary company ‘Fix Trucks’ that maintains its own profit and loss entity. To track all revenue, discounts, and maintenance expenses, ‘New Trucks’ needs to be able to view: total maintenance fee, total outstanding receivables, rental payment discounts, and total accrued and recognized insurance fee income.
How do you set up an account rule that is based on leased and owned trucks?

Set up a mapping set rule.
Set up a lookup value.
Set up a value set rule.
Set up an account source in the source system file and derive the value.

34. Question

Which two options allow validating input values on mapping sets?

Segment values
Lookup types
Value sets
Chart of accounts segment

35. Question

You need to build a complex account rule. Which four value types can you use in your definition?

Value Set
Constant
Existing Account Rule
Account Combination
Mapping Set
Source

36. Question

A financial analyst at your workplace would like to frequently view Journal entries report with all line details attributes with user’s specific set of criteria and pivot table. What is the solution to implement this requirement quickly?

Build a new data warehouse solution.
Build a custom Oracle Transactional Business Intelligence report on subledger accounting subject areas.
Request support team to download subledger Journal entry data.
Run predefined reports and filter the report with the available report parameters.

37. Question

After supporting references balances setup component is tagged to subledger journal entries, what type of reports need to be created so that the information is available to users?

An Oracle Financial Reporting Studio report
A predefined Oracle Business Intelligence Publisher report
An Oracle Transactional Business Intelligence analysis
A Smart View Report

38. Question

Which two can you use to view supporting reference balances?

Use the Supporting Reference Balance Inquiry page.
Submit the standard Supporting Reference Balances Report.
Use Oracle Transactional Business Intelligence to create an analysis using the Subledger Accounting – Supporting Reference Real Time subject area.
Use Business Intelligence Publisher to build a custom report.

39. Question

Which three duty roles are required to perform Accounting Hub setup tasks?

Accounting Hub Maintenance
Subledger Accounting Manager
Accounting Hub Administration
Application Implementation Consultant
Accounting Hub Integration

40. Question

A customer has a business requirement to provide additional information about subledger Journals that cannot be found in a predefined report.
How can you meet this requirement?

Use either Account Monitor or Account Inspector to get required Information.
Build a Financial Reporting Studio report that includes all dimensions.
Build an OTBI analysis that includes a relevant subject area.
Create a Smart View report using the query designer feature.

41. Question

What is the duty role that needs to be assigned for authorizing accounting processing in Accounting Hub Cloud?

Accounting Hub Create Accounting Duty Role
Accounting Hub Import Duty Role
Accounting Hub Integration Duty Role
Accounting Hub Create and Post Journal Entry Duty Role

42. Question

What is the required date format used to import accounting transactions to Accounting Hub Cloud?

The user can customize the date format
MM-DD-YYYY
DD-MON-YYYY
YYYY-MM-DD

43. Question

The new billing source system has been registered into Accounting Hub Cloud. The subledger is in active state. At a later date, the business decides to bring in another legacy system (for example, a payment system) for accounting in Accounting Hub. What two options do you have?

Add this as a new transaction type into existing registered subledger from the user interface.
Register it as a new source system.
Add this as a new transaction typo into existing subledger registration spreadsheet template.
Change the transaction data file.

44. Question

What are all the tabs that are available to be completed in the Register Source System spreadsheet?

Source System and Line Information
Source System and Transaction Information
Source System
Source System, Transaction Information, and Line Information

45. Question

Which transaction source is used to link transaction header and line information?

Transaction Key
Transaction Type
Transaction Date
Transaction Number

46. Question

Which three are mandatory transaction source information?

Transaction Number
Transaction Line
Ledger Name
Transaction Date
Distribution Link

47. Question

What is the key attribute that is used to query journal entries of a registered source system?

Ledger Name
Transaction Date
Journal Source
Accounting Date

48. Question

To support foreign currency transaction in Accounting Hub, which accounting attributes must be assigned a source?

Conversion type and conversion date
Conversion type, conversion date and conversion rate
Conversion date and conversion rate
Conversion type

49. Question

After registering a new source system into Accounting Hub and going live for a short period, your customer identified the need to add additional transaction sources. What should you do?

Add new transaction sources from the user interface.
Register another source system that includes these new transaction sources.
Tell them this cannot be implemented.
Add new transaction sources in the current source system registration spreadsheet and re-upload the spreadsheet file.

50. Question

Which is used to track a specific transaction attribute on subledger journal entries?

Value set rules
Lookup value rules
Supporting references
Account rules

51. Question

You are implementing Fusion Accounting Hub for your external Accounts Receivables system. The external system sends invoices billed and cash receipts in a flat file, along with the customer classification information. You want the accounting amounts to be tracked by customers too but you do not want to add a Customer segment to your chart of accounts. What is the solution?

Use the Open Account Balances Listing report that has balances by customer.
Use the Third Party Control Account feature.
Use Supporting References to capture customer classification information.
Capture customer information as the source and develop a custom report using Online
Transactional Business Intelligence (OTBI).

52. Question

Which two actions can you accomplish for a registered source system?

Add new event classes through the user interface.
Modify the subledger application name as long as there are no pending accounting entries.
Import the source system registration spreadsheet template multiple times as long as there are no accounting rules created yet.
Revise source Information through the user interface and add more sources.

53. Question

A customer has four external systems: Consumer Loan, Auto Loan, Home Loan and Insurance. Functional users are allowed to process and view transactions and accounting for all these systems. Which two implementations allow similar accounting rules to be shared?

One subledger for the 3 Loan systems and one subledger for Insurance.
One subledger for each source system.
One subledger for all 4 source systems.
One subledger for Consumer Loan and Auto Loan, and one subledger for Home Loan and Insurance.

54. Question

Where do you define the currency conversion type to be used in converting accounted amount for reporting currency ledger?

Specify Ledger Options
Manage Accounting Attribute Assignments
Manage Reporting Currencies
Manage Subledger Accounting Options

55. Question

While creating a journal entry rule set you are NOT able to use an account rule that was created recently.
Which two reasons can explain this?

The account rule is using sources that have not been assigned to the same event class that is associated to the journal entry rule set.
The account rule is defined with conditions that are not allowing the assignment.
The account rule does not return any valid account value.
The account rule is defined with a different chart of accounts from the journal entry rule set.

56. Question

What are the tables or views from which the Create Accounting process takes source data that is used in accounting rules to create journal entries referred to as?

Transaction objects
Event entities
Source objects
Mapping sets

57. Question

A customer’s business requirement demands a more granular view of transferred subledger journal entries in GL.
Which of the available General Ledger Journal Entry Summarization options meets this requirement?

Summarize by GL Date
Summarize by GL Period
Group by GL Date
Transfer in Details

58. Question

What kind of sequence can be assigned to subledger journal entries at the time that the journal entries are created in final mode?

Reporting Sequence
Accounting Sequence
Journal Entry Sequence
Document Sequence

59. Question

What is NOT included in the minimum required accounting attribute assignments?

Second Distribution Identifier
First Distribution Identifier
Distribution Type
Accounting Date

60. Question

What is the terminology that is used to refer to the number of transactions processed by Create Accounting in one commit cycle?

Virtual Machine Processing Size
Accounting Unit Commit Size
Buffer Unit Size
Processing Unit Size