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: HR.HR_PUMP_BATCH_EXCEPTIONS

Object Details

Object Name:	HR_PUMP_BATCH_EXCEPTIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_PUMP_BATCH_EXCEPTIONS
Subobject Name:
Status:	VALID

HR_PUMP_BATCH_EXCEPTIONS holds details of exception (error or warning) messages that may result from running data pump.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: HR_PUMP_BATCH_EXCEPTIONS_PK

EXCEPTION_SEQUENCE

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_PUMP_BATCH_EXCEPTIONS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	EXCEPTION_SEQUENCE
HR_PUMP_BATCH_EXCEPTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SOURCE_ID SOURCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_LEVEL	VARCHAR2	(1)	Yes	Indicates the severity of the exception.
EXCEPTION_SEQUENCE	NUMBER	(15)	Yes	Sequence number generated using HR_PUMP_BATCH_EXCEPTIONS_S.
EXCEPTION_TEXT	VARCHAR2	(2000)		The exception message text.
FORMAT	VARCHAR2	(30)	Yes	The format in which the message text is held.
SOURCE_ID	NUMBER	(15)	Yes	Foreign key value for the message source table.
SOURCE_TYPE	VARCHAR2	(30)	Yes	Specifies the source of the exception.

Query Text

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


SELECT EXCEPTION_LEVEL
,      EXCEPTION_SEQUENCE
,      EXCEPTION_TEXT
,      FORMAT
,      SOURCE_ID
,      SOURCE_TYPE
FROM HR.HR_PUMP_BATCH_EXCEPTIONS;

Dependencies

[top of page]

HR.HR_PUMP_BATCH_EXCEPTIONS does not reference any database object

HR.HR_PUMP_BATCH_EXCEPTIONS is referenced by following:

HR: HR_PUMP_BATCH_EXCEPTIONS#