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: AR.HZ_ADAPTERS

Object Details

Object Name:	HZ_ADAPTERS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_ADAPTERS
Subobject Name:
Status:	VALID

The HZ_ADAPTERS table stores information about the adapters that are configured to provide data integration services, such as address validation. The stored information includes whether the adapter is enabled or not, the method that the service is invoked, and the message format of the service

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_ADAPTERS_U1	NORMAL	UNIQUE	APPS_TS_SEED	ADAPTER_ID
HZ_ADAPTERS_U2	NORMAL	UNIQUE	APPS_TS_SEED	ADAPTER_CONTENT_SOURCE

Columns

Name	Datatype	Length	Mandatory	Comments
ADAPTER_ID	NUMBER	(15)	Yes	The number that uniquely identifies this adapter
ADAPTER_CONTENT_SOURCE	VARCHAR2	(30)	Yes	The content source that uniquely identifies this adapter.
ENABLED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the adapter is enabled or not. Y denotes enabled, N denotes disabled
SYNCHRONOUS_FLAG	VARCHAR2	(1)	Yes	Identifies whether the service is synchronous or asynchronous. Y denotes synchronous, N denotes asynchronous.
INVOKE_METHOD_CODE	VARCHAR2	(30)	Yes	Identifies the communication method in which the service is invoked, for example, HTTP
MESSAGE_FORMAT_CODE	VARCHAR2	(30)	Yes	Identifies the format of the message used for this service.
HOST_ADDRESS	VARCHAR2	(240)		The hostname address of the adapter providing the service
USERNAME	VARCHAR2	(100)		The username to be passed to a service that requires authentication.
ENCRYPTED_PASSWORD	VARCHAR2	(100)		The password to be passed to a service that requires authentication
MAXIMUM_BATCH_SIZE	NUMBER		Yes	The maximum number of records that the adapter can handle in a single batch
DEFAULT_BATCH_SIZE	NUMBER		Yes	The default batch size to be used if the maximum batch size is not desired
DEFAULT_REPLACE_STATUS_LEVEL	VARCHAR2	(30)		Indicates the default service status code that must be exceeded before a record is updated with the data from the service
OBJECT_VERSION_NUMBER	NUMBER		Yes	Version number for locking purposes
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
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
ADAPTER_TYPE	VARCHAR2	(30)		Adapter type

Query Text

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


SELECT ADAPTER_ID
,      ADAPTER_CONTENT_SOURCE
,      ENABLED_FLAG
,      SYNCHRONOUS_FLAG
,      INVOKE_METHOD_CODE
,      MESSAGE_FORMAT_CODE
,      HOST_ADDRESS
,      USERNAME
,      ENCRYPTED_PASSWORD
,      MAXIMUM_BATCH_SIZE
,      DEFAULT_BATCH_SIZE
,      DEFAULT_REPLACE_STATUS_LEVEL
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ADAPTER_TYPE
FROM AR.HZ_ADAPTERS;

Dependencies

[top of page]

AR.HZ_ADAPTERS does not reference any database object

AR.HZ_ADAPTERS is referenced by following:

APPS: HZ_ADAPTERS