1 Reply Latest reply: Jul 3, 2012 2:19 AM by Priyanshu Gupta RSS

    Staging table for PDH

    929896
      Hi,
      Anyone please tell me what are the staging tables for PDH.
      Actually I am using ODI to put data from eBS to PDH.
      So where I will put the data.
      How this can be achieved.

      Thanks
        • 1. Re: Staging table for PDH
          Priyanshu Gupta
          Some of the staging tables are:

          1) Items -- mtl_system_items_interface
          2) Item Categories -- mtl_item_categories_interface
          3) Cross Reference -- MTL_CROSS_REFERENCES_INTERFACE
          4) Item Revision Interface -- MTL_ITEM_REVISIONS_INTERFACE
          5) Item Relation Interface -- MTL_RELATED_ITEMS_INTERFACE
          6) Item Catalog Group Interface -- MTL_ITEM_CAT_GRPS_INTERFACE
          7) Attribute Group Interface -- EGO_ATTR_GROUPS_INTERFACE
          8) Item UDA Interface -- EGO_ITM_USR_ATTR_INTRFC
          9) EGO_ITEM_ASSOCIATIONS_INTF
          10) EGO_ITEM_PEOPLE_INTF

          There are some more you can get all that by querying the database.

          Hope it helps.

          Thanks,
          Priyanshu