eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: XDP.XDP_ADAPTER_REG

Object Details

Object Name:	XDP_ADAPTER_REG
Object Type:	TABLE
Owner:	XDP
FND Design Data:	XDP.XDP_ADAPTER_REG
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XDP_ADAPTER_REG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHANNEL_NAME
XDP_ADAPTER_REG_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADAPTER_DISPLAY_NAME
XDP_ADAPTER_REG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHANNEL_NAME	VARCHAR2	(40)	Yes	Adapter communication channel ID
FE_ID	NUMBER		Yes	Fulfillment Element identifier
ADAPTER_STATUS	VARCHAR2	(40)	Yes	Current status of the NEM. Valid status will be IDLE, BUSY, SHUTDOWN, SUSPENDED, DISCONNECTED, and ERROR.
PROCESS_ID	NUMBER		Yes	OS process ID for the Adapter
USAGE_CODE	VARCHAR2	(40)	Yes	Internal Code representing the usage of the adapter
STARTUP_MODE	VARCHAR2	(20)	Yes	Internal Code representing the startup mode of the adapter
DEBUG_MODE	VARCHAR2	(40)		Not Used
STATUS_ACTIVE_TIME	DATE			Not Used
ADAPTER_NAME	VARCHAR2	(40)	Yes	System Generated Name. Editable only in the case of Messaging Adapters
WF_ITEM_TYPE	VARCHAR2	(8)		Item type of the workflow for the adapter
WF_ITEM_KEY	VARCHAR2	(240)		Item key of the workflow for the adapter
WF_ACTIVITY_NAME	VARCHAR2	(40)		Activity name of the workflow for the adapter
NODE	VARCHAR2	(40)		Not Used
ERROR_REF_ID	NUMBER			Not Used
CREATED_BY	NUMBER	(15)	Yes	Standard who columns
CREATION_DATE	DATE		Yes	Standard who columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who columns
LAST_UPDATE_DATE	DATE		Yes	Standard who columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who columns
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ADAPTER_DISPLAY_NAME	VARCHAR2	(80)	Yes	User defined Name of the Adapter
ADAPTER_TYPE	VARCHAR2	(40)	Yes	Adapter Type of the Instance
SERVICE_INSTANCE_ID	NUMBER		Yes	Identifies Controller Service (Node) to use for starting Adapter
APPLICATION_ID	NUMBER	(15)	Yes	Application Identifier
CMD_LINE_OPTIONS	VARCHAR2	(240)		System properties for the Adapter instance in addition to the ones defined for the Adapter Type
CMD_LINE_ARGS	VARCHAR2	(240)		Command line arguments for the Adapter instance in addition to the ones defined for the Adapter Type
CONNECT_ON_DEMAND_FLAG	VARCHAR2	(1)	Yes	Indicates whether Deferred Connection is enabled or not
MAX_IDLE_TIME_MINUTES	NUMBER			Disconnect-if-idle time in minutes
SEQ_IN_FE	NUMBER			Display / usage sequence within the FE
LOG_LEVEL	VARCHAR2	(40)	Yes	AFLOG logging level for the Adapter instance
LOG_FILE_NAME	VARCHAR2	(240)		To be used by AFLOG. Default value is ADAPTER_NAME. NULL value indicates that the log will go to the database
LAST_VERIFIED_TIME	DATE			Time the Adapter instance was last verified
OBJECT_VERSION_NUMBER	NUMBER			Column required for stateless UI support

Query Text

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


SELECT CHANNEL_NAME
,      FE_ID
,      ADAPTER_STATUS
,      PROCESS_ID
,      USAGE_CODE
,      STARTUP_MODE
,      DEBUG_MODE
,      STATUS_ACTIVE_TIME
,      ADAPTER_NAME
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      WF_ACTIVITY_NAME
,      NODE
,      ERROR_REF_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ADAPTER_DISPLAY_NAME
,      ADAPTER_TYPE
,      SERVICE_INSTANCE_ID
,      APPLICATION_ID
,      CMD_LINE_OPTIONS
,      CMD_LINE_ARGS
,      CONNECT_ON_DEMAND_FLAG
,      MAX_IDLE_TIME_MINUTES
,      SEQ_IN_FE
,      LOG_LEVEL
,      LOG_FILE_NAME
,      LAST_VERIFIED_TIME
,      OBJECT_VERSION_NUMBER
FROM XDP.XDP_ADAPTER_REG;

Dependencies

[top of page]

XDP.XDP_ADAPTER_REG does not reference any database object

XDP.XDP_ADAPTER_REG is referenced by following:

APPS: XDP_ADAPTER_REG