Special Considerations for Comparing Invoices between Oracle Fusion Data Intelligence and Oracle Transactional Business Intelligence

Invoices without invoice schedules or installments defined aren't loaded into Oracle Fusion Data Intelligence.

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 Oracle Fusion Data Intelligence AP Invoices subject area. Oracle Fusion Data Intelligence 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 Oracle Fusion Data Intelligence 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 Oracle Fusion Data Intelligence AP Invoices subject area. If there are any differences between Oracle Fusion Data Intelligence and Oracle Transactional Business Intelligence, check for possible mismatches by selecting the columns such as Invoice Number or Validation Status.