1z0-1087-23 Practice Exam Questions with Answers Oracle Account Reconciliation 2023 Implementation Essentials Certification

matching credits and debits for a clearing account

intercompany matching

matching bank and point-of-sale transactions

variance analysis for current and prior period balances

You select a separate load file for each data source.

You can select comma or tab for delimiter, or enter a user-defined delimiter.

You can import transactions to a match type only if its status is Pending.

Auto-match can run automatically after the import is finished.

You must select a match type for the import.

On the currency tab, enable a currency bucket for that prior period balance.

Add a rule to the Rules tab.

Select a format with the Variance Analysis reconciliation method for the profile.

Create a calculated attribute to compare the prior period balance to the current period balance and add it to the profile.

Method

Normal Balance

Process

Account Type

The status reverts to Pending.

The import fails.

The status reverts to Open with Preparer.

The status is unchanged but a notification is sent to the related users.

‘Import pre-mapped balances’ option in the Periods page

Data Management data load rule

Smart View

Supplemental Data Management form

Unexplained difference is zero

Balance is zero

Zero activity

Balance is normal

No transactions

Matches Exactly

Matches with Tolerance

Suggested Match

Adjustment

One to One

Group reconciliations include other individual reconciliations as children.

You cannot use Data Management to import balances for group reconciliations.

The format for the reconciliation must be enabled for Group Reconciliation.

The Group Detail tab shows data for the group reconciliation sub segments.

You can import balances into periods as pre-mapped data.

In the Instructions tab of the profile, add instructions for all team members to review the reconciliation.

On the Workflow tab of the Profile, select All Reviewers in the Require Action By field.

Add a rule of the type Require Team Review to the Rules tab.

Do not select a Primary User for the Account Payable Reviewers team.

SWIFT MT940

BAI

EDI

XML

Format

Reconciliation

Profile

Match Type

currency buckets

account ids

organizational units

formats

They display in both the Reconciliations list and the Matching list.

They do not participate in period-end compliance workflow.

They do not need to be created for periods.

You must create profiles for them.

It is excluded from the report

Unmatched Supported

Matched In Transit

Unmatched

You can assign access by user role.

They can include calculated values.

They can be assigned default value.

You can no longer add/edit attributes after reconciliations are created.

Currency Code

Currency Bucket

Period

Reconciliation ID

Entity

Amount

Any user can publish a saved filter that they created.

Saved Filters are public by default.

Only power users and service administrators can publish filters.

Only service administrators can publish filters.