[Home] [Help] [Dependency Information]
Object Name: | XDP_FA_FULFILLMENT_PROC |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | XDP.XDP_FA_FULFILLMENT_PROC |
Subobject Name: | |
Status: | VALID |
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
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XDP_FULFILLMENT_PROC_U1 | NORMAL | UNIQUE | APPS_TS_SEED | FA_FULFILLMENT_PROC_ID |
XDP_FULFILLMENT_PROC_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
FULFILLMENT_ACTION_ID
FE_SW_GEN_LOOKUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FA_FULFILLMENT_PROC_ID | NUMBER | Yes | Fulfillment Action Fulfillment Procedure Identifier | |
FULFILLMENT_ACTION_ID | NUMBER | Yes | Fulfillment Action Identifier for which Fulfillment Procedure is defined | |
FE_SW_GEN_LOOKUP_ID | NUMBER | Yes | Software Generic Identifier to which the Fulfillment Procedure is defined | |
FULFILLMENT_PROC | VARCHAR2 | (80) | Fulfillment procedure internal name | |
UNDO_PROVISIONING_PROC | VARCHAR2 | (80) | Reserved for Future Use | |
TEST_PROVISIONING_PROC | VARCHAR2 | (80) | Reserved for Future Use | |
PROTECTED_FLAG | VARCHAR2 | (1) | Yes | Flag to indiacte this fulfillment procedure is protected against update |
CREATION_DATE | DATE | Yes | Standard who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard who Column | |
LAST_UPDATED_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 FA_FULFILLMENT_PROC_ID
, FULFILLMENT_ACTION_ID
, FE_SW_GEN_LOOKUP_ID
, FULFILLMENT_PROC
, UNDO_PROVISIONING_PROC
, TEST_PROVISIONING_PROC
, PROTECTED_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XDP.XDP_FA_FULFILLMENT_PROC;
XDP.XDP_FA_FULFILLMENT_PROC does not reference any database object
XDP.XDP_FA_FULFILLMENT_PROC is referenced by following:
|
|
|