3 Foundation Data Maintenance

Foundation Data is basic information that is required for Merchandising to function properly. Most foundation data is managed through the Merchandising user interface or integrations from external systems. However, there are some batch processes that relate to Foundation Data. This chapter describes the batch processes that are used to maintain general foundation data.

Programs in this chapter can be divided into five basic categories:

• Updates to Cost Components that must be applied to other foundation data and transactions

  • Apply Pending Cost Component and ELC Changes to Purchase Orders (batch_ordcostcompupd)

  • Apply Pending Item Cost Component Updates (batch_itmcostcompupd)

  • Apply Pending Rate Changes to Expense Profiles (batch_expprofupd)

  • Apply Pending Up-Charge Cost Component Changes to Departments (batch_depchrgupd)

  • Update Allocation and Transfer Based on Changes to Up-Charges (batch_alloctsfupd)

  • Update ELC Components (batch_compeffupd)

• Rebuilds of detail information for lists/groups

  • Build Diff Ratios Based on Sales History (dfrtbld)

  • Rebuild Dynamic Item Lists (itmlrbld)

  • Rebuild Dynamic Location Lists (lclrbld)

  • Refresh Address Materialized View (refmvlocprimaddr)

  • Refresh Currency Conversion Materialized View (batch_rfmvcurrconv)

  • Refresh Localization Materialized View (refmvl10entity)

• Application of pending changes

  • Like Store Batch Processing (likestorebatch)

  • Process Pending Merchandise Hierarchy Changes from External Systems (cremhierdly)

  • Reclassify Items in Merchandise Hierarchy (reclsdly)

• Rollup of detailed information

  • Rollup of Supplier Data (supmth)

• Foundation Data Purges

  • Purge Aged Cost Component Exceptions (elcexcprg)

  • Purge Aged Price History Data (prchstprg)

  • Purge Aged Store Ship Schedule (schedprg)

  • Purge Manage Admin Records (admin_api_purge)

As an alternative to running some of the above processes in the batch cycle, a background process can be used. These include:

• Purge Aged Cost Component Exceptions (elc_except_purge_job)

• Purge Aged Price History Data (price_hist_purge_job)

• Purge Aged Store Ship Schedule (activity_sched_purge_job)

• Purge Inactive Currency Rates (currency_rates_purge_job)

• Rebuild Dynamic Location Lists (loc_list_rebuild_job)

• Stock Ledger and Budget Tables Insert

• Store Add Asynchronous Process (CORESVC_STORE_ADD_SQL. ADD_STORE)

• Store Add Asynchronous Process

• Warehouse Add Asynchronous Process

Note:

For more information on Foundation Data, see the Item Maintenance chapter.