[Home] [Help] [Dependency Information]
Object Name: | XDP_FULFILL_ACTIONS |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | XDP.XDP_FULFILL_ACTIONS |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XDP_FULFILL_ACTIONS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | FULFILLMENT_ACTION_ID |
XDP_FULFILL_ACTIONS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
FULFILLMENT_ACTION
VERSION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FULFILLMENT_ACTION_ID | NUMBER | Yes | Fulfillment Action identifier | |
FULFILLMENT_ACTION | VARCHAR2 | (40) | Yes | Fulfillment Action internal name |
VERSION | VARCHAR2 | (40) | Yes | Version of the Fulfillment Action |
FE_ROUTING_PROC | VARCHAR2 | (80) | Routing Procedure to locate the targeted Fulfillment Element | |
EVALUATE_PARAM_PROC | VARCHAR2 | (80) | Procedure to evaluate all the Fulfillment Action Parameters | |
FA_TYPE_CODE | VARCHAR2 | (40) | Reserved for future use | |
ROLE_NAME | VARCHAR2 | (100) | Group to be notified if problem occurs with the Fulfillment Action. | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT FULFILLMENT_ACTION_ID
, FULFILLMENT_ACTION
, VERSION
, FE_ROUTING_PROC
, EVALUATE_PARAM_PROC
, FA_TYPE_CODE
, ROLE_NAME
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XDP.XDP_FULFILL_ACTIONS;
XDP.XDP_FULFILL_ACTIONS does not reference any database object
XDP.XDP_FULFILL_ACTIONS is referenced by following:
|
|
|