Tuesday, December 13, 2011

Noetix: Obsolete Views at Release 12 (With Suggested Replacements)

Below is a list of the obsolete Noetix Views at Release 12 (along with their suggested replacements). We aren't using all the Noetix modules so there might be others but the list below covers the following roles (from the generated Noetix help);

AOLAP_AOL
XXNAO_NOETIX_ADMIN
FA_FIXED_ASSETS
GL_LEDGER
AP_PAYABLES
AR_RECEIVABLES
OE_ORDER_ENTRY
PO_PURCHASING
XIN_INVENTORY
GMD_PRODUCT_DEVELOPMENT
GME_PROCESS_EXECUTION
GMF_OPM_FINANCIALS
GMI_PROCESS_PLANNING
INV_INVENTORY
XXK_KEY_FLEXFIELD

Obsolete views where tracked by looking for views with "obsolete" in their help description at R12. It's worth noting that base views don't have help information and so are never "formerly" listed as obsolete. The inclusion of GMF_Order_Details_Base in the list below was the result of one of our developers using it and us discovering subsequently that it was obsolete.

Similarly the recommended replacement view is from the help text provided or, if nothing useful is forthcoming, from my/our experience;

Views Without any Known Replacement
  • GMP_MRP_Mtrl_Unbucketed
  • GMP_MRP_Demand_Supply_Dtl
  • GMP_MRP_Action_Msg_Pegging
  • GMP_Action_Messages
  • GMP_Warehouse_Transfer
  • GMP_Warehouse_Rules
  • GMI_Production_Rules
  • GMI_Onhand_Inv_Rollup
  • GMI_Lots_Sublots
  • GMI_Item_Catalogs
  • GMI_Inv_Unallocated_Rollup
  • GMI_Inv_Stock_Locators
  • GMF_Test_Subledger
  • GMF_Cost_Warehouse_Assoc
Views with available replacments
  • GMP_Forecast_Details > INV_Forecasts
  • GMI_Unallocated_Inventory > INV_Unallocated_Inventory
  • GMI_Onhand_Inv_By_Lot > INV_Item_Onhand_By_Lot
  • GMI_Onhand_Inv_By_Location > INV_Onhand_Quantities
  • GMI_Month_End_Inventory > INV_Period_Close_Details
  • GMI_Item_master > INV_Items, INV_Item_Inventory_Attributes, and INV_Category_* views
  • GMI_Inv_Transactions > INV_Transactions and INV_Transaction_Details
  • GMF_Update_Subledger > GMF_SLA_Cost_Subledger
  • GMF_Cost_Warehouse_Assoc > GMF_Cost_Organization_Assoc
  • GMF_Order_Details_Base > GMF_SLA_Cost_Subledger
The changes that really made life difficult for us were the GMI_Item_Master being replaced, this dramatically increased the complexity of several previously simple reports, the GMI Onhand view changes, this broke a lot of reports, and while the mapping between GMI_Inv_Transactions and the replacement views wasn't too bad the changes behind the scenes meant that a lot of reporting logic had to change.

I hope this is of use!

Post a Comment