Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - XDP Tables and Views

TABLE - XDP.XDP_ACTION_CODES

TABLE - XDP.XDP_ACTION_CODES_TL

TABLE - XDP.XDP_ADAPTER_ADMIN_REQS

TABLE - XDP.XDP_ADAPTER_AUDIT

TABLE - XDP.XDP_ADAPTER_JOB_QUEUE

TABLE - XDP.XDP_ADAPTER_REG

TABLE - XDP.XDP_ADAPTER_TYPES_B

TABLE - XDP.XDP_ADAPTER_TYPES_TL

TABLE - XDP.XDP_ADAPTER_TYPE_ATTRS_B

TABLE - XDP.XDP_ADAPTER_TYPE_ATTRS_TL

TABLE - XDP.XDP_DEBUG

TABLE - XDP.XDP_DQER_REGISTRATION

TABLE - XDP.XDP_DQ_CONFIGURATION

TABLE - XDP.XDP_DQ_CONFIGURATION_TL

TABLE - XDP.XDP_DQ_EXCEPTIONS

TABLE - XDP.XDP_ERRORS

TABLE - XDP.XDP_ERROR_COUNT

TABLE - XDP.XDP_ERROR_LOG

TABLE - XDP.XDP_FA_DETAILS

TABLE - XDP.XDP_FA_FULFILLMENT_PROC

TABLE - XDP.XDP_FA_PARAMETERS

TABLE - XDP.XDP_FA_RESUBMISSION_LOG

TABLE - XDP.XDP_FA_RUNTIME_LIST

TABLE - XDP.XDP_FES

TABLE - XDP.XDP_FES_TL

TABLE - XDP.XDP_FE_ATTRIBUTE_DEF

TABLE - XDP.XDP_FE_ATTRIBUTE_DEF_TL

TABLE - XDP.XDP_FE_ATTRIBUTE_VAL

TABLE - XDP.XDP_FE_ATTRIBUTE_VAL_TL

TABLE - XDP.XDP_FE_CMD_AUD_TRAILS

TABLE - XDP.XDP_FE_GENERIC_CONFIG

TABLE - XDP.XDP_FE_SW_GEN_LOOKUP

TABLE - XDP.XDP_FE_SW_GEN_LOOKUP_TL

TABLE - XDP.XDP_FE_TYPES

TABLE - XDP.XDP_FE_TYPES_TL

TABLE - XDP.XDP_FMC_AUDIT_TRAILS

TABLE - XDP.XDP_FMC_AUD_TRAIL_DETS

TABLE - XDP.XDP_FULFILL_ACTIONS

TABLE - XDP.XDP_FULFILL_ACTIONS_TL

TABLE - XDP.XDP_FULFILL_WORKLIST

TABLE - XDP.XDP_LINE_RELATIONSHIPS

TABLE - XDP.XDP_OE_ORDER_HEADERS

TABLE - XDP.XDP_OE_ORDER_LINES

TABLE - XDP.XDP_OE_ORDER_LINE_DETS

TABLE - XDP.XDP_OE_ORDER_PARAMETERS

TABLE - XDP.XDP_ORDER_BUNDLES

TABLE - XDP.XDP_ORDER_HEADERS

TABLE - XDP.XDP_ORDER_LINEITEM_DETS

TABLE - XDP.XDP_ORDER_LINE_ITEMS

TABLE - XDP.XDP_ORDER_PARAMETERS

TABLE - XDP.XDP_ORDER_RELATIONSHIPS

TABLE - XDP.XDP_PARAMETER_POOL

TABLE - XDP.XDP_PARAMETER_POOL_TL

TABLE - XDP.XDP_PROC_BODY

TABLE - XDP.XDP_PROC_BODY_TL

TABLE - XDP.XDP_SERVICES

TABLE - XDP.XDP_SERVICES_TL

TABLE - XDP.XDP_SERVICE_PACKAGES

TABLE - XDP.XDP_SERVICE_PACKAGES_TL

TABLE - XDP.XDP_SERVICE_PKG_DET

TABLE - XDP.XDP_SERVICE_PKG_DET_TL

TABLE - XDP.XDP_SERVICE_VAL_ACTS

TABLE - XDP.XDP_SERVICE_VAL_ACTS_TL

TABLE - XDP.XDP_SERVICE_WI_MAP

TABLE - XDP.XDP_SERVICE_WI_MAP_TL

TABLE - XDP.XDP_WF_PROCESS_COORD

TABLE - XDP.XDP_WI_FA_MAPPING

TABLE - XDP.XDP_WI_FA_MAPPING_TL

TABLE - XDP.XDP_WI_PARAMETERS

TABLE - XDP.XDP_WI_RELATIONSHIPS

TABLE - XDP.XDP_WORKITEMS

TABLE - XDP.XDP_WORKITEMS_TL

TABLE - XDP.XDP_WORKLIST_DETAILS

VIEW - APPS.XDP_ACTION_CODES_V

VIEW - APPS.XDP_ADAPTER_ADMIN_REQS_V

VIEW - APPS.XDP_ADAPTER_AUDIT_V

VIEW - APPS.XDP_ADAPTER_JOB_QUEUE_V

VIEW - APPS.XDP_ADAPTER_REG_V

VIEW - APPS.XDP_ADAPTER_SUMMARY_V

VIEW - APPS.XDP_ADAPTER_TYPES_VL

VIEW - APPS.XDP_ADAPTER_TYPE_ATTRS_VL

VIEW - APPS.XDP_ADAPTER_TYPE_REQ_TYPES_V

VIEW - APPS.XDP_ADAPTER_TYPE_V

VIEW - APPS.XDP_DQ_CONFIGURATION_VL

VIEW - APPS.XDP_ERROR_LOG_V

VIEW - APPS.XDP_EVENTS_V

VIEW - APPS.XDP_FA_PARAMETERS_DISP_V

VIEW - APPS.XDP_FA_PARAMETERS_V

VIEW - APPS.XDP_FES_VL

VIEW - APPS.XDP_FE_ATTRIBUTE_DEF_VL

VIEW - APPS.XDP_FE_ATTRIBUTE_VAL_VL

VIEW - APPS.XDP_FE_GENERIC_CONFIG_V

VIEW - APPS.XDP_FE_SUMMARY_V

VIEW - APPS.XDP_FE_SW_GEN_LOOKUP_VL

VIEW - APPS.XDP_FE_TYPES_VL

VIEW - APPS.XDP_FMC_V

VIEW - APPS.XDP_FULFILL_ACTIONS_VL

VIEW - APPS.XDP_INBOUND_MESSAGES_V

VIEW - APPS.XDP_LOOKUPS

VIEW - APPS.XDP_OE_ORDER_DETAILS_V

VIEW - APPS.XDP_ORDER_DETAILS_V

VIEW - APPS.XDP_ORU_ORDERS_V

VIEW - APPS.XDP_OUTBOUND_MESSAGES_V

VIEW - APPS.XDP_PARAMETER_POOL_VL

VIEW - APPS.XDP_PROC_BODY_VL

VIEW - APPS.XDP_PROFILE_OPTIONS_V

VIEW - APPS.XDP_READY_FAS_V

VIEW - APPS.XDP_READY_FES_V

VIEW - APPS.XDP_READY_ORDER_V

VIEW - APPS.XDP_READY_WORKITEM_V

VIEW - APPS.XDP_SERVICE_VAL_ACTS_VL

VIEW - APPS.XDP_SERVICE_WI_MAP_VL

VIEW - APPS.XDP_SUMMARY_QUEUES_V

VIEW - APPS.XDP_SVE_PKG_DET_DISP_V

VIEW - APPS.XDP_SVE_VAL_ACTION_DISP_V

VIEW - APPS.XDP_SVE_WI_MAPPING_DISP_V

VIEW - APPS.XDP_WAITING_FES_V

VIEW - APPS.XDP_WI_FA_MAPPING_DISP_V

VIEW - APPS.XDP_WI_FA_MAPPING_VL

VIEW - APPS.XDP_WI_PARAMETERS_DISP_V

VIEW - APPS.XDP_WORKITEMS_VL

Table: XDP_ACTION_CODES

Primary Key: XDP_ACTION_CODES_PK

1. ACTION_CODE_ID

Primary Key: XDP_ACTION_CODES_UK1

1. ACTION_CODE

Foreign Keys to this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

XDP.XDP_ACTION_CODES does not reference any database object

XDP.XDP_ACTION_CODES is referenced by following:

APPS

SYNONYM - XDP_ACTION_CODES

[top of page]

Table: XDP_ACTION_CODES_TL

Primary Key: XDP_ACTION_CODES_TL_PK

1. ACTION_CODE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

XDP.XDP_ACTION_CODES_TL does not reference any database object

XDP.XDP_ACTION_CODES_TL is referenced by following:

APPS

SYNONYM - XDP_ACTION_CODES_TL

[top of page]

Table: XDP_ADAPTER_ADMIN_REQS

Primary Key: XDP_ADAPTER_ADMIN_REQS_PK

1. REQUEST_ID

Comments

XDP_ADAPTER_ADMIN_REQS is used to define maintenance requests for an adapter. The allowable requests are STARTUP, SHUTDOWN, SUSPEND, RESUME, DISCONNECT and CONNECT. You can also schedule periodical maintenance requests by specifying the request frequency.

Indexes

Columns

[top of page]

XDP.XDP_ADAPTER_ADMIN_REQS does not reference any database object

XDP.XDP_ADAPTER_ADMIN_REQS is referenced by following:

APPS

SYNONYM - XDP_ADAPTER_ADMIN_REQS

[top of page]

Table: XDP_ADAPTER_AUDIT

Primary Key: XDP_ADAPTER_AUDIT_PK

1. ADAPTER_AUDIT_ID

Foreign Keys from this table:

Comments

Holds audit information about all the completed administration requests for all Adapters

Indexes

Columns

[top of page]

XDP.XDP_ADAPTER_AUDIT does not reference any database object

XDP.XDP_ADAPTER_AUDIT is referenced by following:

APPS

SYNONYM - XDP_ADAPTER_AUDIT

[top of page]

Table: XDP_ADAPTER_JOB_QUEUE

Primary Key: XDP_ADAPTER_JOB_QUEUE_PK

1. JOB_ID

Primary Key: XDP_ADAPTER_JOB_QUEUE_UK1

1. WF_ITEM_KEY
2. WF_ITEM_TYPE

Comments

XDP_ADAPTER_JOB_QUEUE is used as an internal queue table. When the Fulfillment Action(FA) workflow tries to execute a fulfillment procedure(FP) for provisioning a fulfillment element(FE), the workflow has to
first allocate a free adapter for the target FE. If all the adapters are busy, the workflow will
register itself in this queue table and suspend itself. When the adapter becomes available, the workflow will be notified and the adapter channel name will be passed to the workflow as it resumes its normal process.

Indexes

Columns

[top of page]

XDP.XDP_ADAPTER_JOB_QUEUE does not reference any database object

XDP.XDP_ADAPTER_JOB_QUEUE is referenced by following:

APPS

SYNONYM - XDP_ADAPTER_JOB_QUEUE

[top of page]

Table: XDP_ADAPTER_REG

Primary Key: XDP_ADAPTER_REG_PK

1. CHANNEL_NAME

Foreign Keys from this table:

Comments

XDP_ADAPTER_REG is used to manage all the adapters in Oracle SDP Provisioning. Whenever an adapter starts up, it registers itself in this table. The channel name of an adapter is the communication channel identifier for the adapter. If the adapter is a database pipe based adapter, the channel name will be the pipe name assigned by Oracle SDP Provisioning at the adapter startup time. If the adapter is a message based adapter, i.e., in the case of number portability, the adapter actually uses AQ to establish a communication link between the Oracle SDP Provisioning order processor and the FE, the channel name will be the unique identifier of the adapter instance.

Indexes

Columns

[top of page]

XDP.XDP_ADAPTER_REG does not reference any database object

XDP.XDP_ADAPTER_REG is referenced by following:

APPS

SYNONYM - XDP_ADAPTER_REG

[top of page]

Table: XDP_ADAPTER_TYPES_B

Primary Key: XDP_ADAPTER_TYPES_PK

1. ADAPTER_TYPE

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Stores all seeded and user defined Adapter Types

Indexes

Columns

[top of page]

XDP.XDP_ADAPTER_TYPES_B does not reference any database object

XDP.XDP_ADAPTER_TYPES_B is referenced by following:

APPS

SYNONYM - XDP_ADAPTER_TYPES_B

[top of page]

Table: XDP_ADAPTER_TYPES_TL

Primary Key: XDP_ADAPTER_TYPES_TL_PK

1. ADAPTER_TYPE
2. LANGUAGE

Foreign Keys from this table:

Comments

XDP_ADAPTER_TYPES_TL is the MLS (Multi-Language Support) table for the XDP_ADAPTER_TYPES_B table

Indexes

Columns

[top of page]

XDP.XDP_ADAPTER_TYPES_TL does not reference any database object

XDP.XDP_ADAPTER_TYPES_TL is referenced by following:

APPS

SYNONYM - XDP_ADAPTER_TYPES_TL

[top of page]

Table: XDP_ADAPTER_TYPE_ATTRS_B

Primary Key: XDP_ADAPTER_TYPE_ATTRS_B_PK

1. ADAPTER_TYPE_ATTRS_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Stores attributes and their default values for seeded and custom adapter types.

Indexes

Columns

[top of page]

XDP.XDP_ADAPTER_TYPE_ATTRS_B does not reference any database object

XDP.XDP_ADAPTER_TYPE_ATTRS_B is referenced by following:

APPS

SYNONYM - XDP_ADAPTER_TYPE_ATTRS_B

[top of page]

Table: XDP_ADAPTER_TYPE_ATTRS_TL

Primary Key: XDP_ADAPTER_TYPE_ATTRS_TL_PK

1. ADAPTER_TYPE_ATTRS_ID

Foreign Keys from this table:

Comments

Stores the translateable display names and descriptions for adapter-type attributes.

Indexes

Columns

[top of page]

XDP.XDP_ADAPTER_TYPE_ATTRS_TL does not reference any database object

XDP.XDP_ADAPTER_TYPE_ATTRS_TL is referenced by following:

APPS

SYNONYM - XDP_ADAPTER_TYPE_ATTRS_TL

[top of page]

Table: XDP_DEBUG

Primary Key: XDP_DEBUG_PK

1. EXEC_SEQ

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns

[top of page]

XDP.XDP_DEBUG does not reference any database object

XDP.XDP_DEBUG is referenced by following:

APPS

SYNONYM - XDP_DEBUG

[top of page]

Table: XDP_DQER_REGISTRATION

Primary Key: XDP_DQER_REGISTRATION_PK

1. DQER_NAME

Comments

XDP_DQER_REGISTRATION table is used for registering processes, generally referred as dqers, which are responsible for dequeuing messages from internal queues.

Indexes

Columns

[top of page]

XDP.XDP_DQER_REGISTRATION does not reference any database object

XDP.XDP_DQER_REGISTRATION is referenced by following:

APPS

SYNONYM - XDP_DQER_REGISTRATION

[top of page]

Table: XDP_DQ_CONFIGURATION

Primary Key: XDP_DQ_CONFIGURATION_PK

1. INTERNAL_Q_NAME

Primary Key: XDP_DQ_CONFIGURATION_UK1

1. Q_ALIAS

Foreign Keys to this table:

Comments

XDP_DQ_CONFIGURATION is a configuration table for application queues and is populated during the installation process. Number of dequeue processes per queue is user configurable and should only be modified using application user interface - Queue Console.

Indexes

Columns

[top of page]

XDP.XDP_DQ_CONFIGURATION does not reference any database object

XDP.XDP_DQ_CONFIGURATION is referenced by following:

APPS

SYNONYM - XDP_DQ_CONFIGURATION

[top of page]

Table: XDP_DQ_CONFIGURATION_TL

Primary Key: XDP_DQ_CONFIGURATION_TL_PK

1. INTERNAL_Q_NAME
2. LANGUAGE

Foreign Keys from this table:

Comments

XDP_DQ_CONFIGURATION_TL is a multi-lingual support table for the application queues and is populated by the installation process.

Indexes

Columns

[top of page]

XDP.XDP_DQ_CONFIGURATION_TL does not reference any database object

XDP.XDP_DQ_CONFIGURATION_TL is referenced by following:

APPS

SYNONYM - XDP_DQ_CONFIGURATION_TL

[top of page]

Table: XDP_DQ_EXCEPTIONS

Primary Key: XDP_DQ_EXCEPTIONS_PK

1. ERROR_REF_ID

Comments

XDP_DQ_EXCEPTIONS stores exceptions for application queues and is populated by application logic. Queue exceptions can be viewed using Queue Console.

Columns

[top of page]

XDP.XDP_DQ_EXCEPTIONS does not reference any database object

XDP.XDP_DQ_EXCEPTIONS is referenced by following:

APPS

SYNONYM - XDP_DQ_EXCEPTIONS

[top of page]

Table: XDP_ERRORS

Primary Key: XDP_ERRORS_PK

1. ERROR_ID

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

XDP.XDP_ERRORS does not reference any database object

XDP.XDP_ERRORS is referenced by following:

APPS

SYNONYM - XDP_ERRORS

[top of page]

Table: XDP_ERROR_COUNT

Comments

Stores number of times an error has occured for a certain instance of an object.

Columns

[top of page]

XDP.XDP_ERROR_COUNT does not reference any database object

XDP.XDP_ERROR_COUNT is referenced by following:

APPS

SYNONYM - XDP_ERROR_COUNT

[top of page]

Table: XDP_ERROR_LOG

Primary Key: XDP_ERROR_LOG_PK

1. ERROR_ID

Comments

Generically stores all persistent MLS compliant error messages belonging to different application entities (Order, Adapters, etc).

Indexes

Columns

[top of page]

XDP.XDP_ERROR_LOG does not reference any database object

XDP.XDP_ERROR_LOG is referenced by following:

APPS

SYNONYM - XDP_ERROR_LOG

[top of page]

Table: XDP_FA_DETAILS

Primary Key: XDP_FA_DETAILS_PK

1. FA_INSTANCE_ID
2. PARAMETER_NAME

Foreign Keys from this table:

Comments

XDP_FA_DETAILS is used to contain the runtime FA parameter values for an FA instance. The IS_VALUE_EVALUATED flag indicates the value stored here may be a result of the FA parameter evaluation procedure call.

Indexes

Columns

[top of page]

XDP.XDP_FA_DETAILS does not reference any database object

XDP.XDP_FA_DETAILS is referenced by following:

APPS

SYNONYM - XDP_FA_DETAILS

[top of page]

Table: XDP_FA_FULFILLMENT_PROC

Primary Key: XDP_FA_FULFILLMENT_PROC_PK

1. FA_FULFILLMENT_PROC_ID

Primary Key: XDP_FA_FULFILLMENT_PROC_UK1

1. FULFILLMENT_ACTION_ID
2. FE_SW_GEN_LOOKUP_ID

Foreign Keys from this table:

Comments

XDP_FA_FULFILLMENT_PROC is used to store the name of the Fulfillment Procedure (FP). The FP is a PL/SQL procedure where you can define your provisioning logic for a given Fulfillment Action (FA). The table allows you to map a Fulfillment Action to a Fulfillment Procedure based on the Fulfillment Element's (FE) software generic and the Adapter Type.
For example, FA 'ADD_ROUTER_SUBSCRIBER' is used to add a subscriber on a router.
Let's say router 4.0 provides JAVA script interface while router 3.0 supports only telnet interface.
The table allows you to define two different FPs for the same FA and SDP will execute the
appropriate FP at runtime based on the FE to be provisioned

Indexes

Columns

[top of page]

XDP.XDP_FA_FULFILLMENT_PROC does not reference any database object

XDP.XDP_FA_FULFILLMENT_PROC is referenced by following:

APPS

SYNONYM - XDP_FA_FULFILLMENT_PROC

[top of page]

Table: XDP_FA_PARAMETERS

Primary Key: XDP_FA_PARAMETERS_PK

1. FULFILLMENT_ACTION_ID
2. PARAMETER_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FA_PARAMETERS table allows you to define Fulfillment Action (FA) Parameters used in the Fulfillment Procedure.
The Evaluation Procedure can be used to specify the business logic for evaluating
a given FA Parameter.
One example may be an API call to decrypt sensitive data at runtime.

Indexes

Columns

[top of page]

XDP.XDP_FA_PARAMETERS does not reference any database object

XDP.XDP_FA_PARAMETERS is referenced by following:

APPS

SYNONYM - XDP_FA_PARAMETERS

[top of page]

Table: XDP_FA_RESUBMISSION_LOG

Primary Key: XDP_FA_RESUBMISSION_LOG_PK

1. RESUBMISSION_JOB_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FA_RESUBMISSION_LOG records the resubmission jobs for Oracle SFM. The Fulfillment Elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow.

Indexes

Columns

[top of page]

XDP.XDP_FA_RESUBMISSION_LOG does not reference any database object

XDP.XDP_FA_RESUBMISSION_LOG is referenced by following:

APPS

SYNONYM - XDP_FA_RESUBMISSION_LOG

[top of page]

Table: XDP_FA_RUNTIME_LIST

Primary Key: XDP_FA_RUNTIME_LIST_PK

1. FA_INSTANCE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FA_RUNTIME_LIST is used to contain the list of the FAs which need to be executed for a work item instance.

Indexes

Columns

[top of page]

XDP.XDP_FA_RUNTIME_LIST does not reference any database object

XDP.XDP_FA_RUNTIME_LIST is referenced by following:

APPS

SYNONYM - XDP_FA_RUNTIME_LIST

[top of page]

Table: XDP_FES

Primary Key: XDP_FES_PK

1. FE_ID

Primary Key: XDP_FES_UK1

1. FE_ID
2. FETYPE_ID

Primary Key: XDP_FES_UK2

1. FULFILLMENT_ELEMENT_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FES is used to contain all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a Fulfillment Element.
Example: FE or NE is a DMS200, a Cisco CPC, HA Server.

Indexes

Columns

[top of page]

XDP.XDP_FES does not reference any database object

XDP.XDP_FES is referenced by following:

APPS

SYNONYM - XDP_FES

[top of page]

Table: XDP_FES_TL

Primary Key: XDP_FES_TL_PK

1. FE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

XDP_FES_TL is the MLS (Multi-Language Support) for the XDP_ FES table.
You can define the display name as well as the description for a Fulfillment Element Name in multiple languages.

Indexes

Columns

[top of page]

XDP.XDP_FES_TL does not reference any database object

XDP.XDP_FES_TL is referenced by following:

APPS

SYNONYM - XDP_FES_TL

[top of page]

Table: XDP_FE_ATTRIBUTE_DEF

Primary Key: XDP_FE_ATTRIBUTE_DEF_PK

1. FE_ATTRIBUTE_ID

Primary Key: XDP_FE_ATTRIBUTE_DEF_UK1

1. FE_SW_GEN_LOOKUP_ID
2. FE_ATTRIBUTE_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FE_ATTRIBUTE_DEF contains the data definition for Oracle SDP Provisioning to communicate with a given type of Fulfillment Element.
Example: IP address for a Unix Fulfillment Element Type.

Indexes

Columns

[top of page]

XDP.XDP_FE_ATTRIBUTE_DEF does not reference any database object

XDP.XDP_FE_ATTRIBUTE_DEF is referenced by following:

APPS

SYNONYM - XDP_FE_ATTRIBUTE_DEF

[top of page]

Table: XDP_FE_ATTRIBUTE_DEF_TL

Primary Key: XDP_FE_ATTRIBUTE_DEF_TL_PK

1. FE_ATTRIBUTE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

XDP_FE_ATTRIBUTE_DEF_TL is the MLS (Multi-Language Support) for the XDP_ FE_ATTRIBUTE_DEF table. You can define the display name as well as the description for a given attribute name in multiple languages.

Indexes

Columns

[top of page]

XDP.XDP_FE_ATTRIBUTE_DEF_TL does not reference any database object

XDP.XDP_FE_ATTRIBUTE_DEF_TL is referenced by following:

APPS

SYNONYM - XDP_FE_ATTRIBUTE_DEF_TL

[top of page]

Table: XDP_FE_ATTRIBUTE_VAL

Primary Key: XDP_FE_ATTRIBUTE_VAL_PK

1. FE_ATTRIBUTE_ID
2. FE_GENERIC_CONFIG_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FE_ATTRTIBUTE_VAL contains the configuration data for Oracle SDP Provisioning to communicate with a given Fulfillment Element.
Example: 144.126.174.151 is the IP address for the logical name of 'FE 'ROUTER_NY'.

Indexes

Columns

[top of page]

XDP.XDP_FE_ATTRIBUTE_VAL does not reference any database object

XDP.XDP_FE_ATTRIBUTE_VAL is referenced by following:

APPS

SYNONYM - XDP_FE_ATTRIBUTE_VAL

[top of page]

Table: XDP_FE_ATTRIBUTE_VAL_TL

Primary Key: XDP_FE_ATTRIBUTE_VAL_TL_PK

1. FE_ATTRIBUTE_ID
2. FE_GENERIC_CONFIG_ID
3. LANGUAGE

Foreign Keys from this table:

Comments

XDP_FE_ATTRIBUTE_VAL_TL is the MLS (Multi-Language Support) for the XDP_FE_ATTRIBUTE_VAL table. You can define the display name as well as the description for a given Adapter Type in multiple languages.

Indexes

Columns

[top of page]

XDP.XDP_FE_ATTRIBUTE_VAL_TL does not reference any database object

XDP.XDP_FE_ATTRIBUTE_VAL_TL is referenced by following:

APPS

SYNONYM - XDP_FE_ATTRIBUTE_VAL_TL

[top of page]

Table: XDP_FE_CMD_AUD_TRAILS

Primary Key: XDP_FE_CMD_AUD_TRAILS_PK

1. FA_INSTANCE_ID
2. FE_COMMAND_SEQ

Foreign Keys from this table:

Comments

XDP_FE_CMD_AUDIT_TRAILS is the audit trail table.
All Oracle SDP Provisioning messages sent to an FE will be logged.
If a value contained in the message is of a sensitive nature, you are given the ability to flag a parameter value so that it will not be stored in the audit trail.
Example: Authentication Key A-Key in Celllular phones, customer's password, etc..

Indexes

Columns

[top of page]

XDP.XDP_FE_CMD_AUD_TRAILS does not reference any database object

XDP.XDP_FE_CMD_AUD_TRAILS is referenced by following:

APPS

SYNONYM - XDP_FE_CMD_AUD_TRAILS

[top of page]

Table: XDP_FE_GENERIC_CONFIG

Primary Key: XDP_FE_GENERIC_CONFIG_PK

1. FE_GENERIC_CONFIG_ID

Primary Key: XDP_FE_GENERIC_CONFIG_UK1

1. FE_ID
2. START_DATE

Primary Key: XDP_FE_GENERIC_CONFIG_UK2

1. FE_ID
2. FE_SW_GEN_LOOKUP_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FE_GENERIC_CONFIG is used to define all the available Software Generic for a Fulfillment Element. A Fulfillment Element can be running one Software Generic at one given time, but you can define future Software Generic in this table by specifying a future date on the Start Date attribute. Oracle SDP Provisioning will use the most recent Software Generic at the order process time.

Indexes

Columns

[top of page]

XDP.XDP_FE_GENERIC_CONFIG does not reference any database object

XDP.XDP_FE_GENERIC_CONFIG is referenced by following:

APPS

SYNONYM - XDP_FE_GENERIC_CONFIG

[top of page]

Table: XDP_FE_SW_GEN_LOOKUP

Primary Key: XDP_FE_SW_GEN_LOOKUP_PK

1. FE_SW_GEN_LOOKUP_ID

Primary Key: XDP_FE_SW_GEN_LOOKUP_UK1

1. FETYPE_ID
2. SW_GENERIC
3. ADAPTER_TYPE

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FE_SW_GENERIC_LOOKUP is the definition table for Software Generics. This table holds available Software Generics for a Fulfillment Element Type.

Indexes

Columns

[top of page]

XDP.XDP_FE_SW_GEN_LOOKUP does not reference any database object

XDP.XDP_FE_SW_GEN_LOOKUP is referenced by following:

APPS

SYNONYM - XDP_FE_SW_GEN_LOOKUP

[top of page]

Table: XDP_FE_SW_GEN_LOOKUP_TL

Primary Key: XDP_FE_SW_GEN_LOOKUP_TL_PK

1. FE_SW_GEN_LOOKUP_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

XDP_FE_SW_GEN_LOOKUP_TL is the MLS (Multi-Language Support ) table for XDP_FE_SW_GEN_LOOKUP. You can define the Display Name as well as the description for a given Fulfillment Element Type Software Generic in multiple languages.

Indexes

Columns

[top of page]

XDP.XDP_FE_SW_GEN_LOOKUP_TL does not reference any database object

XDP.XDP_FE_SW_GEN_LOOKUP_TL is referenced by following:

APPS

SYNONYM - XDP_FE_SW_GEN_LOOKUP_TL

[top of page]

Table: XDP_FE_TYPES

Primary Key: XDP_FE_TYPES_PK

1. FETYPE_ID

Primary Key: XDP_FE_TYPES_UK1

1. FULFILLMENT_ELEMENT_TYPE

Foreign Keys to this table:

Comments

XDP_FE_TYPES contains the definition of a Fulfillment Element Type. You can define the type of procedure ( e.g. Connect, Disconnect) to be executed by the Provisioning Engine when an Adapter tries to establish a connection to a Fulfillment Element of this Type.

Indexes

Columns

[top of page]

XDP.XDP_FE_TYPES does not reference any database object

XDP.XDP_FE_TYPES is referenced by following:

APPS

SYNONYM - XDP_FE_TYPES

[top of page]

Table: XDP_FE_TYPES_TL

Primary Key: XDP_FE_TYPES_TL_PK

1. FETYPE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

XDP_FE_TYPES_TL is the MLS (Multi-Language Support) table for XDP_FE_TYPES. You can define the Display Name as well as the Description for a given Fulfillment Element Type in multiple languages.

Indexes

Columns

[top of page]

XDP.XDP_FE_TYPES_TL does not reference any database object

XDP.XDP_FE_TYPES_TL is referenced by following:

APPS

SYNONYM - XDP_FE_TYPES_TL

[top of page]

Table: XDP_FMC_AUDIT_TRAILS

Primary Key: XDP_FMC_AUDIT_TRAILS_PK

1. FMC_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FMC_AUDIT_TRAIL is used to log all the notification responses for a given work item instance.
This table stores the reponses from the upstream system regarding a service fulfillment error.

Indexes

Columns

[top of page]

XDP.XDP_FMC_AUDIT_TRAILS does not reference any database object

XDP.XDP_FMC_AUDIT_TRAILS is referenced by following:

APPS

SYNONYM - XDP_FMC_AUDIT_TRAILS

[top of page]

Table: XDP_FMC_AUD_TRAIL_DETS

Primary Key: XDP_FMC_AUD_TRAIL_DETS_PK

1. FMC_ID
2. PARAMETER_TYPE
3. PARAMETER_NAME

Foreign Keys from this table:

Comments

XDP_FMC_AUD_TRAIL_DETS logs all the parameter value changes made in the notification messages module. The PARAMETER_TYPE column indicates the type of the parameter that is being modified. The valid parameter type definition is as followed:
ORDER -- The parameter is an order parameter;
WORKITEM -- The parameter is a work item parameter;
FA -- The parameter is a fulfillment action parameter

Indexes

Columns

[top of page]

XDP.XDP_FMC_AUD_TRAIL_DETS does not reference any database object

XDP.XDP_FMC_AUD_TRAIL_DETS is referenced by following:

APPS

SYNONYM - XDP_FMC_AUD_TRAIL_DETS

[top of page]

Table: XDP_FULFILL_ACTIONS

Primary Key: XDP_FULFILL_ACTIONS_PK

1. FULFILLMENT_ACTION_ID

Primary Key: XDP_FULFILL_ACTIONS_UK1

1. FULFILLMENT_ACTION
2. VERSION

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FULFILL_ACTIONS contains the definition for a provisioning activity on a Fulfillment Element -this is equivalent to a Fulfillment Action. The attribute FE_ROUTING_PROC allows you to define the business logic in order to locate the targeted FE for the provisioning activity in a PL/SQL procedure.
Example: You can query the network inventory database for a given phone number and the system returns the
switch id for this phone number to be provisioned. At runtime, Oracle SDP Provisioning will execute this procedure
(based on the FE configuration data) in order to determine the correct Fulfillment Procedure to be used for this FA.

Indexes

Columns

[top of page]

XDP.XDP_FULFILL_ACTIONS does not reference any database object

XDP.XDP_FULFILL_ACTIONS is referenced by following:

APPS

SYNONYM - XDP_FULFILL_ACTIONS

[top of page]

Table: XDP_FULFILL_ACTIONS_TL

Primary Key: XDP_FULFILL_ACTIONS_TL_PK

1. FULFILLMENT_ACTION_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

XDP_FULFILLMENT_ACTIONS_TL is the MLS (Multi-Language Support) table for the XDP_ FULFILLMENT_ACTIONS table.
You can define the display name as well as the description for a given Fulfillment Action in multiple languages.

Indexes

Columns

[top of page]

XDP.XDP_FULFILL_ACTIONS_TL does not reference any database object

XDP.XDP_FULFILL_ACTIONS_TL is referenced by following:

APPS

SYNONYM - XDP_FULFILL_ACTIONS_TL

[top of page]

Table: XDP_FULFILL_WORKLIST

Primary Key: XDP_FULFILL_WORKLIST_PK

1. WORKITEM_INSTANCE_ID

Primary Key: XDP_FULFILL_WORKLIST_UK1

1. WORKITEM_INSTANCE_ID
2. WORKITEM_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

XDP_FULFILL_WORKLIST contains the list of all work items to be executed for a given order by the order processor.
Work items with the lowest fulfillment sequence number is executed first.
All work items in the list that have the same fulfillment sequence number are executed
in parallel.
It is possible to have work items sequence number to be executed in parallel or sequential or a combination of both.
Example: W1 1, W2 1, W3 2, W4 3, W5 3 => combination of sequential and parallel order execution, W1 and W2 are executed in parallel and W3 is not execute until W1 and W2 have completed. Then W4 and W5 will be executed.

Indexes

Columns

[top of page]

XDP.XDP_FULFILL_WORKLIST does not reference any database object

XDP.XDP_FULFILL_WORKLIST is referenced by following:

APPS

SYNONYM - XDP_FULFILL_WORKLIST

[top of page]

Table: XDP_LINE_RELATIONSHIPS

Primary Key: XDP_LINE_RELATIONSHIPS_PK

1. LINE_ITEM_ID
2. RELATED_LINE_ITEM_ID

Foreign Keys from this table:

Comments

XDP_LINE_RELATIONSHIPS is used to identify whether a line item is part of a package line.
This table tracks the relationship between all of Line Items associated with a package within an order.

Indexes

Columns

[top of page]

XDP.XDP_LINE_RELATIONSHIPS does not reference any database object

XDP.XDP_LINE_RELATIONSHIPS is referenced by following:

APPS

SYNONYM - XDP_LINE_RELATIONSHIPS

[top of page]

Table: XDP_OE_ORDER_HEADERS

Primary Key: XDP_OE_ORDER_HEADERS_UK

1. ORDER_NUMBER
2. ORDER_VERSION

Foreign Keys to this table:

Comments

XDP_OE_ORDER_HEADERS contains the order header information for orders generated by Oracle SFM -Order Entry Interface.

Indexes

Columns