Free 1Z0-1054-25 Practice Test Questions and Answers (2026) Practice Questions

:

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. Reference:

Modify Journal Approval Notifications with Analytics Publisher

[Creating Analytics and Reports for Financials Cloud]

:

According to Oracle documentation2, your users can personalize the Springboards and Work Areas to

suit their individual working styles in these two ways: They can format certain tables by hiding and

showing columns, moving columns, and resizing columns, and they can use “+” under the Apps

section of the News Feed homepage. Springboards and Work Areas are user interface components

that enable users to access tasks and information relevant to their roles. Users can customize these

components by adding or removing tiles, changing layouts, filtering data, and formatting tables.

Therefore, options A and D are correct. Option B is incorrect because users have more control over

configuring their Springboards and Work Areas than just resizing columns. Option C is incorrect

because users do not need to have the System Administrator configuring pages for them using Page

Composer.

According to the Oracle documentation12, the Intercompany Reconciliation Report can be run using

an additional currency and conversion rate that converts all amounts into a common currency for

comparison (option C). The report also includes ledger balancing lines generated when the primary

balancing segment value is in balance, but either the second or third balancing segment values are

not (option B). Option A is incorrect because you can drill down to the general ledger journal,

subledger accounting entry, and source receivables or payables transaction2. Option D is incorrect

because the report displays the intercompany receivables and intercompany payables balances in

summary for a period, and any differences between them1. Option E is incorrect because the report

does not display clearing company balancing lines2.

Balances cubes are multidimensional databases that store financial balances for interactive reporting

and analysis. A balances cube is created for each unique combination of ledger and currency, and it

contains dimensions such as chart of accounts segments, periods, scenarios, and other user-defined

attributes. New dimensions can be added to a balances cube by using the Manage Balances Cube

Dimensions task in General Ledger. Balances cubes are updated automatically when journals are

posted in General Ledger, and they can also be refreshed manually by using the Refresh Balances

Cube task. Balances cubes are not affected by the Translation or Revaluation processes, as these

processes only update the balances tables in General Ledger. Reference:

Overview of Oracle General Ledger Balances Cubes1

Considerations for General Ledger Balances Cubes2

Overview of Oracle Essbase Balances Cubes3

The three labels that are required when designing the chart of account structure for this project are

Primary Balancing, Cost center, and Natural Account. A chart of account structure is composed of

segments that represent different dimensions of accounting information, such as company,

department, account, or project. Each segment has a label that indicates its function or purpose

within the chart of accounts. The Primary Balancing label is required for the segment that identifies

the legal entity or business unit for which financial statements are prepared and balanced. The Cost

center label is required for the segment that identifies the organizational unit or function that incurs

expenses or generates revenues. The Natural Account label is required for the segment that

identifies the nature of an account, such as asset, liability, revenue, or expense. The Intercompany

Segment label is not required when designing the chart of account structure for this project, as this is

an optional label for the segment that identifies intercompany transactions between different legal

entities or business units within the same enterprise. The Secondary Balancing label is not required

when designing the chart of account structure for this project, as this is an optional label for the

segment that identifies an additional balancing dimension other than the primary balancing

segment, such as fund or region. Reference: Oracle Financials Cloud: General Ledger 2022

Implementation Professional Objectives - Define Chart of Accounts 12

According to the Oracle documentation34, account hierarchies are defined in Oracle Fusion

applications using tree functionality. Each account hierarchy is defined as a tree with one or more

versions. You can have only one version of a hierarchy published to the Essbase cube at any time

(option A). Child values in these hierarchies can belong to only one parent (option D). Option B is

incorrect because hierarchies for reporting and allocations must be published to Essbase cubes5.

Option C is incorrect because it contradicts option B.

The two valid Data Access Set types are Full access and Read Only access. A Data Access Set is a

security feature that defines the access level that users have to ledger data, such as balances,

budgets, or journals. A Data Access Set type is an attribute that determines the type of access that

users have to ledger data within a Data Access Set. The two valid Data Access Set types are Full

access and Read Only access. Full access allows users to view and enter data for ledger data within a

Data Access Set. Read Only access allows users to view but not enter data for ledger data within a

Data Access Set. Full Ledger is not a valid Data Access Set type, but an option that determines

whether a Data Access Set grants access to all balancing segment values in a ledger or only specific

balancing segment values. Primary Balancing Segment Value is not a valid Data Access Set type, but

an attribute that identifies the legal entity or business unit for which financial statements are

prepared and balanced. Read and Write access is not a valid Data Access Set type, but an alternative

term for Full access. Reference: Oracle Financials Cloud: General Ledger 2022 Implementation

Professional Objectives - Define Ledgers 12

The two options that allow access to the BI Catalog for creating an Oracle Transactional Business

Intelligence analysis are Reports and Analytics and Enterprise Performance Management Workspace.

Reports and Analytics is a tool that allows users to access, create, edit, and share reports and

analyses using data from various sources, including Oracle Transactional Business Intelligence. Users

can access Reports and Analytics from various pages in Oracle Fusion Applications or from Oracle

Fusion Cloud Service Console. Enterprise Performance Management Workspace is a tool that allows

users to access, create, edit, and share reports and analyses using data from various sources,

including Oracle Transactional Business Intelligence. Users can access Enterprise Performance

Management Workspace from Oracle Fusion Cloud Service Console or from a web browser. Universal

Content Management Workspace is not an option that allows access to the BI Catalog for creating an

Oracle Transactional Business Intelligence analysis, as this is a tool that allows users to manage

documents and other digital content in Oracle Fusion Applications. Business Process Management

Workspace is not an option that allows access to the BI Catalog for creating an Oracle Transactional

Business Intelligence analysis, as this is a tool that allows users to monitor and manage business

processes in Oracle Fusion Applications. Scheduled Processes is not an option that allows access to

the BI Catalog for creating an Oracle Transactional Business Intelligence analysis, as this is a tool that

allows users to submit, monitor, and manage scheduled processes in Oracle Fusion

Applications. Reference: Oracle Financials Cloud: General Ledger 2022 Implementation Professional

Objectives - Use Oracle Transactional Business Intelligence (OTBI) 12

You should define the default intercompany balancing rule at the legal entity level, because each

ledger has one legal entity assigned to it and each legal entity is associated with one balancing

segment value. This way, you can specify the intercompany receivables and payables accounts for

each legal entity and ensure that the journals are balanced by legal entity or primary balancing

segment values. A ledger-level rule would apply to all legal entities in the ledger, which may not be

appropriate if they have different intercompany accounts. A primary balancing segment rule would

apply to all ledgers that share the same chart of accounts, which may not be desirable if they have

different intercompany rules. A chart of accounts rule would apply to all ledgers and legal entities

that use the same chart of accounts, which may not be feasible if they have different intercompany

segments or accounts. Reference:

Intercompany Balancing Rules, Section: Define Intercompany Balancing Rules

Overview of Intercompany Balancing Rules, Section: Define Intercompany Balancing Rules

Troubleshooting Guide For Intercompany Balancing, Section: 1. Journals and subledger accounting

entries are not being balanced for intercompany activity

Implement General Ledger, Section: Intercompany Balancing

Data access sets are collections of ledgers that define the data security for users who access General

Ledger. Users can only access the ledgers that are assigned to them through data access sets. To

allow users with the General Accountant job role to access the UK Ledger, you need to create a data

access set that includes the UK Ledger and assign it to the user/role combination. You also need to

specify the access privilege for the data access set, which can be Full Ledger, Both Read and Write, or

Read Only. In this case, you need to select Both Read and Write to allow read/write access to the full

ledger. Reference:

Implement General Ledger

GL_ACCESS_SET_LEDGERS

The Default Data Access Set

Overview of General Ledger Security

The two true statements for the resulting revaluation run are that you have an unrealized exchange

gain recorded and you have an unrealized exchange loss recorded. Revaluation is a process that

adjusts foreign currency balances to reflect current exchange rates at period end. Revaluation creates

journal entries to record unrealized exchange gains or losses on foreign currency balances based on

revaluation rates defined for each currency. In this scenario, you have a balance on the Accounts

Payable Liability Account of 100,000 Euros which is equivalent to USD 136,550 at month end. The

month end exchange rate for revaluation is 1 Euro = 1.3755 USD. Therefore, after revaluation, your

balance on the Accounts Payable Liability Account will be USD 137,550 (100,000 x 1.3755). This

means you have an unrealized exchange gain of USD 1,000 (137,550 - 136,550) on your Accounts

Payable Liability Account because your liability in foreign currency has decreased in terms of your

ledger currency due to exchange rate fluctuations. Revaluation will create a journal entry to debit

your Accounts Payable Liability Account by USD 1,000 and credit your Unrealized Exchange Gain

Account by USD 1,000 to record this gain. The original journal entry in Euros is not updated by

revaluation, as revaluation only creates new journal entries to adjust foreign currency balances in

terms of ledger currency based on revaluation rates. There is no unrealized exchange gain or loss

calculated by revaluation, as revaluation does calculate unrealized exchange gains or losses on

foreign currency balances based on revaluation rates.

The source is where you specify the amount to be allocated. You can use various sources, such as

account balances, fixed amounts, or statistical balances. In this case, you want to use the statistical

balance of the floor area as the source of the allocation. The basis is where you specify the driver or

factor that determines how the source amount is distributed among the targets. The target is where

you specify the destination accounts that receive the allocated amount. The offset is where you

specify the account that records the opposite side of the allocation entry. The allocation range is

where you specify the scope of the allocation, such as the ledger, balancing segment, or legal

entity. Reference:

Oracle Financials Cloud Implementing Enterprise Structures and General Ledger, Chapter 3:

Allocations and Periodic Entries, Allocation Components

Oracle Financials Cloud Using General Ledger, Chapter 3: Allocations and Periodic Entries, Overview

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 (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 style template, as this is a file that defines the styles and formatting of the notification

elements, such as fonts, colors, or margins. 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

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 (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

When integrating with Oracle Hyperion Financial Management, you can use the following

dimensions for consolidation: Entity, Scenario, Year, Period, Value, Account, Intercompany, Custom1

to Custom4, and View. You can map one to one, or concatenate segments from your source General

Ledger to a single Hyperion Financial Management dimension. For example, you can map Company

to Entity, Department to Department, and Account to Account. However, if you have segments in

your source General Ledger that cannot be mapped to any Hyperion Financial Management

dimension, such as Program, then the data is summarized across those segments. This means that

the data is aggregated to the highest level of the unmapped segments, and the detail information is

lost. For example, if you have Program as a segment in your source General Ledger, and you do not

map it to any Hyperion Financial Management dimension, then the data is summarized by Program,

and you cannot see the data by individual Program values in Hyperion Financial

Management. Reference:

Example of Mapping Segments to Financial Management Dimensions

Overview of the Chart of Accounts Mapping Page

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.

According to Oracle documentation3, you can opt out of the period close checking feature for these

three subledgers by using the lookup ORA_GL_INCLD_STRICT_PRD_CLOSE: Receipt accounting,

Receivables, and Assets. The period close checking feature prevents you from closing a General

Ledger period if there are any open subledger periods that exist for that ledger. You can opt out of

this feature for specific subledgers by using the lookup ORA_GL_INCLD_STRICT_PRD_CLOSE and

setting the Enabled flag to No for those subledgers. Therefore, options A, B, and D are correct. Option

C is incorrect because Revenue Management is not a subledger that can be opted out of the period

close checking feature. Option E is incorrect because Order Management is not a subledger that can

be opted out of the period close checking feature.

Query Designer is a Smart View tool that enables you to create and modify ad hoc queries on

General Ledger balances cubes. You can use Query Designer to select the dimensions, members, and

filters that you want to include in your query, and then retrieve the data in a grid format in Excel. You

can also save, open, and refresh your queries as needed. Query Designer is the best tool for

producing an income statement on a regular basis using Smart View, because it allows you to easily

access and analyze the income and expense accounts, as well as the ledger, period, currency, and

other dimensions that are relevant for your report. You can also customize the layout and format of

your grid, and use Excel functions and features to enhance your report. Reference:

Overview of Smart View

Creating an Ad Hoc Analysis in Smart View