Oracle 1z1-960 Value Pack (Frequently Bought Together)

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

• A. Value Set
• B. Account Combination
• C. Existing Account Rule
• D. Mapping Set
• E. Constant
• F. Source

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

• A. journal entries and journal approval to create journals that update balances to the cube directly
• B. calculation manager to perform allocations based on multidimensional balances and budgets
• C. revaluations and translation to revalue and translate currencies stored in the Essbase cube
• D. period closing and opening of ledgers to keep General Ledger Cloud and the Essbase cubes in sync

Your customer has enabled encumbrance accounting. You have a control budget with the advisory level set at control. For November 2015, your budget for a given combination is $5,000 USD. You have an approved requisition of $900 USD and you have an approved purchase order of $2,500 USD. An adjustment encumbrance journal is created in the General Ledger for the obligation type for $1,600 USD. You then cancelled the approved PO line of $400 USD. For November 2015, you created a new invoice by matching to the PO for $2,100 USD.
Which two statements are true?

• A. Purchase order encumbrance will be released for $2100 USD.
• B. Encumbrance entries are created only for nonmatched Invoices, so the system will not create any encumbrance accounting entries.
• C. The system always consumes budget of future periods if the limit for the current period is expired, so December 2015 budget will be considered for reservation.
• D. As you are matching to a purchase order, the system will allow the user to create an invoice with the reservation status of Reserved.
• E. As there are cancellations for $400 USD, the system will partially reserve the funds in November 2015 and fully reserve it in December 2015.

You have enabled budgetary control and have a control budget set to Advisory control level. For September
2016, your budget for a given account combination is $5,000 USD. In the same month, there is an approved requisition for that account of $900 and an approved purchase order for that account of $2,500 USD. There is also a General Ledger adjustment journal entry for that account of $1,600 USD. An approved purchase order line of $400 USD is then cancelled. And an invoice is matched to the purchase order for $2,100 USD.
Which two statements are true? (Choose two.)

• A. No change
• B. Funds reservation only happens for non-matched invoices, so the system will not reserve funds.
• C. The system always consumes budget of future periods if the limit for the current period is expired, so October 2016 budget will be considered for reservation.
• D. Purchase order encumbrance will be released for $2,100 USD.
• E. As there are cancellations for $400 USD, the system will partially reserve the funds in September 2016 and fully reserve it in October 2016.

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?

• A. Create two segments where the first segment represents the concatenation of Company and Line of Business, and then enable secondary tracking for the Product Segment.
• B. Use account hierarchies to create different hierarchies for different purposes and use those hierarchies for reporting.
• C. Create three segments for the Company, Line of Business, and Product segments and qualify them as the primary balancing segment, second, and third balancing segments, respectively.
• D. Create a segment that acts as the primary balancing segment and create values that represent a concatenation of all three business dimensions.