Oracle 1z0-1054-25 Oracle Financials Cloud: General Ledger 2025Implementation Professional Exam Practice Test

The revaluation process is used to adjust account balances denominated in a foreign currency. Revaluation adjustments represent the difference in account balances due to changes in conversion rates between the date of the original journal and the revaluation date. These adjustments are posted through journal entries to the underlying account with the offset posted to an unrealized gain or loss account. The two statements that are true about the resulting revaluation run are:

You have an unrealized exchange loss recorded: Since the ledger currency (USD) has depreciated against the foreign currency (Euro) from the date of the original journal to the revaluation date, the account balance in USD has increased. This means that you have a loss on the

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.

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 balancing an intercompany journal, Oracle Fusion Cloud will first look for a primary balancing segment rule that matches the provider and receiver primary balancing segment values. If such a rule exists, it will be used to generate the intercompany receivables and payables accounts. If not, Oracle Fusion Cloud will look for a chart of accounts rule, then a legal entity-level rule, and finally a ledger-level rule. The primary balancing segment rule has the highest priority and the ledger-level rule has the lowest priority. References:

Overview of Intercompany Balancing Rules

Intercompany Balancing Rules

Troubleshooting Guide For Intercompany Balancing

Example of Generating Intercompany Receivables and Intercompany Payables Accounts

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

Overview of Oracle General Ledger Balances Cubes1

Considerations for General Ledger Balances Cubes2

Overview of Oracle Essbase Balances Cubes3

You can prevent the closure of a General Ledger accounting period if the accounting period for any of the corresponding subledgers is still open, or if incomplete accounting entries or transactions exist for the period. This can help ensure an effective period close process that validates all transactions are complete and aren’t held up during the close. To enable this feature, you need to set the relevant option on the Specify Ledger Options page for each primary ledger. The option is called Prevent General Ledger Period Closure When Open Subledger Periods Exist and it is located in the Period Close section. You can also specify which subledgers to include or exclude from the validation, except for Assets, which is automatically excluded by default. References:

How to Prevent a General Ledger Period from Closing When Open Subledger Periods Exist

Period Close Components

Review: Prevent General Ledger Period Closure When Open Subledger Periods Exist

The adjustment only level is the data conversion level that ensures only manual journals will be entered in the secondary ledger. This level means that no data is copied from the primary ledger to the secondary ledger automatically. Instead, the user can enter manual adjustments in the secondary ledger to reflect the differences between the two accounting standards. This level is suitable for scenarios where the accounting methods or charts of accounts are very close between the primary and secondary ledgers, and there is no need to maintain detailed journals or subledger transactions in the secondary ledger. References: Primary Ledgers, Secondary Ledgers, and Reporting Currencies, High Volume Data Migration Considerations for General Ledger, Reporting Currencies - Conversion Level Balance

Here are the steps you need to follow:

In the Setup and Maintenance work area, go to the following:

Offering: Financials

Functional Area: Financial Reporting Structures

Task: Manage Shorthand Aliases

Select the chart of accounts that you want to create the alias for. In this case, it is the Corporate chart of accounts.

Click on the Add Row icon to create a new alias. Enter the following information:

Alias Name: RevDom

Account Template: 101-2000-400000-000-000-000

Description: Revenue Domestic for Supremo Fitness, Line of Business 2, and US Operations Cost Center

Enabled: Yes

Start Date: Today’s date

End Date: Blank

Click on the Save and Close button to save the alias.

You have successfully created a shorthand alias for the US Chart of Accounts. For more information, you can refer to the following resources:

Account Aliases

Enter a GL Account Alias

Short Hand Alias in Fusion Financials Key Flexfield

How to Enable Account Shorthand Aliases

Here are the steps you need to follow:

Navigate to the Setup and Maintenance work area and search for the task Manage Chart of Accounts Structures.

Click on the Create icon to create a new Chart of Accounts Structure. Enter the following information:

Structure Code: 07COA

Structure Name: 07 Chart of Accounts

Description: Chart of Accounts for candidate 07

Number of Segments: 5

Click on the Next button to define the segments. Enter the following information for each segment:

Segment Number: 1

Segment Name: Company

Value Set Code: 07Corporate Company

Value Set Name: 07 Corporate Company

Maximum Size: 3

Balancing: Yes

Segment Label: Company

Segment Number: 2

Segment Name: Cost Center

Value Set Code: 07Corporate Cost Center

Value Set Name: 07 Corporate Cost Center

Maximum Size: 4

Balancing: No

Segment Label: Cost Center

Segment Number: 3

Segment Name: Account

Value Set Code: 07Corporate Account

Value Set Name: 07 Corporate Account

Maximum Size: 8

Balancing: No

Segment Label: Natural Account

Segment Number: 4

Segment Name: Product

Value Set Code: 07Corporate Product

Value Set Name: 07 Corporate Product

Maximum Size: 3

Balancing: No

Segment Label: Product

Segment Number: 5

Segment Name: Intercompany

Value Set Code: 07Corporate Company

Value Set Name: 07 Corporate Company

Maximum Size: 3

Balancing: No

Segment Label: Intercompany

Click on the Next button to review the summary and click on the Save and Close button to save the Chart of Accounts Structure.

Navigate to the Setup and Maintenance work area and search for the task Manage Chart of Accounts Structure Instances.

Click on the Create icon to create a new Chart of Accounts Structure Instance. Enter the following information:

Structure Code: 07COA

Structure Name: 07 Chart of Accounts

Description: Chart of Accounts for candidate 07

Chart of Accounts Structure: 07COA

Enabled: Yes

Allow Dynamic Inserts: Yes

Click on the Next button to review the summary and click on the Save and Close button to save the Chart of Accounts Structure Instance.

You have successfully created a Chart of Accounts Structure and Instance for the given scenario. For more information, you can refer to the following resources:

Chart of Accounts Structures and Instances

Chart of Accounts Components

Minimum Steps For Financial Enterprise Structures Configuration

Overview of Creating and Configuring Chart of Accounts Structure and Instances

 Here are the steps you need to follow:

In the Setup and Maintenance work area, go to the following:

Offering: Financials

Functional Area: Financial Reporting Structures

Task: Manage Chart of Accounts Mapping

Select the source chart of accounts (UK) and the target chart of accounts (CA) that you want to map.

Click on the Segment Rules tab to define the segment mapping rules. Enter the following information for each segment:

Segment Number: 1

Segment Name: Company

Mapping Type: Value

Source Value: *

Target Value: *

Segment Number: 2

Segment Name: LoB

Mapping Type: Value

Source Value: *

Target Value: *

Segment Number: 3

Segment Name: Account

Mapping Type: Range

Source From Value: 1000

Source To Value: 1999

Target Value: 11101

Mapping Type: Range

Source From Value: 2000

Source To Value: 2999

Target Value: 22100

Mapping Type: Range

Source From Value: 3000

Source To Value: 3999

Target Value: 34000

Mapping Type: Range

Source From Value: 4000

Source To Value: 4999

Target Value: 42000

Mapping Type: Range

Source From Value: 5000

Source To Value: 99999999

Target Value: 51100

Segment Number: 4

Segment Name: Cost Center

Mapping Type: Value

Source Value: 0

Target Value: Balance Sheet

Mapping Type: Value

Source Value: 000

Target Value: Balance Sheet

Mapping Type: Value

Source Value: *

Target Value: 610

Segment Number: 5

Segment Name: Product

Mapping Type: Value

Source Value: *

Target Value: *

Segment Number: 6

Segment Name: Intercompany

Mapping Type: Value

Source Value: *

Target Value: *

Click on the Save and Close button to save the segment mapping rules.

You have successfully created a Chart of Accounts mapping for the given scenario. For more information, you can refer to the following resources:

Overview of the Chart of Accounts Mapping Page

Chart of Accounts Structures and Instances

How To Create A Chart Of Accounts Mapping For A Secondary Ledger

How To Bulk Upload The Mapping Rules In “Manage Chart of Accounts Mapping”

Centralized Management of Chart of Accounts Configurations