Oracle - 1z0-1004

Question #:1

Most of the accounting entries for transactions from your source system use TRANSACTION_AMOUNT as a
source of the entered amount accounting attribute. For some events, you need to use TAX_AMOUNT as the
source.

At what level can you override the default accounting attribute assignment?

A. Event Type

B. Journal Line Rule

C. Event Class

D. Journal Entry Rule Set

E. Journal Entry

Answer: D

Question #:2

The Accounting Manager requests that a schedule be created to automat.ca.ly post Journals from subledgers at
different times. Which journal attribute should you use to set the automatic posting criteria?

A. Journal Source

B. Journal Category

C. Journal Batch

D. Journal Description

Answer: A

Explanation
This example shows how to create an “AutoPost Criteria Set “to post your general ledger journal entries that
were created by the journal import process for your subledger transactions. Your enterprise, InFusion
Corporation:

•Implemented Oracle Fusion General Ledger and the Oracle Fusion subledgers: Payables and Receivables.

•Uses a non-Oracle subledger called Fast Assets for fixed asset tracking and depreciation.

•Plans to automate posting of your general ledger journal batches created by the journal import process to
protect the subledger sourced journal entries from edits or deletion that might cause an out-of-balance situation
between your subledgers and general ledger.

1 of 33
 Oracle - 1z0-1004

Consider the following points while creating your criteria set:

•Use the All option for category and accounting period to reduce maintenance and ensure that all journal
imports are included in the posting process.

•Create a criteria set that includes all your subledger sources. Create multiple criteria sets by source only if you
need to schedule different posting times to balance close activities or reduce processing time.

Creating an AutoPost Criteria Set

Create your AutoPost Criteria Set to automatically post journal entries from both Oracle and non-Oracle
subledgers.

1.On the Manage AutoPost Criteria Sets page, click the Create icon to open the Create AutoPost Criteria Set
page.

2.Enter the set name: All Journal Imported Entries

3.Select the Enable check box.

4.Enter the description: Posting journals imported from the subledgers.

5.Click the Add Row icon to add each new line.

6.Complete the fields, as shown in the table below:

Priority Ledger or Ledger SetSourceCategory Accounting Period

1InFusion Corporation LedgerPayablesAllAll

2InFusion Corporation LedgerReceivablesAllAll

3InFusion Corporation LedgerFast AssetsAllAll

7.For all three sources, select Yes for the process all criteria option and enter 30 as the number of days before
and after submission date.

https://fusionhelp.oracle.com/helpPortal/topic/TopicId_P_6D13D7B2C8D92921E040D30A68811BBD

Question #:3

Journal Description Rules ate assigned to Subledger Journal Entry Rule Sets. What are the other three
subcomponents of a Subledger Journal only Rule Set?

A. Accounting Date

B. Chart of Accounts

C. Journal line Rules

D.

2 of 33
 Oracle - 1z0-1004

D. Account Rules

E. Supporting References

Answer: C D E

Question #:4

On which three occasions are Essbase balances updated?

A. Every time the tree version is published

B. Every time journals are posted to the general ledger

C. Every time you run the batch program called "Update Essbase Balances"

D. At report run-time

E. Every time you open a new period

Answer: A B D

Question #:5

Budgetary control for accounts 5020 and 5021 has a budget of $90,000 USD 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 5020 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?

A. 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 only will be carried forward.

B. 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.

C. If you have included 5020 and 5021 in the encumbrance rule, then obligation $10,000 USD and
expenditure $20,000 USD only will be carried forward.

D. The Encumbrance Year End Carry Forward process will run for all the accounts to carry forward the
general ledger balances.

E. If you have included 5020 and 5021 in the encumbrance rule, then only the obligation of $10,000 USD
will be carried forward.

Answer: B

3 of 33
 Oracle - 1z0-1004

Question #:6

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?

A. The control budget structure has all the chart of account segments as budget segments.

B. Control budgets are always absolute to generate encumbrance accounting.

C. A control budget is associated to a ledger and creates three control budgets for Australia. New Zealand,
and Singapore.

D. A control budget can allow override rules only if the control level is absolute.

E. A control budget can be associated with a different calendar than accounting calendar.

Answer: D E

Explanation
Override settings only apply to accounts within a control budget that have Absolute control level. For
transactions with accounts that have Absolute control level, if there are insufficient funds based on funds
available by period and account, or if the period is not open, there is an option to request an override for
requisitions, purchase orders, Payables invoices or General Ledger journals.WHY ARE BUDGETARY
CONTROL AND ENCUMBRANCE ACCOUNTING SEPARATED?Some organizations want to budget and
control spending at a different level than general ledger accounting. Oracle ERP Cloud supports this by
allowing the budget calendar and account structure used in Budgetary Control to be different from the
accounting calendar and chart of accounts used in General Ledger

Question #:7

You are setting up Close Monitor, which comprises a ledger set hierarchy definition.

Which two components of the enterprise structure should the ledgers in the ledger set share? (Choose two.)

A. Chart of Accounts and Business Units

B. Accounting Calendar

C. Chart of Accounts, Currency, Accounting Calendar, and Subledger Accounting Method

D. Chart of Accounts

E. Legal Entities, Business Units, and Chart of Accounts

Answer: A B

4 of 33
 Oracle - 1z0-1004

Question #:8

What is the most efficient way to add a new year to the accounting calendar?

A. Add the periods manually

B. Use the Add Year button

C. Import the periods from a spreadsheet

D. The application automatically populates the next year when you open the first period of a new fiscal
year.

Answer: D

Explanation
https://docs.oracle.com/cd/E13228_01/fscm9pbr0/eng/psbooks/fspf/chapter.htm

Question #:9

You are using budgetary control. You have an open purchase order for $500 USD, and an invoice for $300 is
matched to the purchased order.

Both 3re Partially Reserved.

A. The purchase order is Liquidated and the invoice is Partially Reserved.

B. The purchase order is Partially Liquidated and (he invoice Is Partially Reserved.

C. The purchase order is Partially Liquidated and the invoice will be Reserved.

D. Both are reserved.

E. The purchase order is Open and the Invoice is validated.

Answer: C

Explanation
https://docs.oracle.com/cloud/latest/financialscs_gs/FAPPP/FAPPP1011878.htm#FAPPP1011858

Question #:10

You want to process multiple allocations at the same time. What feature do you use?

A. RuleSets

5 of 33
 Oracle - 1z0-1004

B. Point of View (POV)

C. Formulas

D. General Ledger Journal entries

Answer: C

Question #:11

You are creating financial statements and want to have charts, such as a bar graph, automatically inserted to
improve the understanding of the financial results.

How would you achieve this?

A. When viewing the report, download to Excel and use Excel's Charting features to create your bar graph.

B. When designing your financial statement using Financial Report (FR), embed a chart into your report.

C. Use Account Inspector that automatically creates graphs on financial balances.

D. Use Smart View, which is and Excel Add-on.

Answer: C

Explanation
https://docs.oracle.com/cd/E37017_01/doc.1115/e22893/F479559AN10590.htm

Question #:12

You want to automatically post journal batches imported from subledger source to prevent accidental edits of
deletions of the subledger sources journals, which could cause an out-of-balance situation between your sub
ledgers and general ledger.

Which two aspects should you consider when defining your AutoPost Criteria?

A. Use the All option for category and accounting period to reduce maintenance and ensure that all
imported journals are included in the posting process.

B. Include all of your sub ledger sources in the AutoPost Criteria. Divide up criteria sets by subledger
source only if you need to schedule different posting times.

C. Create your AutoPost criteria using minimal source and categories.

D. Schedule your AutoPost Criteria set to run during off-peak hours only

Answer: B

6 of 33
 Oracle - 1z0-1004

Question #:13

While creating a Journal Entry Rule Set, you are not able to use an Account Rule recently created.

Which two options explain that? (Choose two.)

A. The Account Rule is defined with a different chart of accounts from the Journal Entry Rule Set.

B. The Account Rule's chart of accounts have no account values assigned

C. The Account Rule's conditions are not defined.

D. The Account Rule is using sources assigned to different event classes from that of the associated Journal
Entry Rule Set.

Answer: B D

Question #:14

Your enterprise structure has one ledger and two business units. Business unit one wants to enable budgetary
control for Requisitioning only in Procure-to-Pay Business Functions and business unit two wants to enable
budgetary control for Payable Invoicing only in Procure-to-Pay Business Functions.

Which two statements are correct? (Choose two.)

A. While defining control for business unit two, enable control at Requisitioning and define the exceptions
to only include invoicing.

B. Define control for business unit two to disable control for Requisitioning, Purchasing, and Receiving.

C. Define budgetary control at ledger level with Budgetary Control Exceptions for each business unit.

D. While defining control for business unit one, disable control for Purchasing, Payable Invoicing, and
Receiving.

E. While defining control for business unit one, enable control at purchasing and define the exceptions to
only include requisitioning.

F. Define budgetary control at ledger level and only encumbrance controls at the business units.

Answer: A F

Question #:15

During implementation, a consultant accidentally designated the cost center segment as the natural account.
Values have already been assigned and journals have been posted.

Select the process that allows you to change the qualifier back to cost center qualifier.

7 of 33
 Oracle - 1z0-1004

A. Create a new chart of accounts.

B. Delete the segment and create a new segment with the correct qualifier.

C. Change and save the segment qualifier.

D. Delete the chart of accounts and create a new one.

Answer: D

Question #:16

You want to prevent intercompany transactions from being entered during the last day of the close. What
should you do?

A. Freeze the Intercompany Journal source in General Ledger.

B. Close all subledger periods.

C. Close the General Ledger period in the Manage Accounting Periods page,

D. Close Intercompany periods in Fusion Intercompany.

Answer: D

Question #:17

your customer has enabled budgetary control for purchase orders. The have a purchase order for $1,000 USD
is fully reversed. An invoice for $600 is entered an matched to the purchased order, and the purchase order ids
further invoicing.

What happens to the remaining $400 USD?

A. Invoice type will have less funds available by $400 USD.

B. $400 USD will the expired and not available for use.

C. $400 USD will be added back to available funds.

D. Only obligation type will have $400 USD funds available.

E. Manual encumbrance Journal needs to be entered in General Ledger to release the budget amount of
$400 USD.

Answer: C

Explanation

8 of 33
 Oracle - 1z0-1004

What happens to the available funds when I perform a final match on a purchase order that requires budgetary
control?

The purchase order is finally closed, which releases funds for the quantities that aren't received or invoiced.

For example, if a purchase order for 1,000 USD has only one invoice for 600 USD, the final closing of the
purchase order releases the 400 USD from the purchase order and adds it to the available funds.

https://docs.oracle.com/en/cloud/saas/financials/r13-update17d/fappp/invoices.html#FAPPP1326380

Question #:18

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?

A. Budget Controller

B. Budget Group

C. Account Group

D. Budget Account Group

E. Application Development Framework Desktop Integration (ADfdi)

Answer: D

Question #:19

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

A. Effectively manage an organization's financial business.

B. Consider implementing a single, global chart of accounts

C. Anticipate growth and maintenance needs as organizational changes occur.

D. Limit the number of segments to those you need today to reduce data entry.

E. Try to use all 30 segments and 25 characters per segment because you cannot change it later.

Answer: A B C

Question #:20

All of your subsidiaries can share the same ledger with their parent company and all reside on the same
application instance. They do perform intercompany accounting.

9 of 33
 Oracle - 1z0-1004

What is Oracle’s recommended approach to performing consolidations?

A. Use Oracle Hyperion Financial Management for this type of complex consolidation.

B. Use General Ledger's Balance Transfer programs to transfer subsidiary ledger balances to the parent
ledger, and then enter eliminating entries as a separate balancing segment in the parent ledger.

C. Use General Ledger's Financial Reporting functionality to produce consolidated reports by balancing
segment where each report represents a different subsidiary. Any eliminating entries can be entered in
yet another separate balancing segment.

D. Define multiple ledgers for consolidation and report on ledger set.

Answer: A

Question #:21

You want to monitor the close process if all your financial subledgers and lodgers. How can you quickly
obtain this Information?

A. Use the Manage Accounting Periods page to view the status el all subledgers and ledgers.

B. Access each subledgers' calendar and General Ledger's Manage Accounting Periods page to view the
status of each period.

C. Run Closing Status reports.

D. Use Close Monitor In General Accounting Dashboard.

Answer: C

Question #:22

In which two ways can your users customize the Springboards and Work Areas to suit their individual working
styles?

A. Users have very little control customizing their Springboards and Work Areas; they can only resize
columns.

B. They can use Personalization to move and remove regions <rom those pages.

C. They can have the System Administration customize pages for them using Page Composer

D. They can format each table by hiding and showing columns, moving columns, and resizing columns.

Answer: B D

Question #:23

10 of 33
 Oracle - 1z0-1004

Which AMX builder method is most effective in routing the journals to the Accounting Manager when its
subordinate, the General Accountant, enters a journal?

A. Supervisory level approval

B. Dynamic Approval Groups

C. Approval Groups

D. Management Chain approval

E. Cost center based approval

Answer: A

Question #:24

Management has added a requirement to segregate the duties of transferring journals to the General Ledger
from the posting function. Which two new features allow this segregation?

A. Uncheck the Enable Posting from the Manage Subledger Accounting Options task.

B. Journal entry spreadsheets are not impacted by this new function.

C. Must have separate user defined roles using the privilege

D. For previously scheduled automated processes, it Is recommended to cancel and rescheduled the process
for the option to be effective.

Answer: C

Question #:25

Which reporting tool is best suited lot 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?

A. Oracle Transactional business Intelligence (OTBI)

B. Business Intelligence Publisher (BI Publisher)

C. Financial Reporting Center

D. Smart View

E. Oracle Data Visualization Cloud Service

11 of 33
 Oracle - 1z0-1004

Answer: A

Question #:26

In Financials Cloud, which three reporting tools can be used to access General Ledger balances?

A. Application Composer

B. Oracle Enterprise Repository

C. Oracle Transactional Business Intelligence

D. Financial Reporting Studio

E. Smart View

Answer: C D E

Question #:27

You already ran Translation, but a last-minute adjusting journal entry in your ledger currency was entered after
you consolidated your results.

What is Oracle’s recommended practice when this occurs?

A. Translate only the adjusting journal entry.

B. Rerun Revaluation and then rerun Translation

C. Rerun Translation and then reconsolidate your results

D. Enter another adjusting journal entry in the target currency to true up the balances.

Answer: C

Question #:28

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?

A. The subledger accounting option is set to system date.

B. The actual accounting date was set up under the encumbrance accounting Default Date Rule.

C. The system date was set up under the encumbrance accounting Default Date Rule.

12 of 33
 Oracle - 1z0-1004

D. The current transaction accounting date was set up under the encumbrance accounting Default Date
Rule.

E. The prior related transaction accounting date was set up under the encumbrance accounting Default Date
Rule.

Answer: A

Question #:29

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

A. Application Development Framework Desktop Integration Budget Balances Report

B. Account Monitor

C. Smart View

D. Account Inspector

Answer: A

Explanation
https://fusionhelp.oracle.com/helpPortal/topic/TopicId_P_C64F14F282FA6D2FE040D30A68811770

Question #:30

Your company has complex consolidation requirements with multiple general ledger instances. You are using
Oracle Hyperion Financial Management to consolidate the disparate General Ledgers. You can typically map
segments between your general ledger segment to a Hyperion Financial Management segment, such as
Company to Entity, Department to Department, and Account to Account.

What happens to segments in your source general ledger, such as Program, that cannot be mapped Hyperion
Financial Management?

A. No data is transferred.

B. Data is summarized across segments that are not mapped to Hyperion Financial Management

C. Errors occur for unmapped segments. You must map multiple segments from source general ledgers to
the target segment in Hyperion Financial Management.

D. The unmapped segments default to future use segments in Hyperion Financial Management

Answer: C

13 of 33
 Oracle - 1z0-1004

Question #:31

When working with Essbase, versions of the tree hierarchy as defined in the Fusion not available in the
Essbase balances cube.

What should you do to correct this situation?

A. Make sure the tree version was published successfully.

B. Make sure to flatten the rows of the tree version.

C. Make sure the tree is active.

D. Redeploy the chart of accounts.

Answer: A

Question #:32

Which two methods can your General Ledger accountants use to more easily view large amounts of contained
in the tables in their work areas? (Choose two.)

A. Detach the table to resize it to the maximum size of the monitor

B. Export the table to Excel.

C. Run a Business Intelligence Publisher report with Excel as the output format.

D. Use the Freeze feature on the tables to scroll through large amounts of data.

Answer: A B

Question #:33

You are reconciling your subledger balances and you need a report that includes beginning and ending account
balances and all transactions that constitute the account's activities.

What type of report will provide this type of information?

A. An Online Transactional Business Intelligence (OTBI) report to create ad hoc queries on transactions
and balances

B. Account Analysis Reports

C. Journals Reports

D. Aging Reports

Answer: C

14 of 33
 Oracle - 1z0-1004

Question #:34

What are the two purposes of a secondary ledger? (Choose two.)

A. It can differ from its primary ledger by the accounting method, chart of accounts, accounting calendar,
currency, and/or journal processing options.

B. It should only be used to maintain balances for processing performance.

C. It is used to main balances in a different currency only.

D. It should not be used when trying to meet local accounting requirements.

E. It is an optional ledger that is linked to a primary ledger for the purpose of tracking alternative
accounting.

Answer: A E

Question #:35

All of your subsidiaries reside on the same application instance, but some of them require a different chart of
accounts and/or accounting calendar and currency. There is no minority interest or partial ownerships.

What is Oracle's recommended approach to performing consolidations?

A. Use Oracle Hyperion Financial Management for this type of complex consolidation.

B. Translate balances to the corporate currency, create a chart of accounts mapping to the corporate Chart
of accounts, then transfer balances to the corporate consolidation ledger using the balance transfer
program.

C. Translate balances to the corporate currency for ledgers not in the corporate currency, use General
Ledger's Financial Reporting functionality to produce consolidated reports by balancing segment where
each report represents a different subsidiary.

D. Create separate ledgers for each subsidiary that shares the same chart of accounts, calendar, currency
and accounting method. Create a separate elimination ledger to enter intercompany eliminations, then
create a ledger set across all ledgers and report on the ledger set.

Answer: D

Question #:36

You set up a secondary ledger using the Manage Secondary Ledger task and selected a data conversion level
of subledger.

Which two actions should you now perform? (Choose two.)

15 of 33
 Oracle - 1z0-1004

A. Define Supporting References with balances.

B. Assign a Subledger Accounting Method to the secondary ledger.

C. Define Journal Conversion Rules that exclude subledgers.

D. Ensure that the Accounting Calendar and Currency are the same as the Primary Ledger.

E. Define Journal Conversion Rules that include subledgers in order to transfer subledger transactions.

Answer: B E

Question #:37

You want to be notified of anomalies in certain account balances in real time. What is the most efficient way
to do this?

A. Perform an account analysis online.

B. Open a Smart View file saved on your desktop.

C. Create an Account Group using Account Monitor.

D. Use Account Inspector.

Answer: A

Question #:38

Identify three roles that get access to the reports in the Fusion Accounting Hub Reporting Cloud Service
(FAHRCS). (Choose three.)

A. Controller

B. Financial Analyst

C. Business Intelligence Administrator (BI Admin)

D. General Accounting Manager

E. General Accountant

Answer: B C D

Question #:39

Your customer uses Financials Cloud, Projects, Inventory and Procurement.

16 of 33
 Oracle - 1z0-1004

Which two statements are true regarding intercompany accounting for these products? (Choose two.)

A. Each product has its own Intercompany Accounting feature that needs to be set up separately.

B. Intercompany Balancing Rules are defined centrally and applied across Financials and Project Portfolio
Management.

C. Within Financials Cloud, Intercompany Balancing Rules are used to balance both cross-ledger
intercompany transactions and single-ledger intercompany journals.

D. They need to license a separate stand-alone Intercompany product that acts as the Intercompany
Accounting Hub.

Answer: A D

Question #:40

Your customer wants to use a clearing company to automatically balance Intercompany entries. Which three
statements are true regarding the use of a clearing company value? (Choose three.)

A. Clearing companies are not supported.

B. If you map legal entities to balancing segment values, then a clearing company can only be applied
within a legal entity.

C. You must map legal entities to balancing segment values in order to use a clearing company.

D. If you do not map legal entities to balancing segment values, then a clearing company can be applied to
any journal within the ledger.

E. If you choose to use a clearing company, you can define a default clearing company value or select the
clearing company value directly in the general ledger journal.

Answer: A C E

Question #:41

You operate in a country whose unstable currency makes it unsuitable for managing your day-to-day business.
As a consequence, you need to manage your business in a more stable currency while retaining the ability to
report in the unstable local currency.

What would be your recommendation when defining ledgers?

A. Define Balance-Level Reporting Currencies in the more stable currency and run Translation as often as
you need.

B. Use Journal-Level or Subledger-Level Reporting Currencies denominated in the more stable currency.

C. Run Revaluation as often as you need to the more stable currency and report on the more stable

17 of 33
 Oracle - 1z0-1004
C.
currency's balances.

D. Create a secondary ledger that uses a different chart of accounts that is denominated in the more stable
currency.

Answer: B

Explanation
http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e20374/F484499AN16AFA.htm

Question #:42

You want to specify Intercompany System Options.

Which three factors should you consider? (Choose three.)

A. Whether to enforce an enterprise-wide currency or allow in intercompany transactions in local

B. Whether to allow receivers to reject intercompany transactions

C. Automatic or manual batch numbering and the minimum transaction amount

D. Automatic or manual batch numbering and the maximum transaction amount

E. The approvers who will approve intercompany transactions

Answer: A B D

Question #:43

Your financial Analyst needs to interactively analyze General Ledger balances with the ability to drill down to
originating transaction. Which three features facilitate this?

A. Sunburst reports

B. Online Transactional Business Intelligence

C. Account Inspector

D. Account Monitor

E. Smart View

Answer: B C E

Question #:44

18 of 33
 Oracle - 1z0-1004

You just submitted the Accounting Configuration. What two things must happen before you can enter
journals? (Choose two.)

A. You must define a Data Access Set to obtain full read/write access to the ledgers in the Accounting
Configuration.

B. A Data Access Set with full read/write access to the ledger is automatically created.

C. You must re-deploy the chart of accounts.

D. You must assign the job role and data security context to each user.

Answer: A D

Question #:45

You need to define a chart of accounts that includes an intercompany segment. Your customer plans to use
segment value security rules for the Company segment.

What is Oracle’s recommended method to define this chart or accounts?

A. Share the same value set for the company and intercompany segments to reduce chart of accounts
maintenance.

B. Use two different value sets for the company and intercompany segment because segment value security
rules are at the value set level.

C. Define the company segment only and qualify it as both the primary balancing segment and
intercompany segment.

D. Define two different charts of accounts.

Answer: C

Question #:46

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 do you need to enable?

A. Drill Through In Grid Properties

B. Nothing. All report balances are drillable in all FR Studio reports.

C. Allow Expansion

D. Report Functions

Answer: C

19 of 33
 Oracle - 1z0-1004

Question #:47

Your customer requires physical invoice to be generated in payables Cloud and Receivables Cloud for the
intercompany payables and receivable transactions.

Which two statements are correct with regards to selling this up?

A. You only need to assign the Legal Entity and Organization Contact.

B. You can only associate one Intercompany Organization per legal Entity.

C. You must have implemented Payables Cloud and Receivables Cloud.

D. You must assign the corresponding Receivables and Payables Business Units.

Answer: A D

Question #:48

Before implementing Financials Cloud, your customer used to manually reconcile their intercompany payables
and receivables accounts.

What is a more automated approach to do this?

A. Run the BI Publisher reports called Intercompany Transaction Summary and Account Details to
automatically reconcile intercompany balances.

B. Create a query using Oracle Transactional Business Intelligence (OTBI) that will match the
intercompany payables and receivables balances.

C. Run the Intercompany Reconciliation report, which shows pairs of intercompany receivables and
payables accounts that are out of balance.

D. In Financials Cloud, you must manually reconcile your intercompany account balances.

E. Use Oracle Hyperion Close Manager to automatically reconcile intercompany account balances.

Answer: B

Question #:49

Account combinations can be created and/or modified using the Import Account Combinations File-based data
import (FBDI). Which represents the appropriate upload steps?

A. Submit the Import Account Combinations process, then insert rows into the
GL_MULTl_COMBlNATIONS_INT table using the FBDI template.

B.

20 of 33
 Oracle - 1z0-1004

B. Insert rows into the GL_BULK_COMB! NAT IONS _1NT table using the FBDI template and then
submit the Import Account Combinations process.

C. Insert rows into the GL_MULTI_COMBINATIONS_INT table using the FBDI template and then
-submit the Import Account Combinations process.

D. Submit the Import Account Combinations process, then insert rows into the
GL_BULK_COMBIfJAT10NS_lNT table using the FBOI template.

Answer: D

Question #:50

You defined a tree or hierarchy, but you are unable to set its status to Active.

What is the reason?

A. Chart of accounts was not deployed.

B. Accounting Configuration was not submitted.

C. An Audit process needs to be successfully performed before a tree version can be set to Active.

D. Two tree versions were not defined

Answer: D

Question #:51

Your customer has a large number of legal entities. The legal entity values are defined in the company
segment which represents the primary balancing segment. They want to easily create eliminating entries for
the intercompany activity.

What should you recommend?

A. Define an intercompany segment in the chart of accounts. The Intercompany module and the
intercompany balancing feature in general ledger and subledger accounting will automatically populate
the intercompany segment with the balancing segment value of the legal entity with which you are
trading.

B. There is no need to define an intercompany segment. You can track the Intercompany trading partner
using distinct intercompany receivable/payable natural accounts to identify the trading partner.

C. Define an intercompany segment and qualify it as the second balancing segment to make sure all entries
are balanced for the primary balancing segment and intercompany segment.

D. There is no need to define an intercompany segment, the Intercompany module keeps track of the
trading partners for you based on the Intercompany rules you define.

21 of 33
 Oracle - 1z0-1004

Answer: B

Question #:52

You are implementing a multipillar implementation of both HCM Cloud and ERP Cloud. You are
implementing ERP first followed by HCM Cloud. You want to ensure your ledgers and chart of accounts are
correctly defined.

What should you do? (Choose three)

A. Use file-based spreadsheet loaders using UCM to mass load and maintain chart of accounts segment
values and hierarchies.

B. Use the Rapid Implementation spreadsheet when creating your enterprise structure.

C. Use HCM’s Enterprise Structure Configurator (ESC) first.

D. Deploy your chart of accounts.

E. Create your chart of accounts in the following order: value sets, COA structure, and instance before
assigning values to the value sets.

Answer: B C D

Question #:53

Identify three differences between Oracle Transactional Business Intelligence (OTBI) and Oracle Business
Intelligence Applications (OBIA).

A. Cloud customers can use both OTBI and OBIA.

B. OTBI allows you to create custom reports from real-time transactional data against the database directly

C. OBIA works for multiple sources including E-Business Suite, PeopleSoft, JD Edwards, SAP, and Fusion
Applications.

D. OBIA is based on the universal data warehouse design with different prebuilt adapters that can connect
to various source application

E. Both OBIA and OTBI provide a set of predefined reports and dashboards and a library of metrics that
help to measure business performance

Answer: B C D

Explanation
https://blogs.oracle.com/dylanwan/otbi-vs-obia

22 of 33
 Oracle - 1z0-1004

Question #:54

You want to define an allocation rule where segment values arc constants (or rules and formulas. What should
you do?

A. Never use the Outer Point of View (POV).

B. Always use the Outer Point of View (POV).

C. Specify Run Time Prompts (RTP).

D. Only specify segment values in formulas.

Answer: B

Question #:55

What are the two benefits of having the Essbase cube embedded in General Ledger Cloud? (Choose two.)

A. General ledger balances are multidimensional, allowing you to perform robust reporting and analysis.

B. You can access real-time results for reporting and analysis because every time a transaction is posted in
General Ledger, multidimensional balances are also updated simultaneously.

C. You no longer need to create and maintain hierarchies because the Essbase cubes are created when you
create your chart of accounts.

D. Posting performance is much faster.

E. Integrating with third-party systems is easier because the Essbase cube provides chart of accounts
mapping rules.

Answer: B D

Question #:56

You want to enter budget date In General Ledger Cloud. Which method is not supported?

A. entering budget Journals

B. Application Development Framework Desktop Integration (ADFdi)

C. Direct budget balance updates from a Financial Stement in smart View

D. file-based Data Import

Answer: A

Explanation

23 of 33
 Oracle - 1z0-1004

http://docs.oracle.com/cd/E28271_01/fusionapps.1111/e20384/glossary.htm

Question #:57

You need to define multiple allocation rules as efficiently as possible. Which three components can be reused
across allocation rules?

A. Point of View (POV)

B. Formulas

C. Run Time Prompts (RTP)

D. RuleSets

Answer: A C D

Explanation
Allocation Manager: Overview

The Allocation Manager creates, validates, deploys, and administers sophisticated allocation rules. In the
Allocation Manager:

Base formulas on multiple criteria, such as account balances or statistical amounts, to allocate shared revenue
or costs across multiple organizational units.

Use complex computations based on different variables to automatically calculate allocated amounts.

Group journal formulas together and executed sequentially to update account balances step-by-step.

There are three types of objects that can be created in Allocation Manager:

Components: Contain formulas, points of view, or allocation objects.

Rules: Contain components such as points of view, formulas, and templates, which are used to create
allocation calculations.

Rule Sets: Contain sets of rules that can be calculated sequentially

NoteThe following are limitation in Oracle Fusion General Ledger.

Allocation rules cannot be shared across rule sets in Allocation Manager.

Within a rule or rule set, the same target or offset cannot be written to by multiple rule components.

When generating allocation rules with run time prompts other than the User Point of View in an allocation rule
component, an error occurs.

24 of 33
 Oracle - 1z0-1004

https://docs.oracle.com/cd/E37017_01/fusionapps.1115/e20374/F494861AN1D1EE.htm

Question #:58

You need to create a month-end reporting package for an upcoming Audit Committee meeting, you have 10
financial reports that you want to share with executives and auditors that are nicely formatted.

Identify the two Oracle recommended ways to accomplish this? (Choose two.)

A. Using Workspace, assemble multiple reports into a book that can be printed and viewed individually as
an entire book.

B. Use a report batch to run reports at a specific time to create a set of snapshot reports.

C. Use OTBI to create multiple reports that you save to a folder that only the users can access.

D. Use BI Publisher to configure the reports and then use bursting to email the reports to the executives and
Audit Committee.

E. Create a Smartview report, where the various sheets represent the different Financial Statement and send
them the spreadsheet.

Answer: A B

Question #:59

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?

A. Smart View

B. Financial Reports with Embedded charts

C. Account Monitor

D. Account Inspector and its charts

Answer: A

Question #:60

How can your Accounting Manager expedite journal processing during the time-critical month-end close?

A. by using the Close Status monitor to drill down on the close status across ledgers

B.

25 of 33
 Oracle - 1z0-1004

B. by using the Journals region to view journals Requiring Attention, Requiring Approval, and Pending
Approval from Others

C. by running the Journals report using Business Intelligence Publisher

D. by creating an ad hoc query on journals using Oracle Transactional Business Intelligence (OTBI)

Answer: C

Question #:61

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 two statements are correct? (Choose two.)

A. You must define rules for every combination of specific categories and sources. Otherwise, the
intercompany balancing will not work.

B. You can create a rule for all sources and categories by selecting the source "Other" and the category
"Other."

C. If you choose to have rules at various levels, then intercompany balancing evaluates the rules in this
order: Ledger, Legal Entity, chart of accounts, and primary balancing segment value.

D. Set up a chart of accounts rule for every chart of accounts structure you have in order to ensure that
Intercompany Balancing will always find a rule to use to generate balancing accounts.

Answer: A C

Question #:62

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?

A. Use the General Ledger's Calculation Manager to define an allocation definition to eliminate entries that
you can generate every period.

B. Use the spreadsheet template that is accessed from the "Create Journal in Spreadsheet" task and import
the spreadsheet with the eliminating entries every period.

C. There is no way to automate this process if the customer Is not using Oracle Hyperion Financial Close
Management.

D. Create a manual Journal that includes the eliminating entries, and then create a copy of the Journal batch

26 of 33
 Oracle - 1z0-1004
D.
every period.

Answer: C

Question #:63

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

A. When the purchase order is set to accrue at receipt and partially received, then canceled or finally
closed, encumbrance goes back to the budget to the extent of the unreceived amount.

B. When the requisition is set to accrue at period end and partially billed and then canceled or finally
closed, encumbrance goes back to the budget to the extent of the unbilled amount.

C. The requisition reserved successfully undergoes amendment and is rejected in the reapproval.

D. The purchase order is canceled or finally closed or rejected without performing any receipt or invoice.

Answer: A D

Question #:64

Management wants to use the budget transfer function available on the Review Budgetary control dances.
Which privilege is required to perform the budget transfer?

A. Import Budget Amount from Spreadsheet

B. Import Budget Amounts (XCC_IMPORT_B0DGET_AMOUNTS_PRIV)

C. Manage Control Budgets (XCC_HANAGI _CONIROL_BUDGtTrs.PRIV)

D. Budget Loading (XCC_BUDGET_LOADING_DUiXPR!V)

Answer: A

Question #:65

How do Cross Validation Rules (CVRs) handle existing violations in the Code Combinations Identification
(CCID) table?

A. CVRs are assigned to the end user role; therefore controlling what account code combination individuals
can leverage in the General Ledger and the subledgers.

B. If CVR determines that an invalid combination exists in the CCID table, it will automatically disable
that account code combination.

C.

27 of 33
 Oracle - 1z0-1004

C. CVR only test new account combinations being inserted into the table. They ignore any invalid account
combinations already existing in the table.

D. Nothing has changed. If you have an invalid account combination existing in the table, you must
deactivate it to prevent further usage.

Answer: C

Question #:66

Which two statements are true regarding how Intercompany Balancing Rule, are defined? (Choose two.)

A. All ledgers engaged in an intercompany transaction must share the same chart: of accounts in order to
define balancing rules

B. You can only define balancing rules for different journals' sources. You cannot define balancing rules
for different journal categories.

C. You can define different balancing rules for different combinations of journal sources, journal
categories, and transaction types

D. You can define different rules for different charts of accounts, ledgers, legal entities, and primary
balancing segment value.

Answer: A D

Question #:67

Which tool can you use to create a Financial Income Statement?

A. Rapid Implementation Enterprise Structures setup

B. PS/nVision

C. Account Inspector

D. One View Reporting

Answer: C

Question #:68

The expense account of airfare was erroneously assigned to the account type “Liability.”

Which method should you choose to fix the problem?

A. Run the “Update Balance Cube Chart of the Accounting Dimension” program.

B.

28 of 33
 Oracle - 1z0-1004

B. Run the “Correct Misclassified Account” program.

C. Deactivate the value.

D. Run the “Segment Value Inheritance” program.

Answer: B

Question #:69

The Delete Translated Balances process provides the ability to completely reset translations in the event that
significant changes are made to the accounting configuration.

Once the deletion process completes, what additional process must you run?

A. Submit the Create Scenario Dimension Members process to ensure that the balances cube maintains
translated balances that are consistent with future translations.

B. Submit the Update General Ledger Balances Cube process to ensure that the balances cube maintains
translated balances that are consistent with future translations.

C. Submit the Create General Ledger Balances Cube process to ensure that the balances cube maintains
translated balances that are consistent with future translations.

D. Submit the Create Currency Dimension Members process to ensure that the balances cube maintains
translated balances that are consistent with future translations.

Answer: C

Question #:70

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 a segment that acts as the primary balancing segment and create values that represent a
concatenation of all three business dimensions.

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 two segments where the first segment represents the concatenation of Company and Line of
Business, and then enable secondary tracking for the Product Segment.

Answer: C

29 of 33
 Oracle - 1z0-1004

Explanation
http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e20374/F484498AN122F4.htm

Question #:71

Your customer has three legal entities, 50 departments, and 10,000 natural accounts. They use intercompany
entries.

What is Oracle's recommended best practice when implementing; a new chart of accounts? How many
segments and what segment qualifiers should be used?

A. Define three segments for the company, department, and natural account. The qualifiers shouldbe
primary balancing segment, cost center segment, and natural account segment, respectively

B. Define four segments for the company, department, natur.il account, and intercompany segment. The
qualifiers should be primary balancing segment, cost center segment, natural account segment, and
intercompany segment, respectively.

C. 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.

D. Define three segments tor the company, department, and natural account. The qualifiers for the first
segment should be primary balancing segment and intercompany segment, cost center segment, and
natural account segment, respectively.

Answer: C

Question #:72

Which subject area has been enhanced to allow you to drill down from OTBI General Report to a General
journal?

A. General Ledger - Journal Transaction Balances Real Time

B. General Ledger - Journal Balances Real Time

C. General Ledger - Summary Journals Real Time

D. General Ledger - Journals Real Time

Answer: D

Explanation
The action link framework in Oracle Business Intelligence Enterprise Edition (OBIEE) allows you to click on
an object and navigate directly to the source application. Using this framework, OTBI for Financials provides

30 of 33
 Oracle - 1z0-1004

the capability to drill from an OTBI ad hoc report based on OTBI General Ledger – Journals Real Time
subject area to journals details in Oracle Fusion General Ledger Cloud. Links can be configured in the ad hoc
GL OTBI reports to drill down to the Edit Journal screen.

Question #:73

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

A. revaluations and translation to revalue and translate currencies stored in the Essbase cube

B. calculation manager to perform allocations based on multidimensional balances and budgets

C. period closing and opening of ledgers to keep General Ledger cloud and the Essbase cubes in sync

D. journal entries and Journal approval to create Journals that update balances to the cube directly

Answer: A

Question #:74

You create an invoice for USD 100 that is matched to a purchase order of USD 100. You validate the invoice
to consume the budget and reduce funds available. And then later, you cancel the invoice.

What happens to funds available when you cancel an invoice that requires budgetary control?

A. The budget will increase by USD 100 and the funds available will decrease by USD 100.

B. Funds available will change when the invoice is approved.

C. The funds reserved for the purchase order is reinstated while the invoice expenditure is reversed by USD
100.

D. The budget and funds available will increase by USD 100.

Answer: D

Question #:75

You entered a journal and the client is asking for the following information:

The current account balance

What the future account balance will be if the Journal is approved and posted

How will you get this information?

A. View the Projected Balances region in the Create Journals page.

B.

31 of 33
 Oracle - 1z0-1004

B. Run a Trial Balance before and after posting.

C. Use Oracle Transactional Business Intelligence (OTBI) to query General Ledger balances.

D. Query the account balance online.

Answer: C

Question #:76

You are implementing Segment Value Security rules. Which two statements are true?

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.

C. When you enable or disable Segment Value Security, you do not need to redeploy your chart or
accounts.

D. The Segment Value Security rules do not take effect until you assign the rules to users and products.

Answer: B C

Explanation
https://docs.oracle.com/cloud/farel8/financialscs_gs/FACSF/F1004387AN145CC.htm

Question #:77

Your customer wants to have balance sheets and income statements for their cost center and program
segments. That is, the customer wants to have three balancing segments.

Which two recommendations would you give your customer? (Choose two.)

A. When entering journals manually, the customer will need to make sure that the debits and credits are
equal across all balancing segments because the system will not automatically balance the journal.

B. Every journal where debits do not equal credits across the three balancing segments will result in the
System generating extra journal lines to balance the entry.

C. Additional intercompany rules will need to be defined for the two additional balancing segments.

D. Define Ledger balancing options to balance by second and third balancing segments.

Answer: A D

Question #:78

32 of 33
 Oracle - 1z0-1004

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. As there are cancellations for $400 USD, the system will partially reserve the funds in September 2016
and fully reserve it in October 2016.

E. Purchase order encumbrance will be released for $2,100 USD.

Answer: C D

33 of 33