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_API_USER_HOOK_REPORTS

Object Details

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

When the API user hook pre-processor program is being executed this
table will contain data. It is used as a temporary store of error
conditions. Rows will be output to the user at the end of the
pre-processor program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_API_USER_HOOK_REPORTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SESSION_ID LINE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER	(15)	Yes	Session_id for the hook report.
LINE	NUMBER	(15)	Yes	Primary Key, order sequence number.
TEXT	VARCHAR2	(2000)		Text for user.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT SESSION_ID
,      LINE
,      TEXT
,      ZD_EDITION_NAME
FROM HR.HR_API_USER_HOOK_REPORTS;

Dependencies

[top of page]

HR.HR_API_USER_HOOK_REPORTS does not reference any database object

HR.HR_API_USER_HOOK_REPORTS is referenced by following:

HR: HR_API_USER_HOOK_REPORTS#