Special Considerations for Comparing Invoices between and Oracle Transactional Business Intelligence

Invoices without invoice schedules or installments defined aren't loaded into .

Invoices may be incomplete due to the invoice schedules or installment not being defined.

Use the Oracle Transactional Business Intelligence Payables Installment subject area to compare data with the AP Invoices subject area. doesn't load the closed invoices before the initial extract date, for example 2012/01/01 00:00:00. Some transactions created since the last data load may be missing in as well. Be sure to complete the incremental data refresh before validating such transactions.

Use the Data Validation feature for the Total Transaction Amount metric from the AP Invoices subject area. If there are any differences between and Oracle Transactional Business Intelligence, check for possible mismatches by selecting the columns such as Invoice Number or Validation Status.