Troubleshooting Reconciliation Issues

Use this troubleshooting reference to diagnose and resolve reconciliation issues after completing the daily workflow.

Symptom Likely cause Action
Net Sales does not equal the OPERA Grand Total. Business Day alignment mismatch or a transaction exists in one system but not the other. Verify the Business Day schedule, then search the Transaction Summary drill-down by amount or by the last four card digits.
Variance exists and the status is Partially Paid. A refund, chargeback, or settlement delay is affecting one or more transactions. Use the drill-down to review Partially Paid rows and monitor the Aging column.
A transaction shows an Aging value of eight or more days. Settlement may be stalled because of a chargeback or another processing issue. Capture the Payment Reference and contact Oracle Payments Support.
Status shows Not Paid for a recent Business Day. Settlement has not yet been initiated. No immediate action is needed; check again the following day.
Totals keep mismatching across consecutive days. Night Audit time changed without a matching update to the Oracle Payments Business Day schedule. Update the Business Day close time to reflect the current Night Audit schedule.

Parent topic: Reconciliation