In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Release Notes for Release 3.8.2
QAD Business Intelligence Version: 3.8.2
Date: July 2013
New Feature Summary
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
Improves performance of history loads