The following section lists the Data Warehouse tables that have been changed, added, or deleted.
|
|
|
•
|
stage_inv_bal_mth_trans1
|
|
|
|
|
|
•
|
stage_inv_bal_mth_trans2
|
|
|
|
•
|
extract_inv_trans_hist_cons
|
|
|
|
•
|
stage_po_order_hist_initial
|
|
|
•
|
extract_inv_transaction_hist
|
|
|
|
•
|
stage_po_order_hist_initial1
|
|
|
•
|
extract_op_transaction_hist
|
|
|
•
|
stage_inv_mth_balance_hist_calc
|
|
|
•
|
stage_po_order_hist_initial3
|
|
|
•
|
extract_po_transaction_hist
|
|
|
|
•
|
stage_po_order_hist_initial4
|
|
|
|
|
|
•
|
stage_po_order_hist_initial5
|
|
|
|
|
|
•
|
stage_po_order_hist_initial6
|
|
|
|
|
•
|
stage_inv_transaction_con_cus3
|
|
|
•
|
stage_po_order_hist_initial7
|
|
|
|
|
•
|
stage_inv_transaction_con_cus4
|
|
|
|
|
|
|
|
|
|
|
|
|
|
•
|
stage_inv_trx_chg_mths1
|
|
|
|
•
|
stage_inv_bal_item_list
|
|
|
•
|
stage_op_tr_hist_rjct_wo
|
|
|
|
•
|
stage_inv_bal_mth_current
|
|
|
•
|
stage_op_tr_hist_rjct_wo1
|
|
|
|
•
|
stage_inv_bal_mth_current4
|
|
|
|
|
|
|
|
•
|
stage_po_order_snapshot
|
|
|
•
|
stage_inv_bal_mth_date1
|
|
|
•
|
stage_op_transaction_merge
|
|
|
•
|
work_inv_change_hist_list
|
|
|
•
|
stage_inv_bal_mth_date2
|
|
|
|
|
|
|
|
|
•
|
stage_inv_bal_mth_trans
|
|
|
|
Table 2 BI 3.7 Fixes (1 of 3)
|
Component
|
QAD Issue
|
Description
|
|
ETL performance
|
QBI-614
|
The daily_date_roll_qad is very slow when current week spans year boundary.
|
|
|
QBI-635
|
STAGE_OM_INVOICE1 taking exceptionally long to load
|
|
Installation
|
QBI-1429
|
INITIAL_JOB_SETUP can add non-existent POSTPROCESS jobs to job order parameters.
|
|
Metadata
(Capacity Plan)
|
QBI-1778
|
fact_op_transaction—transaction_number currently flagged as a measure, but should not be.
|
|
Metadata
(Financials SE)
|
QBI-2131
|
fact_ap_invoice_snapshot not deleting interim records.
|
|
|
QBI-729
|
Research and correct budget amount measures in fact_gl_balance.
|
|
Metadata
(Inventory)
|
QBI-543
|
Inventory balances not matching Inventory transactions.
|
|
|
QBI-715
|
Updated 3.5 Design Specification to include logic from lnd_det (Location Detail) tables.
|
|
|
QBI-1694
|
Inventory—fact_inv_mth_balances does not properly capture the unit_cost of items, leaving unit_cost of 0, so although the end of month quantity can be > 0, the value = 0 (incorrectly).
|
|
|
QBI-1802
|
Inventory—fact_inv_mth_balances does not properly set the end of month qoh balance so all the calculations for every month are not coming out like they should.
|
|
|
QBI-1893
|
New parameter INV_HISTORY_DATE should be added to the parameter list and populated by INITIAL_JOB_SETUP on install.
|
|
|
QBI-1980
|
The Inventory module job does not sequence some of the last post load tasks properly, instead running them all at the same time.
|
|
|
QBI-1985
|
New Parameter INV_HISTORY_DATE should be added to the parameter list and populated by INITIAL_JOB_SETUP on install. (r7m)
|
|
|
QBI-1986
|
fact_inv_mth_balance should not include kit items in the transaction portion of the change calculation for a given month. We may also need to not include GIT (goods in transit).
|
|
|
QBI-2102
|
stage_inv_bal_revalue2 is not source system specific so it will grab all records in the fact every time it runs.
|
|
|
QBI-2107
|
3.6 column transformation change for ship_type in stage_inv_transaction1 is causing downstream staging tables to not properly calculate qoh changes and balances.
|
|
|
QBI-2125
|
Fact_inv_mth_balance shows value_issued_base as negative values but shows the quantity_issued_base as positive. In stage_inv_mth_balance1 we are setting the quantity_issued amount to the ABS (absolute) value so both negative and positive amounts are pos.
|
|
Metadata
(Multi-Module)
|
QBI-711
|
load_tr_hist picks up new records on daily loads, even if there are no new records in the source system
|
|
|
QBI-717
|
daily_date_roll_qad should parameterize the date it uses to set Current/Previous/Lastyear/No (GetDate() is hard coded 3 times in procedure)
|
|
|
QBI-1275
|
stage_unit_of_measure1 missing join constraints
|
|
|
QBI-1775
|
Scheduled Jobs for CUBES do not have the "submit_next_chained_job()" task so they can be automatically part of the DAILY job chain.
|
|
Metadata
(Operations)
|
QBI-1704
|
Truncation of load tables combined with placement of load tables ensures no data gets into fact_inv_mth_balance on daily runs. Need to load the inv_transaction types earlier.
|
|
|
QBI-2145
|
The Days On Hand Calculation shown in the Inventory Dashboard is inconsistent with the Inventory Turns calculation.
|
|
|
QBI-2146
|
The calculation of throughput in the Capacity Planning and Control - Production Lines Dashboard uses "Active Days" (reported time) not "Scheduled Days" from the shop calendar.
|
|
Metadata
(Order Management)
|
QBI-276
|
GL Calendar needed for Order Management.
|
|
|
QBI-631
|
All extended prices in fact_om_order_history are calculated based on the open_amount, not the order_amount. Customers are unhappy about this and we need to determine if our logic is correct or not.
|
|
|
QBI-632
|
QMI (2011 EE) Shipment Transaction Report not matching BI OM Shipment Fact
|
|
|
QBI-1553
|
stage_om_order3 not matching dim_account - error in outer join.
|
|
|
QBI-1699
|
fact_om_shipment references the wrong source columns for several of it's columns including most importantly shipment date. Need to correct for fact_om_shipment to work properly.
|
|
|
QBI-1996
|
stage_om_invoice_line_range fails in Chinese environment
|
|
|
QBI-2067
|
3.5.1 and 3.6.1 maintenance releases have a bug in historic load logic for OM table fact_om_order_history. This bug is in stage_om_order1
|
|
|
QBI-2068
|
fact_om_order_history sometimes will have CLOSED orders that are the most recent/current version of the record, but will not be shown as most recent/current and are then showing up in fact_om_order as OPEN even though they are CLOSED.
|
|
|
QBI-2092
|
The 3.5.1 patch had a couple of rank over clauses that did not rank transaction_date correctly and needs to be corrected.
|
|
Metadata
(Order Management, Purchasing)
|
QBI-2101
|
Need SALES_LOOKBACK_DAYS and PO_LOOKBACK_DAYS parameters
|
|
Metadata
(Purchasing)
|
QBI-750
|
Remove extended_cost_ from fact_po_order_history - duplicates open_amount_
|
|
|
QBI-771
|
fact_po_order_history storing incorrect last receipt date
|
|
|
QBI-2124
|
Our PO Snapshot and OM snapshot tables have a problem in stage_po_order_snap1 and stage_om_order_snap1 where if the last day of a month and last day of a week are the same, only the Monthly record values are retrieved.
|
|
Portal
|
QBI-468
|
Text area on dashboard— no title causes problems.
|
|
|
QBI-533
|
Portal gets sluggish. Must close browser and restart.
|
|
|
QBI-594
|
In queries, "AND" and "OR" not translated.
|
|
|
QBI-790
|
BI Portal cannot display plus sign in visual items due to a known problem in Flex.
|
|
|
QBI-1314
|
Check boxes not displaying properly in Security tab for object in repository browser.
|
|
|
QBI-1388
|
Ops-Capacity Planning Sub-module—Performance Ratio truncating or rounding down.
|
|
|
QBI-1891
|
Visual Items—when creating a heat map, the range at the bottom does not change when the different type of heat map is selected.
|
|
|
QBI-1913
|
Visual Items—creating Collaboration/Message type of visual item, in the right-side Edit pane, the heading says "essage" instead of "Message.
|
|
|
QBI-2136
|
Report Browser, Report Links, and Run Report page title do not show translated names.
|
|
Portal Standard Objects
(Capacity Planning)
|
QBI-1430
|
QAD Standard queries folder includes a "Fran" folder.
|
|
Portal Standard Objects (Fin EE, Fin SE)
|
QBI-1427
|
CFO Dashboard Template missing from Financials module portal objects.
|
|
Portal Standard Objects
(Inventory)
|
QBI-795
|
Issues and questions regarding the Drop Down parameters list on the Inventory Item Management dashboard.
|
|
|
QBI-1244
|
Inventory Management Dashboard—miscellaneous usability issues.
|
|
|
QBI-1245
|
Inventory Management Dashboard—Questions about Nettable vs Non-Nettable visual item.
|
|
|
QBI-1246
|
Inventory Management Dashboard—Inventory On Hand by Product Line does not show any data.
|
|
|
QBI-1247
|
Inventory Management Dashboard—Inventory On Hand by Site does not show any data.
|
|
|
QBI-1248
|
Inventory Management Dashboard—Inventory OH Trend Parameter only has a single data point, not a trend.
|
|
|
QBI-1251
|
Inventory Management Dashboard—Parameters for Inventory On Hand Report should be consistent with other reports.
|
|
|
QBI-1253
|
Inventory Management Dashboard—Top 10 Average Days OH by Product Line does not display any data.
|
|
|
QBI-1254
|
Inventory Management Dashboard—Top 10 Average Days OH by Site does not display any data.
|
|
|
QBI-1255
|
Inventory Management Dashboard—Inventory Transaction reports do not display data.
|
|
|
QBI-1256
|
Inventory Management Dashboard—Inventory Trends reports do not display data.
|
|
|
QBI-1257
|
Inventory Management Dashboard—Inventory Turnover does not display any data and has not parameters to change.
|
|
Portal Standard Objects (Purchasing)
|
QBI-779
|
Purchasing Dashboard—Top 10 Supplier by Spend visual item contains minor typo in the title
|
|
|
QBI-780
|
Purchasing Dashboard—The Reports visual item is not large enough to display the report titles
|
|
|
QBI-781
|
Purchasing Dashboard—Year parameter visual item does not reposition correctly when drop-down is displayed
|
|
|
QBI-783
|
Purchasing Dashboard—The query for the Cash Requirements Forecast cannot be found
|
|
|
QBI-784
|
Purchasing Dashboard—Trouble displaying data in Missed Delivery Detail report
|
|
|
QBI-786
|
Purchasing Dashboard—Open PO Cash Commitments by Due Date Summary and "For Year" reports have misc problems
|
|
|
QBI-787
|
Purchasing Dashboard—PO Delivery Performance Summary reports have misc problems
|
|
|
QBI-788
|
Purchasing Dashboard—Supplier Spend Ranking - Historical report does not work
|
