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: PSP.PSP_REPORT_ERRORS

Object Details

Object Name:	PSP_REPORT_ERRORS
Object Type:	TABLE
Owner:	PSP
FND Design Data:	PSP.PSP_REPORT_ERRORS
Subobject Name:
Status:	VALID

PSP_REPORT_ERROR stores various errors message at varioue levels of effort report creation unlike PSP_EFFORT_REPORT which is confined at person level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSP_REPORT_ERRORS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ERROR_SEQUENCE_ID
PSP_REPORT_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
PSP_REPORT_ERRORS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ACTION_ID REQUEST_ID
PSP_REPORT_ERRORS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ACTION_ID SOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ERROR_SEQUENCE_ID	VARCHAR2	(240)	Yes	Error Sequence Identifier
REQUEST_ID	NUMBER		Yes	Request Identifier
MESSAGE_LEVEL	VARCHAR2	(1)	Yes	Message Level (E-Error, W-Warning)
SOURCE_ID	NUMBER	(15)		Source Identifier
ERROR_MESSAGE	VARCHAR2	(2000)	Yes	Error Message
RETRY_REQUEST_ID	NUMBER	(15)		Process retry request id
PDF_REQUEST_ID	NUMBER	(15)		PDF Generation process request id
SOURCE_NAME	VARCHAR2	(1000)		Source Name
PARENT_SOURCE_ID	NUMBER	(15)		Parent Source Id
PARENT_SOURCE_NAME	VARCHAR2	(1000)		Parent Source Name
PAYROLL_ACTION_ID	NUMBER			Foreign key for PAY_PAYROLL_ACTIONS
VALUE1	NUMBER			Stores Additional Number Value
VALUE2	NUMBER			Stores Additional Number Value
VALUE3	NUMBER			Stores Additional Number Value
VALUE4	NUMBER			Stores Additional Number Value
VALUE5	NUMBER			Stores Additional Number Value
VALUE6	NUMBER			Stores Additional Number Value
VALUE7	NUMBER			Stores Additional Number Value
VALUE8	NUMBER			Stores Additional Number Value
VALUE9	NUMBER			Stores Additional Number Value
VALUE10	NUMBER			Stores Additional Number Value
INFORMATION1	VARCHAR2	(1000)		Stores Additional Information
INFORMATION2	VARCHAR2	(1000)		Stores Additional Information
INFORMATION3	VARCHAR2	(1000)		Stores Additional Information
INFORMATION4	VARCHAR2	(1000)		Stores Additional Information
INFORMATION5	VARCHAR2	(1000)		Stores Additional Information
INFORMATION6	VARCHAR2	(1000)		Stores Additional Information
INFORMATION7	VARCHAR2	(1000)		Stores Additional Information
INFORMATION8	VARCHAR2	(1000)		Stores Additional Information
INFORMATION9	VARCHAR2	(1000)		Stores Additional Information
INFORMATION10	VARCHAR2	(1000)		Stores Additional Information

Query Text

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


SELECT ERROR_SEQUENCE_ID
,      REQUEST_ID
,      MESSAGE_LEVEL
,      SOURCE_ID
,      ERROR_MESSAGE
,      RETRY_REQUEST_ID
,      PDF_REQUEST_ID
,      SOURCE_NAME
,      PARENT_SOURCE_ID
,      PARENT_SOURCE_NAME
,      PAYROLL_ACTION_ID
,      VALUE1
,      VALUE2
,      VALUE3
,      VALUE4
,      VALUE5
,      VALUE6
,      VALUE7
,      VALUE8
,      VALUE9
,      VALUE10
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
FROM PSP.PSP_REPORT_ERRORS;

Dependencies

[top of page]

PSP.PSP_REPORT_ERRORS does not reference any database object

PSP.PSP_REPORT_ERRORS is referenced by following:

APPS: PSP_REPORT_ERRORS