The QAD BI 3.8.2 maintenance release resolves issues with the Common and Financial modules.

Upgrade Instructions

Contact QAD Services for upgrade information.

Data Warehouse Tables Changed

The following section lists the Data Warehouse tables that have been changed, added, or deleted.

Note: The tables on the Modified list may have been changed structurally. For example:

•

Columns added or deleted

•

Indexes added or deleted

•

Changes made to business display names

•

Changes to visibility of particular columns in the BI Portal

•

Any combination of these modifications

•

The procedure that populates the table has changed

List of Tables Modified

Common Module Modified Tables

•

dim_credit_term

•

load_tr_hist_history

•

stage_transaction_hist

•

load_tr_hist

•

perm_transaction_hist

Financials Module Modified Tables

•

extract_ee_customer_invoice

•

perm_ee_posting_saf

•

permsup_ee_posting_line

•

extract_ee_customer_invoice_stage

•

perm_ee_posting_saf_combined

•

permsup_ee_posting_saf

•

extract_ee_posting_line

•

perm_ee_posting_saf_combined

•

permsup_ee_posting_saf

•

extract_ee_supplier_invoice

•

perm_ee_supplier_invoice

•

stage_ee_ap_supplier_invoice

•

perm_ee_customer_invoice

•

perm_ee_supplier_invoice

•

stage_ee_ap_supplier_invoice

•

perm_ee_customer_invoice

•

perm_ee_supplier_invoice_movement

•

stage_ee_ap_supplier_invoice1

•

perm_ee_customer_invoice_movement

•

perm_ee_supplier_invoice_movement

•

stage_ee_ar_customer_invoice_hist

•

perm_ee_customer_invoice_movement

•

perm_ee_supplier_invoice_posting

•

stage_ee_ar_customer_invoice1

•

perm_ee_customer_invoice_opinfo

•

perm_ee_supplier_invoice_posting

•

stage_ee_customer_invoice_perm

•

perm_ee_customer_invoice_opinfo

•

perm_ee_supplier_invoice_stage

•

stage_ee_gl_transaction1

•

perm_ee_customer_invoice_stage

•

perm_ee_supplier_invoice_stage

•

stage_ee_posting_line_perm

•

perm_ee_customer_invoice_stage

•

permsup_ee_posting_line

•

stage_ee_supplier_invoice_perm

•

perm_ee_posting_saf

Tables Added to Existing Modules

Common Module Added Tables

For the 3.8.2 release, no tables were added to the Common Module.

Financials Module Added Tables

•

stage_ee_ap_supplier_invoice_hist1

•

stage_ee_ap_supplier_invoice_history2

•

stage_ee_ar_customer_invoice_hist1

•

stage_ee_ap_supplier_invoice_hist1

•

stage_ee_ap_supplier_invoice_history2

•

stage_ee_ar_customer_invoice_history

•

stage_ee_ap_supplier_invoice_history0

•

stage_ee_ap_supplier_invoice_history3

•

stage_ee_ar_customer_invoice_history0

•

stage_ee_ap_supplier_invoice_history0

•

stage_ee_ap_supplier_invoice_history3

•

stage_ee_ar_customer_invoice_history1

•

stage_ee_ap_supplier_invoice_history1

•

stage_ee_ap_supplier_invoice_history4

•

stage_ee_ar_customer_invoice_history2

•

stage_ee_ap_supplier_invoice_history1

•

stage_ee_ap_supplier_invoice_history4

•

stage_ee_ar_customer_invoice_history3

List of Tables Deleted

For the 3.8.2 release, no tables were deleted.

Fixes

Table 3 BI 3.8.2 Fixes

Component

QAD Issue

Description

Metadata(EE Financials)

QBI-2187

BI 3.8.2 fixes some calculation errors for the Financials EE History and Snapshot fact tables. Invoices with payments spread over multiple dates could have double-counted payments or missing payments on some history and snapshot records.

The data that ends up in the fact tables is now correct. The actual changes are to several of the stage tables leading up to these fact tables. The following fact tables are affected:

•

fact_ee_ap_supplier_invoice_history

•

fact_ee_ap_supplier_invoice_snapshot

•

fact_ee_ar_customer_invoice_history

•

fact_ee_ar_customer_invoice_snapshot

QBI-3352

BI 3.8.2 fixes a rare set of circumstances, where stage_ap_voucher_chk_match would go into an infinite loop but the audit log would reveal single record inserts. Sometimes it would reveal 2 and then 1 insert.

QBI-2956

In BI 3.8.1, dim_credit_term ceased to function as a slowly changing dimension. There was no start and end effective dates for the credit terms records. BI 3.8.2 fixes this issue and dim_credit_term is again a slowly changing dimension, and the history of credit terms changes is preserved.

QBI-2816 QBI-2817 QBI-3219 QBI-3227 QBI-3235

BI 3.8.2 makes various internal improvements to the EE Financials processing and should have no effect on the fact table results. This improvement:

•

Allows you to run upgrades in the future

•

Allows you to reload a fact table from the perm tables without requiring any re-running of data loads from the source