XDP Tables (73)
XDP - Provisioning — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
XDP_ACTION_CODES |
9 | Not used |
XDP_ACTION_CODES_TL |
12 | Not used |
XDP_ADAPTER_ADMIN_REQS |
19 | Stores all Adapter specific pending jobs |
XDP_ADAPTER_AUDIT |
23 | Holds audit information about all the completed administration requests for all Adapters |
XDP_ADAPTER_JOB_QUEUE |
18 | Job queue for the NEM |
XDP_ADAPTER_REG |
34 | Stores configuration data pertaining to all Adapters |
XDP_ADAPTER_TYPES_B |
17 | Stores all seeded and user defined Adapter Types |
XDP_ADAPTER_TYPES_TL |
12 | Translation Table |
XDP_ADAPTER_TYPE_ATTRS_B |
12 | Stores attributes and their default values for seeded and custom adapter types. |
XDP_ADAPTER_TYPE_ATTRS_TL |
13 | Stores the translateable display names and descriptions for adapter-type attributes. |
XDP_DEBUG |
23 | An internal debug table |
XDP_DQER_REGISTRATION |
10 | Internal table used for registering processes responsible for dequeuing messages from internal queues |
XDP_DQ_CONFIGURATION |
19 | Configuration table for application queues |
XDP_DQ_CONFIGURATION_TL |
12 | Multi-lingual support table for application queue configuration |
XDP_DQ_EXCEPTIONS |
14 | Common table to store queue exceptions |
XDP_ERRORS |
30 | Common table to store application errors |
XDP_ERROR_COUNT |
9 | Stores number of times an error has occured for a certain instance of an object. |
XDP_ERROR_LOG |
14 | Generically stores all persistent MLS compliant error messages belonging to different application entities (Order, Adapters, etc). |
XDP_FA_DETAILS |
14 | XDP_FA_DETAILS contains the runtime FA parameter values. |
XDP_FA_FULFILLMENT_PROC |
14 | Fulfillment Element Fulfillment procedures |
XDP_FA_PARAMETERS |
15 | This table is used to define parameters for the Fulfillment Procedure. |
XDP_FA_RESUBMISSION_LOG |
15 | This table records the resubmission jobs for Oracle Service Fulfillment Manager. The fulfillment elements may be restarted in Order Resubmi |
XDP_FA_RUNTIME_LIST |
52 | This table contains the list of the FAs which need to be executed for a workitem instance. |
XDP_FES |
18 | This table holds all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element. |
XDP_FES_TL |
12 | Table to hold details of network element instances. |
XDP_FE_ATTRIBUTE_DEF |
13 | Fulfillment Element Attribute Definition |
XDP_FE_ATTRIBUTE_DEF_TL |
12 | Fulfillment Element Attribute Definition |
XDP_FE_ATTRIBUTE_VAL |
10 | FE Attribute Values |
XDP_FE_ATTRIBUTE_VAL_TL |
13 | FE Attribute Values |
XDP_FE_CMD_AUD_TRAILS |
19 | FE Command Audit Trail |
XDP_FE_GENERIC_CONFIG |
14 | Fulfillment Element Generic Config definition. |
XDP_FE_SW_GEN_LOOKUP |
13 | Software Generic Lookup |
XDP_FE_SW_GEN_LOOKUP_TL |
12 | Software Generic Lookup |
XDP_FE_TYPES |
9 | Fulfillment Element Type definition |
XDP_FE_TYPES_TL |
12 | Fulfillment Element Type definition |
XDP_FMC_AUDIT_TRAILS |
14 | This table stores the reponses from the upstream system regarding a service fulfillment error |
XDP_FMC_AUD_TRAIL_DETS |
13 | This table contains the history of the service parameter value change for a faulty order. |
XDP_FULFILL_ACTIONS |
14 | Fulfillment Action definition |
XDP_FULFILL_ACTIONS_TL |
12 | MLS (Multi-Language Support) for the XDP_ FULFILLMENT_ACTIONS table |
XDP_FULFILL_WORKLIST |
52 | This table identifies a list of services that need to be fulfilled for the given order |
XDP_LINE_RELATIONSHIPS |
9 | XDP_LINE_RELATIONSHIPS table is used to identify whether a line item is part of a package line |
XDP_OE_ORDER_HEADERS |
30 | XDP_OE_ORDER_HEADERS contains the order header information for orders generated by Oracle SFM -Order Entry Interface. |
XDP_OE_ORDER_LINES |
27 | XDP_OE_ORDER_LINES contains all the order line information for an order which is generated by Oracle SFM - Order Entry interface. |
XDP_OE_ORDER_LINE_DETS |
12 | The table XDP_OE_ORDER_LINE_DETAILS contains the order line parameter values for an order which is generated by SFM- Order Entry interfac |
XDP_OE_ORDER_PARAMETERS |
10 | XDP_OE_ORDER_PARAMETERS contains all the order parameters for an order which is generated by SFM - Order Entry interface. |
XDP_ORDER_BUNDLES |
9 | This table stores all Bundles associated with an order. |
XDP_ORDER_HEADERS |
67 | Order Headers |
XDP_ORDER_LINEITEM_DETS |
10 | Order Line Item Details |
XDP_ORDER_LINE_ITEMS |
70 | Order Line Items |
XDP_ORDER_PARAMETERS |
9 | This table holds all parameters related to the order coming from the upstream system (Customer Care, Order Entry). These parameters are Orde |
XDP_ORDER_RELATIONSHIPS |
9 | This table holds the relationship between orders. |
XDP_PARAMETER_POOL |
14 | Not used |
XDP_PARAMETER_POOL_TL |
11 | Not used |
XDP_PROC_BODY |
12 | XDP_PROC_BODY stores the source of all the user defined procedures |
XDP_PROC_BODY_TL |
12 | XDP_PROC_BODY_TL is the MLS (Multi-Language Support) table for the XDP_PROC_BODY table |
XDP_SERVICES |
14 | Not used |
XDP_SERVICES_TL |
11 | Not used |
XDP_SERVICE_PACKAGES |
12 | Not used |
XDP_SERVICE_PACKAGES_TL |
11 | Not used |
XDP_SERVICE_PKG_DET |
11 | Not used |
XDP_SERVICE_PKG_DET_TL |
12 | Not used |
XDP_SERVICE_VAL_ACTS |
23 | XDP_SERVICE_VAL_ACTS is used to define the valid service actions for a given service |
XDP_SERVICE_VAL_ACTS_TL |
11 | XDP_SERVICE_VAL_ACTS_TL is the MLS (Multi-Language Support) table for the XDP_SERVICE_VAL_ACTS table |
XDP_SERVICE_WI_MAP |
12 | XDP_SERVICE_WI_MAP is used to define the list of work items that need to be executed to fulfill the given service action |
XDP_SERVICE_WI_MAP_TL |
11 | XDP_SERVICE_WI_MAP_TL is the MLS (Multi-Language Support) table for the XDP_SERVICE_WI_MAP table |
XDP_WF_PROCESS_COORD |
12 | Workflow process coordination |
XDP_WI_FA_MAPPING |
11 | XDP_WI_FA_MAPPING defines the list of fulfillment actions to be excuted in order to fulfill a work item |
XDP_WI_FA_MAPPING_TL |
11 | XDP_WI_FA_MAPPING_TL is the MLS (Multi-Language Support) table for the XDP_WI_FA_MAPPING table |
XDP_WI_PARAMETERS |
19 | XDP_WI_PARAMETERS holds all the work item parameters and associated properties for a given work item |
XDP_WI_RELATIONSHIPS |
9 | The table XDP_WI_RELATIONSHIPS hold all the relationships of any work item within an order. |
XDP_WORKITEMS |
23 | XDP_WORKITEMS is used to define a work item |
XDP_WORKITEMS_TL |
12 | XDP_WORKITEMS_TL is the MLS table (Multi-Language Support) for the XDP_WORKITEMS table |
XDP_WORKLIST_DETAILS |
17 | Fulfillment Worklist Details |