Nothing Special   »   [go: up one dir, main page]

Revaluations and Translation To Revalue and Translate Currencies Stored in The Essbase Cube

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 5
At a glance
Powered by AI
The document discusses questions and answers related to working with Essbase and implementing charts of accounts for companies with intercompany transactions.

Make sure the tree version was published successfully

Run Closing Status reports

Question: 1

When working with Essbase, versions of the tree hierarchy as defined in the General Ledger Cloud are
not available in the Essbase balances cube. What should you do to correct this situation?

Ans: Make sure the tree version was published successfully

Question: 2
You are setting up Close Monitor, which compromises a ledger set hierarchy definition.
Which two components of the enterprise structure should the ledgers in the ledger set share? (Choose
two.)

Ans:

A. Accounting Calendar
B. Chart of Accounts

Question: 3
You want to monitor the close process of all your financial subledgers and ledgers. How can you quickly
obtain this information?

Ans: Run Closing Status reports

Question: 4
Your customer has three legal entities, 50 departments, and 10,000 natural accounts. They use
intercompany entries. What is Oracle’s recommended practice when implementing a new chart of
accounts? How many segments and what segment qualifiers should be used?

Ans: Define five segments for the company, department, natural account, intercompany, and future use
segment. The qualifiers should be primary balancing segment, cost center segment, natural account
segment, intercompany segment, and no qualifier, respectively.

Question: 5
Which feature outside of reporting and analysis leverages the Essbase cube?

Ans: Revaluations and translation to revalue and translate currencies stored in the Essbase cube

Question: 6
You want to define an allocation rule where segment values are constants for rules and formulas. What
should you do?

Ans: Specify Run Time Prompts (RTP)


Question: 7
After loading your budget data into General Ledger Cloud, you can view budget balances using these
features. Which feature does not belong on the list?

Ans: Application Development Framework Desktop Integration Budget Balances Report

Question: 8
Your customer is implementing budgetary control with encumbrance accounting. Your customer has
businesses in Australia, New Zealand, and Singapore with a ledger in each country with a Corporate
chart of account instance that has four segments. Which three statements are true regarding the
creation of a control budget? (Choose three.)

Ans:
A. Control budgets are always absolute to generate encumbrance accounting
B. A control budget can allow override rules only if the control level is absolute
C. A control budget can be associated with a different calendar than accounting calendar

Question: 9
You need to define multiple allocation rules as efficiency as possible.
Which three components can be reused across allocation rules? (Choose three.)

Ans:

A. Point of View (POV)


B. Run Time Prompts (RTP)
C. RuleSets

Question: 10
The budget managers specify the budget accounts they want to monitor and decide on percentage
threshold of funds availability. Where must you define the details while analyzing budget balances in
the Budget Account Monitor page?

Ans: Budget Account Group

Question: 11
What are the two possible reasons for encumbrance created on the purchase order to go back to
the budget or funds availability? (Choose two.)

Ans:
A. The purchase order is canceled or finally closed or rejected without performing any receipt or
invoice
B. When the purchase order is set to accrue at receipt and partially received, then canceled or
finally closed, encumbrance goes back to the extent of the unreceived amount
Question: 12
Your customer has many eliminating entries to eliminate intercompany balances. The General
Ledger does not include a purpose-built Consolidation feature. How would you automate the
process of creating eliminating entries, assuming your customer is not using Oracle Hyperion
Financial Close Management?

Ans: Use the General Ledger’s Calculation Manager to define an allocation definition to
eliminate entries that you can generate every period

Question: 13
Which reporting tool is best suited for submitting high-volume transactional reports, such as
Invoice Registers or Trial Balance reports, that can be configured to extract the data in Rich Text
Format or xml?

Ans: Business Intelligence Publisher (BI Publisher)

Question: 14
You are implementing Segment Value Security rules. Which two statements are true? (Choose
two.)

Ans:
A. When you enable Segment Value Security on a segment, users will not be able to access any
values until you grant access to users and products

B. You can use hierarchies to define rules

Question: 15
You want to specify Intercompany System Options. Which three factors should you consider? (Choose
three.)
Ans:
A. whether to allow receivers to reject intercompany transactions
B. whether to enforce an enterprise-wide currency or allow intercompany transactions in local
currencies
C. automatic or manual batch numbering and the minimum transaction amount

Question: 16
The Accounting Manager requests that a schedule be created to automatically post journals from
subledgers at different times. Which journal attribute should you use to set the automatic posting
criteria?

Ans: Journal Source


Question: 17
Encumbrance accounting is enabled for your ledger. An encumbrance journal dated 3/15/16 was
recorded for a purchase order.
The invoice was entered on 5/5/16, but the invoice accounting date was 4/20/16. The encumbrance
journal for liquidating the purchase order encumbrance is dated 5/5/16. What is causing this?

OR
You've set up the standard accrual with encumbrance accounting for your ledger and
you realized that the encumbrance journals are defaulting with current date as the
accounting date. What is causing this?

Ans: The current transaction accounting date was set up under the encumbrance accounting
Default Date Rule

Question: 18
Account combinations can be created and/or modified using the Import Account Combinations file-
based data import (FBDI).

Which represents the appropriate upload steps?

Ans: Insert rows into the GL_BULK_COMBINATIONS_INT table using the FBDI template and
then submit the Import Account Combinations process.

Question: 19
You are defining an income statement report. You want to allow viewers of the report to be able to drill
down from report balances to the underlying transactions. What so you need to enable?

Ans: Drill Through in Grid Properties

Question: 20
Which three objectives must be considered when designing the chart of accounts? (Choose three.)

Ans:
A. Anticipate growth and maintenance needs as organizational changes
B. Effectively manage an organization’s financial business
C. Consider implementing a single, global chart of accounts

Question: 21
In Financial Cloud, which three reporting tools can be used to access General Ledger balances?
(Choose three.)

Ans:
A. Oracle Transactions Business Intelligence
B. Smart View
C. Financial Reporting Studio
Question: 22
Budgetary control for accounts 5020 and 5021 has a budget of $90,000USD each for the year
2012. The accounts also have balances on obligation of $10,000 USD for each and an
expenditure of $20,000 USD for each. A Fund of $50,000 USD is available for account 5010 only.
You have run the Encumbrance Year End Carry Forward process for obligation from the last
period of the year 2012 to the first period of year 2013. Which statement is true?

Ans: If you have included 5020 and 5021 in the encumbrance rule, then budget balances
$90,000 USD, obligation $10,000 USD, and expenditure $20,000 USD, and the funds available
$50,000 USD will be carried forward

Question: 23
Your customer wants to create fully balanced balance sheets for the Company, Line of Business,
and Product segments for both financial and management reporting. What is Oracle’s
recommended method for doing this?

Ans: Create three segments for the Company, Line of Business, and Product segments and
qualify them as primary balancing segment, second, and third balancing segments, respectively

Question: 24
Your customer uses Financials Cloud, Projects, Inventory and Procurement. Which two
statements are true regarding intercompany accounting for these products? (Choose
two.)

Ans:
A. Within Financials Cloud, Intercompany Balancing Rules are used to balance both cross-ledger
intercompany transactions and single-ledger Intercompany journals
B. They need to license a separate stand-alone Intercompany product that acts as the
Intercompany Accounting Hub

Question: 25
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. What feature can you use to be proactively notified of
account anomalies in a more timely manner?

Ans: Smart View

You might also like