LM

1- What are two uses of the Column Flattening and Row Flattening features?. Optimize parent/child relationships. Provide audit Trail of trees & Versions. Set the status of a tree to pending review. View information for runtime performance. Create additional versions of a tree.

2- Users with the General Accountant job role have reported that they are unable to access the UK Ledger. They require read/write access to the full ledger. The accounting configuration completed successfully. What should you do to allow access to the ledger?. Assign the General Accounting Manager role to those users. Create a data access set that allows access to the UK Ledger only without assigning it to a user/role combination. Assign the UK reference set to the user/role combination. Assign the data security context value of UK Ledger to the user/job role combination.

3- Which three are considered legal jurisdictions?. Group of Countries. Identifying Zone. State. Single Country. Post Code.

4- Which two can you use to import geographical data?. ADF desktop integration. Geographical data providers. File-based data import (FBDI). SQL Data loader.

5- Your Oracle Fusion Cloud client needs to store balances such as floor space, number of employees, quantities purchased for use in journal allocations, and financial reporting. Currently, in their test environment, they are unable to record statistical amounts. What is the reason?. The currency STAT does not have the ISO currency flag enabled. The currency STAT does not have the statistical unit type enabled. The ledger currency does not have the derivation flag enabled.

6- You need to add new transactional attributes to the journal approval notification in an implementation project. Which two Business Intelligence catalog objects should you copy (or customize) and edit?. Sub template. Output type. Layout Template. Data model. Style template.

7- Your current Oracle Fusion Cloud implementation project includes the configuration of multiple ledgers per country and the setting up of accounting automation to drive journal processing efficiencies. In a particular country (which has a primary, secondary, and multiple reporting currency ledgers), there is a requirement to exclude the country's journal processing from accounting automation. If you enter a ledger set (including all ledgers for that country) on the Exclusion tab of Manage Accounting Automation, what is removed from accounting automation processing?. Just the primary ledger. The secondary and reporting currency ledgers only. The primary and reporting ledgers only. The primary, secondary, and reporting currency ledgers.

8- Your customer is a financial institution that needs to maintain average daily balances (ADB). Which statement is true about this functionality in Oracle Fusion Cloud applications?. When using ADB, you must define a transaction calendar and assign it to your ledger. Average balances are maintained for both actual and budget balances. Average balances are stored for both subledger and general ledger balances.

9- In you SaaS Cloud project you have defined three ledgers that use the same chart of accounts to meet reporting needs, you only require one intercompany payable and one intercompany receivable account. As a best practice , the shared char of account also has an intercompany and future segment. Each ledger has one legal entity assigned to it and each is associated with other balancing segment value. To minimize intercompany rule set up, at which level can you define default rules that would be used between all intercompany organizations, and can override by rules at a lower level of precedence?. Ledger rules. Legal entity rules. Chart of accounts rule. Primary balancing segment rules.

10- You are defining intercompany balancing rules that are applied to a specific source and category, such as Payables and Invoices, or a specific intercompany transaction type, such as Intercompany Sales. Which statement on intercompany configuration is true?. You must define intercompany balancing rules for all sources, categories, and transaction types. You can create a rule for all sources and categories by selecting the source Other and the category Other. Intercompany balancing evaluates the rules in this order: Ledger, legal entity, chart of accounts, and primary balancing segment value.

11- You need to have invoices generated for certain intercompany transactions. Where do you enable invoicing?. Manage Intercompany Organizations. Manage Intercompany System Options. Manage Intercompany Transaction types. Manage Intercompany Receivables assignment.

12- The intercompany accountants on the cloud project are trying to reconcile intercompany balances using the latest intercompany reconciliation report. However, they have some concerns about the information presented in the report and want you to clarify the content in the standard reconciliation report. What is included in the intercompany reconciliation report?. It displays all clearing company balances for the period. It displays ledger balancing lines generated when the primary balancing segment (BSV) is in balance but not the second or third BSVs. It displays the intercompany receivables and intercompany payables lines generated for the provider and receiver of each intercompany transaction.

13- You are defining an income statement report using Financial Reporting Web Studio. Users of the report need to be able to analyze the balances directly from the report. What should you enable to allow this?. Drill Down in Report Functions. Drill Trhougt in Grid Properties. Allow Expansion in Report Functions.

14- Which three Oracle Transactional Business Intelligence (OTBI) objects can be created by using the tools in the Oracle Business Intelligence (BI) catalog?. Dashboards. Infolets. Analyses. Reports. Infotiles.

15- You want to create an Ad Hoc Analysis in Smart View. You enter the following dimensions for the report and click Refresh in the POV. You get Missing instead of a balance. What value did you not specify, which resulted in this?. Product. A particular currency. Intercompany. Cost Center.

16- After user acceptance testing of the new Oracle Fusion Cloud System, the company’s accountants report that they want to be notified of anomalies in certain account balances in real time. The anomalies should include an increase or decrease that is above or below a percentage amount threshold. What is the best way to meet this requirement?. Create an Account Group using Account Monitor. Open a Smart View file saved on your desktop. Use Account Inspector. Perform an account analysis online.

17- You have exported data from your budgeting application into a csv file. What should you use to load that data into General Ledger?. Budget journal spreadsheet. Enterprise Resource Budget Integrator. Application Developer Framework desktop integrator. File-based data import.

18- In a primary ledger, under the System Options, in the Close section, the Prevent General Ledger Period Closure When Open Subledger Periods Exist option has been selected. For which subledger can you opt out of the Period Close Checking feature by using the ORA_GL_INCLD_STRICT_PRD_CLOSE lookup?. Order Management. Lease accounting. Accounts Payables.

19- Your ledger currency is USD. At month end, you have a balance on the Accounts Payable Liability Account of 100,000 Euros, which is equivalent to 136,550 USD. This balance needs to be revalued. The month-end exchange rate for revaluation is 1 Euro = 1.3755 USD. What two statements are true about the resulting revaluation run?. The original journal entry in Euros is updated. The original journal entry in Euros remains the same. You have an unrealized exchange gain recorded. You have an unrealized exchange loss recorded. There is no unrealized exchange gain or loss calculated.

20- You already ran Translation, but a last-minute adjusting journal entry in your ledger currency was entered and posted after you consolidated your results. What is Oracle’s recommended practice when this occurs?. Transalte only the adjusting journal entry. Rerun Revaluation and then rerun Translation. Rerun Translation and then reconsolidate your results.

21- Your new accountants have been making mistakes in reconciling accounts assigned to them. Your account balances have either spiked or dropped 30- 40% every period due to human error. This causes delays in reconciliation. Which feature can be used to proactively notify you of account anomalies in a more timely manner?. Financial reports with embedded charts. Smart View. Account Inspector and its charts. Account Monitor.

22- You are setting up Close Monitor and want to view high-level profit and loss results for each ledger. What should you associate with the ledger set to achieve this?. Account group. Financial Reporting Web Studio report. OTBI report. Trial Balance report.

23- Which feature do you use to achieve multi-step cascading allocations?. Formulas. General Ledger journal entries. Rule sets. Point of View (POV).

24- An Oracle Fusion Cloud customer operating in the financial services sector requires only a subset of the legal entities data captured in the primary ledgers to be transferred to the secondary ledgers. Which journal data conversion level should be selected between the primary and secondary ledgers to achieve this?. Balance. Journal. Adjustment only.

25- Which two are predefined roles in General Ledger?. General Accounting Manager. General Accounting Supervisor. General Accounting Clerk. General Accountant.