0% found this document useful (0 votes)
2K views10 pages

Oracle: Question & Answers

The document contains a series of questions and answers related to the Oracle Financials Cloud: General Ledger 2025 Implementation Professional - Delta certification exam. It includes multiple-choice questions covering various topics such as journal approval notifications, chart of accounts mapping, budgetary control, and intercompany reconciliation reports. The document outlines the correct answers and explanations for each question, providing insights into the implementation and configuration of Oracle Financials Cloud functionalities.

Uploaded by

Venkataraman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
2K views10 pages

Oracle: Question & Answers

The document contains a series of questions and answers related to the Oracle Financials Cloud: General Ledger 2025 Implementation Professional - Delta certification exam. It includes multiple-choice questions covering various topics such as journal approval notifications, chart of accounts mapping, budgetary control, and intercompany reconciliation reports. The document outlines the correct answers and explanations for each question, providing insights into the implementation and configuration of Oracle Financials Cloud functionalities.

Uploaded by

Venkataraman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 10

Oracle

1D0-1054-25-D
Oracle Financials Cloud: General Ledger 2025
Implementation Professional - Delta
QUESTION & ANSWERS

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
Topics Number of Questions
Topic 1 : Multiple Choice Questions 78
Topic 2 : Hands-on Performance Based 3
Mix Questions (Others) : 0
Mix Questions (Others) : 0
Mix Questions : 89
Total 170

Topic 1
Case Study: Topic 1

Title : Multiple Choice Questions

QUESTION: 1 Topic 1 Multiple Choice Questions

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?

Option A : Sub template

Option B : Style template

Option C : Layout template

Option D : Output type

Option E : Data model

Correct Answer: C,E

Explanation/Reference:

To modify the journal approval notification, you need to copy (or customize) and edit the layout template and the data model

of the Analytics Publisher report. The layout template defines the appearance and content of the notification, such as the text,

fields, tables, and images. The data model defines the data sources and queries that provide the data for the notification, such

as the journal attributes, amounts, and statuses. You can use Template Builder for Word to edit the layout template and

Analytics Publisher to edit the data model. You also need to download the Workflow Notification Subtemplate, which is a

common subtemplate that contains the header and footer of the notification. You can preview the modified notification using

the subtemplate and the data model. References: Modify Journal Approval Notifications with Analytics Publisher [Creating

Analytics and Reports for Financials Cloud]

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
QUESTION: 2 Topic 1 Multiple Choice Questions

Your customer has a number of Chart of Account Mapping Rules for their Primary and Secondary ledgers. You
decide to use the FBDI template to load the rules. Which two statements are true when using this method of
entry? (Choose two.)

Option A : You can download the template only from the Manage Chart of Accounts Mappings page.

Option B : It supports external integration using REST services.

Option C : You can create, update, and delete account rules for a chart of accounts mapping.

Option D : You can create, update, and delete segment rules for a chart of accounts mapping.

Correct Answer: C,D

Explanation/Reference:

According to Oracle documentation3, when using FBDI template to load Chart of Account Mapping Rules for their Primary and

Secondary ledgers, you can create, update, and delete account rules for a chart of accounts mapping, and you can create,

update, and delete segment rules for a chart of accounts mapping. FBDI enables you to import chart of accounts mapping rules

from a spreadsheet template into General Ledger. You can use FBDI to manage both account rules and segment rules for a

chart of accounts mapping. Therefore, options C and Dare correct. Option A is incorrect because you can download the

template from other pages besides the Manage Chart of Accounts Mappings page. Option B is incorrect because FBDI does not

support external integration using REST services.

QUESTION: 3 Topic 1 Multiple Choice Questions

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

Option A : No change
Option B : Purchase order encumbrance will be released for $2,100 USD
Option C : Funds reservation only happens for non-matched invoices, so the system will not reserve
funds
Option 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
Option E : 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

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
Correct Answer: B,D

QUESTION: 4 Topic 1 Multiple Choice Questions

You are implementing Financials Cloud and are using spread sheets to load Legal Entities, Business Units,
and Account Hierarchies. Which three setup object scan be loaded via a spread sheet from Functional Setup
Manager?

Option A : Complete Accounting Configuration


Option B : Suppliers and Customers
Option C : Banks, Bank Accounts, and Branches
Option D : Setup data for Receivables and Payables product.
Option E : Chart of account values, accounting calendar, and ledger

Correct Answer: B,C,E

QUESTION: 5 Topic 1 Multiple Choice Questions

The Cloud Client wants to add a global branding logo and more predefined transactional attributes to the
journal approval email notification. Which two Business Intelligence catalog objects should you copy (or
customize) and edit? (Choose two.)

Option A : Output type

Option B : The layout-Template

Option C : The Data Model

Option D : The Data Source

Option E : The Sub_Template

Correct Answer: B,C

Explanation/Reference:

To add a global branding logo and more predefined transactional attributes to the journal approval email notification, you

should copy (or customize) and edit the layout template and the data model. The layout template is a file that defines the

appearance and content of the notification, such as text, images, tables, or charts. The data model is a file that defines the

data sources and queries that provide data for the notification, such as predefined transactional attributes. You can copy (or

customize) and edit the layout template and the data model using Oracle Analytics Publisher reports. You do not need to copy

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
(or customize) and edit the output type, as this is a setting that determines the format of the notification output, such as HTML

or PDF. You do not need to copy (or customize) and edit the data source, as this is a component of the data model that

specifies where data for the notification comes from, such as an SQL query or an XML file. You do not need to copy (or

customize) and edit the sub template, as this is a file that contains reusable content or logic that can be referenced by multiple

layout templates. Reference: Oracle Financials Cloud: General Ledger 2022 Implementation Professional Objectives - Configure

Workflow Approvals and Notifications 12

QUESTION: 6 Topic 1 Multiple Choice Questions

You have redesigned your chart of accounts and need to update your existing cross-validation rules. There is
a requirement for new rules; some simply need to be updated and others need to be deleted. What is the
most efficient way to achieve this?

Option A : by using the Manage General Ledger Security page.

Option B : by creating Cross-Validation Rules desktop-integrated spreadsheet.

Option C : by using Cross-Validation Rules Import file-based data import (FBDI).

Option D : by using the Manage Cross-Validation Rules page.

Correct Answer: C

Explanation/Reference:

According to Oracle documentation1, the most efficient way to update your existing cross-validation rules when you have

redesigned your chart of accounts is to use Cross-Validation Rules Import file-based data import (FBDI). FBDI enables you to

import cross-validation rules from a spreadsheet template into General Ledger. You can use FBDI to create new rules, update

existing rules, or delete rules. Therefore, option C is correct. Option A is incorrect because using the Manage General Ledger

Security page does not enable you to update cross-validation rules. Option B is incorrect because creating Cross-Validation

Rules desktop-integrated spreadsheet does not enable you to update cross-validation rules. Option D is incorrect because

using the Manage Cross-Validation Rules page does not enable you to update cross-validation rules efficiently. According to

Oracle documentation2, you should create a Data Access Set that allows access to the UK Ledger to allow users with the

General Accountant job role to access the UK Ledger. A Data Access Set is a security feature that defines the ledgers and

balancing segment values that a user can access. You can assign Data Access Sets to users or roles using the Manage Data

Access for Users page. Therefore, option B is correct. Option A is incorrect because assigning the security context value of UK

Ledger to the user/role combination does not enable access to the ledger. Option C is incorrect because assigning the General

Accounting Manager role to those users does not enable access to the ledger. Option D is incorrect because assigning the UK

reference set to the user/role combination does not enable access to the ledger.

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
QUESTION: 7 Topic 1 Multiple Choice Questions

Which two statements are true about the Intercompany Reconciliation report?

Option A :

It includes ledger balancing lines generated when the primary balancing segment value (BSV) is in
balance, but either the second or third BSVs are not.

Option B :

It can be run using an additional currency and conversion rate that converts all amounts into a common
currency for comparison.

Option C : It displays the intercompany receivables and intercompany payables balances in summary for
a period.

Option D :

You can only drill down to the General Ledger journal and then from there to the Subledger journal entry.

Option E : It displays all clearing company balancing lines for a period.

Correct Answer: B,C

Explanation/Reference:

The Intercompany Reconciliation report is a tool that helps you reconcile your intercompany transactions and identify any

discrepancies between the provider and receiver sides. The report shows the entered or transaction amount of the accounting

entries booked to the intercompany receivables and payables accounts for a pair of provider and receiver legal entities. The

accounted amounts may be different when the conversion rates used for the intercompany receivables and payables are

different. Therefore, you can run the report using an additional currency and conversion rate that converts all amounts into a

common currency for comparison. This option helps you manage the currency risk and the conversion rate fluctuations for

intercompany transactions. The report also displays the intercompany receivables and payables balances in summary for a

period, and any differences between them. You can drill down on the links to view the balances by source and then by journal

lines. You have full drill-down capabilities to the general ledger journal, subledger accounting entry, and source receivables or

payables transaction. References: Intercompany Reconciliation Intercompany Reconciliation Reports

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
QUESTION: 8 Topic 1 Multiple Choice Questions

You need to set up a calendar for the year Apr-XX to Mar-YY where YY is the following year, and you would
like the periods to be named according to the year they fall in. What format should you choose?

Option A : Fiscal Year


Option B : Calendar Year
Option C : Period
Option D : Year

Correct Answer: A

Explanation/Reference:

According to Oracle documentation3, when you need to set up a calendar for the year Apr-XX to Mar-YY where YY is the

following year, and you would like the periods to be named according to the year they fall in, you should choose Fiscal Year as

the format. A Fiscal Year format enables you to define periods based on fiscal years that span two calendar years. Therefore,

option A is correct. Option B is incorrect because a Calendar Year format defines periods based on calendar years that start on

January 1st and end on December 31st. Option C is incorrect because a Period format defines periods based on any number of

days or weeks. Option D is incorrect because a Year format defines periods based on calendar years that start on any month

other than January and end on any month other than December.

QUESTION: 9 Topic 1 Multiple Choice Questions

Which two statements are true regarding the Intercompany Reconciliation Report? (Choose two.)

Option A : You can only drill down to the general ledger journal and then from there to the subledger
journal entry.
Option B : This report can be run using an additional currency and conversion rate that converts all
amounts into a common currency for comparison.
Option C : This report displays only the reconciled transactions. You need to further process automatic
reconciliation to reconcile the unreconciled transactions
Option D : This report includes Ledger balancing lines generated when the primary balancing segment
value (BSV) is in balance, but either the second or third BSVs are not
Option E : This report displays the intercompany receivables and intercompany payables balances in
summary for a period.

Correct Answer: A,B

QUESTION: 10 Topic 1 Multiple Choice Questions

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
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?

Option A : OTBI report

Option B : Financial Reporting Web Studio report

Option C : Account group

Option D : Trial Balance report

Correct Answer: B

Explanation/Reference:

To view high-level profit and loss results for each ledger in the Close Monitor, you need to associate a Financial Reporting Web

Studio report with the ledger set. This report should be based on the General Ledger Balances cube and should include the

Income Statement account group as a row dimension. The report should also have the ledger set as a point of view dimension

and the period and currency as user prompts. This way, you can select the ledger set, period, and currency when you run the

report from the Close Monitor and see the aggregated income statement results for each ledger and consolidation node in the

ledger set hierarchy. References: Overview of Close Monitor, Using General Ledger, Close Monitor Issue

QUESTION: 11 Topic 1 Multiple Choice Questions

You have set up a supporting reference with balances to capture revenue by account manager.Which option
should you use to view the supporting reference balances?

Option A : an Account Group


Option B : an OTBI analysis
Option C : a SmartView analysis
Option D : General Ledger inquiries and reports

Correct Answer: B

MIXED Questions

QUESTION: 12

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

Option A : Import the periods from a spreadsheet


Option B : The application automatically populates the next year when you open the first period of a new

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
fiscal year
Option C : Add the periods manually
Option D : Use the Add Year button

Correct Answer: D

QUESTION: 13

You need to create a boardroom ready month-end reporting package for an upcoming Audit
Committeemeeting. You have 10 Financial Reports that you want to share with executives and auditors that
are nicelyformatted.What are the two Oracle recommended ways to accomplish this? (Choose two.)

Option A : Use BI Publisher to configure the reports and then use bursting to email the reports to the
executives and Audit Committee
Option B : Using Workspace, assemble multiple reports into a book that can be printed and viewed
individually as an entire book
Option C : Create a Smartview report, where the various sheets represent the different Financial
Statements and send them the spreadsheet
Option D : Use a report batch to run reports at a specific time to create a set of snapshot reports
Option E : Use OTBI to create multiple reports that you save to a folder that only the users can access

Correct Answer: B,D

QUESTION: 14

Encumbrance accounting is enabled for your ledger. An encumbrance journal dated 3/15/19 was recorded for
apurchase order.The invoice was entered on 5/5/19, but the invoice accounting date was 4/20/19. The
encumbrance journal forliquidating the purchase order encumbrance is dated 5/5/19.What is causing this?

Option A : The actual accounting date was set up under the encumbrance accounting Default Date Rule
Option B : The current transaction accounting date was set up under the encumbrance accounting Default
Date Rule
Option C : The subledger accounting option is set to system date
Option D : The system date was set up under the encumbrance accounting Default Date Rule
Option E : The prior related transaction accounting date was set up under the encumbrance accounting
Default Date Rule

Correct Answer: B

QUESTION: 15

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

Option A : Ensure that the Accounting Calendar and Currency are the same as the Primary Ledger

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html
Option B : Define Journal Conversion Rules that include subledgers in order to transfer subledger
transactions
Option C : Define Journal Conversion Rules that exclude subledgers
Option D : Assign a Subledger Accounting Method to the secondary ledger
Option E : Define Supporting References with balances

Correct Answer: B,D

QUESTION: 16

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

Option A : Create an Account Group using Account Monitor


Option B : Use Account Inspector
Option C : Open a Smart View file saved on your desktop
Option D : Perform an account analysis online

Correct Answer: A

QUESTION: 17

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

Option A : Uncheck the Enable Posting from the Manage Subledger Accounting Options task.
Option B : Journal entry spreadsheets are not impacted by this new function.
Option C :
Must have separate user defined roles using the privilege
XLA_CREATE_GENERAL_LEDGER_AND_SUBLEDGER _JOURNALS.

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

Correct Answer: A,D

https://www.certsexpert.com/1D0-1054-25-D-pdf-questions.html

You might also like