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: HXT.HXT_ERRORS_F

Object Details

Object Name:	HXT_ERRORS_F
Object Type:	TABLE
Owner:	HXT
FND Design Data:	HXT.HXT_ERRORS_F
Subobject Name:
Status:	VALID

Table for storing errors encountered (ex. Auto-Gen process or timecard
entry).
User can view only hours worked records with STATUS=E. The error
message presented will aid the user in resolving timecard errors in
preparation for batch submittal to HRMS payroll. Once errors are
corrected the error record will be removed from this table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXT_ERRORS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
HXT_ERRORS_FK1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	HRW_ID
HXT_ERRORS_FK2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PPB_ID
HXT_ERRORS_FK3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PTP_ID
HXT_ERRORS_F_TIM_FK	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TIM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER	(15)	Yes	System generated primary key
ERROR_MSG	VARCHAR2	(240)	Yes	Specific error message
LOCATION	VARCHAR2	(120)	Yes	Procedure or Function where error occurred. If any.
ERR_TYPE	VARCHAR2	(3)		Identifies the error source.
TIM_ID	NUMBER	(15)		Timecard foreign key
HRW_ID	NUMBER	(15)		Hours worked foreign key
PTP_ID	NUMBER	(15)		Per time period foreign key
ORA_MESSAGE	VARCHAR2	(120)		ORACLE error NUMBER and MESSAGE
PPB_ID	NUMBER	(15)		Pay Pdt Batch Headers foreign key
EFFECTIVE_END_DATE	DATE		Yes	Effective End Date
CREATED_BY	NUMBER	(15)		Standard Who Column.
EFFECTIVE_START_DATE	DATE		Yes	Effective Start Date
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column.
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column.
CREATION_DATE	DATE			Date time the error occurred
PAYROLL_ID	NUMBER	(9)		Foreign key to PAY_PAYROLLS.
PERSON_ID	NUMBER	(10)		Foreign key to PER_PEOPLE.

Query Text

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


SELECT ID
,      ERROR_MSG
,      LOCATION
,      ERR_TYPE
,      TIM_ID
,      HRW_ID
,      PTP_ID
,      ORA_MESSAGE
,      PPB_ID
,      EFFECTIVE_END_DATE
,      CREATED_BY
,      EFFECTIVE_START_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      PAYROLL_ID
,      PERSON_ID
FROM HXT.HXT_ERRORS_F;

Dependencies

[top of page]

HXT.HXT_ERRORS_F does not reference any database object

HXT.HXT_ERRORS_F is referenced by following:

APPS: HXT_ERRORS_F; HXT_ERRORS_F_WHO