You are browsing the archive for Oracle Advanced Product Catalog.

Item/Item Revision Implement Pending Changes Concurrent Program

 

NAME: Item/Item Revision Implement Pending Changes Concurrent Program
SHORT CODE: EGOCIPSP
MODULE: Oracle Advanced Product Catalog

Description: This is the concurrent program for the EGOCIPS executable
Navigation: Oracle Advanced Product Catalog Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_organization_id : The organization id for which the phase change is being implemented; it will be implemented for all orgs if null is passes
  • p_inventory_item_id : The inventory item id for the item for which the phase change is being implemented; it will be implemented for all items if null is passes
  • p_revision_code : The revision code for which all pending changes are to be implemented; ‘ALL’: all revisions, ‘NONE’: only items, NULL: both items and revisions

 

Bulkload Program For Spread Sheet Upload

 

NAME: Bulkload Program For Spread Sheet Upload
SHORT CODE: EGOBKUPL
MODULE: Oracle Advanced Product Catalog

Description: Bulkload Program For Spread Sheet Upload
Navigation: Oracle Advanced Product Catalog Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Result Format Usage Id : Result Format Usage Id
  • User Id : User Id
  • Language : Language
  • Responsibility Id : Responsibility Id
  • Application Id : Application Id

 

Oracle Advance Product Catalog Tables

Oracle Advance Product Catalog tables

  • EGO_ACTIONS_B
  • EGO_ACTIONS_TL
  • EGO_ACTION_DISPLAYS_B
  • EGO_ACTION_GROUPS_B
  • EGO_ACTION_GROUPS_TL
  • EGO_ACTN_GRP_ENTRIES_B
  • EGO_AML_INTF
  • EGO_ATTR_MAPPING_MASTER
  • EGO_ATTR_MAPPING_ROWS
  • EGO_BULKLOAD_INTF
  • EGO_CATG_MAP_DTLS
  • EGO_CATG_MAP_HDRS_B
  • EGO_CATG_MAP_HDRS_TL
  • EGO_CAT_GRP_MFG_ASSOCS
  • EGO_CAT_GRP_RPT_TEMPLATES
  • EGO_CAT_GRP_TEMPLATES
  • EGO_CRITERIA_EXT
  • EGO_CUSTOMIZATION_EXT
  • EGO_CUSTOMIZATION_RF
  • EGO_DM_CAT_PRIVILEGE_MAP
  • EGO_EXTERNAL_SYSTEM_DEF
  • EGO_EXTERNAL_SYS_ATTR_MAP
  • EGO_EXT_SYS_ELEMENTS
  • EGO_FND_DESC_FLEXS_EXT
  • EGO_FND_DF_COL_USGS_EXT
  • EGO_FND_DSC_FLX_CTX_EXT
  • EGO_FND_FLX_VAL_STS_EXT
  • EGO_FND_OBJECTS_EXT
  • EGO_FUNCTIONS_B
  • EGO_FUNCTIONS_TL
  • EGO_FUNC_PARAMS_B
  • EGO_FUNC_PARAMS_TL
  • EGO_GLOBAL_BUTTON
  • EGO_GTIN_SETUP
  • EGO_GTN_ATTR_CHG_B
  • EGO_GTN_ATTR_CHG_TL
  • EGO_GTN_MUL_ATTR_CHG_B
  • EGO_GTN_MUL_ATTR_CHG_TL
  • EGO_IMAGES
  • EGO_IMPORT_BATCHES_B
  • EGO_IMPORT_BATCHES_TL
  • EGO_IMPORT_BATCH_CHANGES
  • EGO_IMPORT_EXCLUDED_SS_ITEMS
  • EGO_IMPORT_OPTION_SETS
  • EGO_ITEMS_ATTRS_CHANGES_B
  • EGO_ITEMS_ATTRS_CHANGES_TL
  • EGO_ITEM_CAT_DENORM_HIER
  • EGO_ITEM_CUST_ATTRS_B
  • EGO_ITEM_GTN_ATTRS_B
  • EGO_ITEM_GTN_ATTRS_TL
  • EGO_ITEM_MATCHES
  • EGO_ITEM_PEOPLE_INTF
  • EGO_ITEM_PROJECTS
  • EGO_ITEM_TEXT_TL
  • EGO_ITEM_TP_ATTRS_EXT_B
  • EGO_ITEM_TP_ATTRS_EXT_TL
  • EGO_ITMATTR_APPL_USGS_B
  • EGO_ITM_GTN_MUL_ATTRS_B
  • EGO_ITM_GTN_MUL_ATTRS_TL
  • EGO_ITM_USR_ATTR_INTRFC
  • EGO_LANGUAGE_SETTINGS
  • EGO_LCPHASE_ITEM_STATUS
  • EGO_LCPHASE_POLICY
  • EGO_LOGIN_ITEMS_TEMP
  • EGO_MAPPINGS_B
  • EGO_MASSUPDATE_ITEM_TMP
  • EGO_MASSUPDATE_ORG_TMP
  • EGO_MFG_PART_NUM_CHGS
  • EGO_MINOR_REVISIONS
  • EGO_MTL_SY_ITEMS_CHG_B
  • EGO_MTL_SY_ITEMS_CHG_TL
  • EGO_MTL_SY_ITEMS_EXT_B
  • EGO_MTL_SY_ITEMS_EXT_TL
  • EGO_MY_ITEMS
  • EGO_OBJECT_EXT_TABLES_B
  • EGO_OBJECT_ROLES
  • EGO_OBJTYPE_ATTACH_CATS
  • EGO_OBJ_AG_ASSOCS_B
  • EGO_OBJ_ROLE_MAPPINGS
  • EGO_OBJ_TYPE_LIFECYCLES
  • EGO_PAGES_B
  • EGO_PAGES_TL
  • EGO_PAGE_ENTRIES_B
  • EGO_PRODUCT_CAT_SET_EXT
  • EGO_REPORTS
  • EGO_REPORT_DELIVERABLES
  • EGO_REPORT_LISTS_B
  • EGO_REPORT_LISTS_TL
  • EGO_REPORT_LIST_ENTRIES
  • EGO_RESULTS_FMT_USAGES
  • EGO_SOURCE_SYSTEM_EXT
  • EGO_SUBTAB
  • EGO_TAB_SETUP
  • EGO_TEMPL_ATTRIBUTES
  • EGO_UCCNET_ADD_CIC_INFO
  • EGO_UCCNET_BASELINES
  • EGO_UCCNET_EVENTS
  • EGO_UOM_MAPPING_MASTER
  • EGO_UOM_MAPPING_ROWS
  • EGO_VS_VALUES_DISP_ORDER