FAP: Find A Part

1. FAP: Find A Part: - It's an online Store website which shows information about all the products Agilent sold to its customers. Product related information and their prices as per their location are also shown in the website. Customers can order from this website for these Products.
   
2. A.Com maintains the FAP DB which is refreshed from OPRD DB Server (OPRD DB is maintained by Oracle which contains all product related information across all Agilent Applications) OPRD DB is the common repository for all the Agilent Products.
   
3. Monthly FAP Processing:
   
   1. Extract Receiving and loading in FAP DB:
      
      1. On Monthly Basis, A.Com received FAP Pricing Extract from Pricing Team at our Job Server. There Pricing Extracts contains latest pricing for all the products. Pricing Extracts consists of pricing information for all the products and each extract file indicates the pricing of products related to a single country. Each Extract is renamed as per the naming of the Extract File by putting suffix as the concerned country name.
         
      2. There is a FAPBATCH Schema which exists in acomip92:CIADUP DB Server. FAPBATCH Schema contains External Tables for each country pricing. These External Tables are reads the renames extract file as these external tables are referring to each country's pricing extract.
         
      3. FAP_ITEM_PRICING Table is prepared when one Package execute @ FAPBATCH Schema. Then FAP_ITEM_PRICING table is exported and imported in main FAP DB (CIAPX1) @ the prod server (acomp30/31).
         
   2. FAP DB Refresh:
      
      1. FAP DB contains a set of 9 tables which contains the product related information. These 9 tables need to be refreshed from OPRD DB Server.
         
      2. 
         
4. Daily updation of FAP DB tables from TIBCO: At the TIBCO end some application connect to A.Com FAP DB and update/insert data in set of 9 PI tables.
   
   1. These 9 tables are:
      
      1. mtl_system_items_b
         
      2. mtl_item_status
         
      3. mtl_system_items_tl
         
      4. mtl_item_categories
         
      5. mtl_categories_b
         
      6. mtl_cross_references
         
      7. mtl_cross_reference_types
         
      8. bom_inventory_components
         
      9. bom_bill_of_materials
         
   2. A.Com DB contains these 9 tables in 3 sets:
      
      1. Main Tables
         
      2. PI_xxxxxx Tables
         
      3. TI_xxxxxx Tables
         
   3. PI_xxxx tables are updated/inserted during Daily operation
      
   4. TI_xxxx tables are used during Monthly Processing