Manual Queries (Reconciliation)

SQL statements that run during matching-package processing, in the order listed on this page.

Open Reconciliation › Setup › Manual Queries in the app.

Source-processing queries live under Transformation › Setup › Manual Queries (linked from this page).

What you can do

Add, edit, enable/disable, reorder, and delete reconciliation manual queries

Attach queries to specific matching packages (objects)

Search by statement, type, or description

Columns typically include sequence number, ID, statement, status, type, and objects. Sequence numbers can skip values because they are shared with transformation queries.

Add a query

Choose Add query.

Enter the statement (plain SQL, run as written — not validated in the UI).

Set type, status, description, and matching-package objects.

Save. Drag to reorder, then Save sorting.

When they run

Queries run in sequence as part of matching-package processing (scheduled or manual package runs).