Oracle 1z0-1087-23 Dumps

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

It is excluded from the report

Unmatched Supported

Matched In Transit

Unmatched

Existing reconciliations that use the profile are not updated.

Existing reconciliations with Pending or Open With Preparer status that use the profile are updated with the changes.

Existing reconciliations that use the profile are updated after approval by a system administrator.

Existing reconciliations with Pending status that use the profile are updated with the changes.

Changes made by the deleted member are reassigned to the primary member of the team for review and approval,

The reconciliation is flagged as invalid and needs to be re-created by the administrator.

Changes made by the deleted member are reverted and the deleted member is removed from the reconciliation as preparer.

Changes made by the deleted member are kept intact and the deleted member still appears as the original preparer.

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.

Suggested

Auto Approve

Auto Submit

Confirmed

In the Balance Explanations tab of the current period reconciliation, select ‘Copy Transactions from Prior Reconciliation’.

In the profile for Prepaid Expenses reconciliations, select ‘Include Prior Period Transactions’.

In the Reconciliations list, copy the reconciliation from the prior period and paste it into the current period.

Export the transactions from the prior period reconciliation and then import them to the current period reconciliation.

Key Field

Accounting Date

Calculation

Balancing Attribute

Transaction Matching Only

Variance Analysis with Transaction Matching

Balance Comparison with Transaction Matching

Account Analysis with Transaction Matching

end date

prior period end date

close date

start date

The Data Management data load fails.

You are prompted whether to overwrite the pre-mapped balances.

The balances loaded through Data Management overwrite the pre-mapped balances.

The reconciliation takes the balances loaded through Data Management and the pre-mapped balance load, and totals them.

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

Data Management data load rule

Smart View

Supplemental Data Management form

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.

Preparers can submit reconciliations with Open status.

Reviewers can approve reconciliations under review.

Reconciliations with Pending status can start.

You can load data to reconciliations for the period.

In the Workflow tab of the reconciliations, select a backup preparer in the Backup Preparer field.

In User Preferences, change your status to Out of Office.

In the Actions menu of the reconciliations, select Request Reassignment.

Click the Release button in the reconciliations to release it to the other team members.

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.

They must be assigned a quarterly calendar.

You cannot create reconciliations for profiles with transaction matching reconciliation methods for quarterly periods.

You can create reconciliations for those profiles only in periods that have Quarterly frequency selected.

The balances for quarterly reconciliations aggregate the balances from monthly reconciliations.

Currency Code

Currency Bucket

Period

Reconciliation ID

Entity

Amount

You create separate journal column mappings for adjustments and transactions.

For transactions, you can apply a data source filter to the export.

You create separate journal columns for each match type.

For adjustments, the variance amount is exported to the Amount column.

Match types are exported to a .zip folder.

Import can update match types with Pending status only.

Match types are exported to comma-separated (CSV) files.

Import can update match types with Approved status only.

prepare reconciliations

execute automation like Automatic Recon and Rules

load balances

confirm suggested matches

Transactions with the same key attributes cannot be loaded.

The attribute is hidden from users.

Transactions are sorted by the attribute.

Values are required for the attribute.

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.