DBA Data[Home] [Help] [Dependency Information]

TABLE: XDP.XDP_FE_CMD_AUD_TRAILS

Object Details
Object Name: XDP_FE_CMD_AUD_TRAILS
Object Type: TABLE
Owner: XDP
FND Design Data: TableXDP.XDP_FE_CMD_AUD_TRAILS
Subobject Name:
Status: VALID


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..


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000086222C00019$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
XDP_FE_CMD_AUD_TRAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFA_INSTANCE_ID
ColumnFE_COMMAND_SEQ
Columns
Name Datatype Length Mandatory Comments
FA_INSTANCE_ID NUMBER
Yes Fulfillment Action instance identifier
FE_COMMAND_SEQ NUMBER
Yes Fulfillment element command sequence number
FULFILLMENT_ELEMENT_NAME VARCHAR2 (40) Yes Name of the fulfillment element
FULFILLMENT_ELEMENT_TYPE VARCHAR2 (40) Yes Fulfillment element type
SW_GENERIC VARCHAR2 (40) Yes Software Generic
COMMAND_SENT VARCHAR2 (4000)
Command Sent to the Network Element
COMMAND_SENT_DATE DATE

Date command sent to NE
RESPONSE VARCHAR2 (4000)
Response received from FE
USER_RESPONSE VARCHAR2 (4000)
User Response
RESPONSE_DATE DATE

Date of response from the Network Element
MSG_ID NUMBER

unique identifier of the message
PROVISIONING_PROCEDURE VARCHAR2 (80)
The name of the activation procedure which sends this command
CREATED_BY NUMBER (15) Yes Standard who Column
CREATION_DATE DATE
Yes Standard who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard who Column
LAST_UPDATE_DATE DATE
Yes Standard who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who Column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RESPONSE_LONG CLOB (4000)
Response received from FE (to be used when more than 4000 characters are needed to hold the response)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FA_INSTANCE_ID
,      FE_COMMAND_SEQ
,      FULFILLMENT_ELEMENT_NAME
,      FULFILLMENT_ELEMENT_TYPE
,      SW_GENERIC
,      COMMAND_SENT
,      COMMAND_SENT_DATE
,      RESPONSE
,      USER_RESPONSE
,      RESPONSE_DATE
,      MSG_ID
,      PROVISIONING_PROCEDURE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      RESPONSE_LONG
FROM XDP.XDP_FE_CMD_AUD_TRAILS;

Dependencies

[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:

SchemaAPPS
SynonymXDP_FE_CMD_AUD_TRAILS