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.GHR_PA_INTERFACE_ERR_DTLS

Object Details

Object Name:	GHR_PA_INTERFACE_ERR_DTLS
Object Type:	TABLE
Owner:	HR
FND Design Data:	GHR.GHR_PA_INTERFACE_ERR_DTLS
Subobject Name:
Status:	VALID

GHR_PA_INTERFACE_ERR_DTLS stores the error details during NFC RPA interface generation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_PA_INTERFACE_ERR_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PA_INTERFACE_ERR_DTL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PA_INTERFACE_ERR_DTL_ID	NUMBER	(15)	Yes	Primary Key generated from GHR_PA_INTERFACE_ERR_DTLS_S
EXT_REQUEST_ID	NUMBER	(15)		Extracted PA Request ID
RESULT_ID	NUMBER	(15)		Result ID
RESULT_DTL_ID	NUMBER	(15)		Result Detail ID
RECORD_ID	NUMBER	(15)		Record ID
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group ID
PERSON_ID	NUMBER	(15)		Person ID
ASSIGNMENT_ID	NUMBER	(15)		Assignment ID
PA_REQUEST_ID	NUMBER	(15)		PA Request ID
ALT_PA_REQUEST_ID	NUMBER	(15)		Altered PA Request ID
ERR_SSN_NO	VARCHAR2	(30)		SSN Number of Errored Record
ERR_AGENCY	VARCHAR2	(30)		Agency of Errored Record
ERR_EMP_OFF	VARCHAR2	(30)		Employee Office of Errored Record
ERR_DEPT_CODE	VARCHAR2	(30)		Department Code of Errored Record
ERR_DOC_TYPE	VARCHAR2	(30)		Document Type of Errored Record
ERR_PAY_PERIOD	VARCHAR2	(30)		Pay Period of Errored Record
ERR_AUTH_DT	VARCHAR2	(16)		Authorised date of Errored Record
NAT_ACT_1ST_3_POS	VARCHAR2	(3)		First 3 Characters of First NOA Code
NAT_ACT_2ND_3_POS	VARCHAR2	(3)		First 3 Characters of Second NOA Code
ERR_EFF_DT	VARCHAR2	(16)		Effective Date of Errored Record
ERR_BATCH_NO	VARCHAR2	(20)		Batch Number of of Errored Record
ERR_OPER_CODE	VARCHAR2	(30)		Oper. Code of Errored Record
ERROR_CODE	VARCHAR2	(20)		Error Code
ERROR_MSG	VARCHAR2	(50)		Error Message
ERROR_ELEMENT_NAME	VARCHAR2	(30)		Element Name of Errored Record
ERROR_ELEM_CONTENT	VARCHAR2	(30)		Elemenet Content of Errored Record
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT PA_INTERFACE_ERR_DTL_ID
,      EXT_REQUEST_ID
,      RESULT_ID
,      RESULT_DTL_ID
,      RECORD_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      PA_REQUEST_ID
,      ALT_PA_REQUEST_ID
,      ERR_SSN_NO
,      ERR_AGENCY
,      ERR_EMP_OFF
,      ERR_DEPT_CODE
,      ERR_DOC_TYPE
,      ERR_PAY_PERIOD
,      ERR_AUTH_DT
,      NAT_ACT_1ST_3_POS
,      NAT_ACT_2ND_3_POS
,      ERR_EFF_DT
,      ERR_BATCH_NO
,      ERR_OPER_CODE
,      ERROR_CODE
,      ERROR_MSG
,      ERROR_ELEMENT_NAME
,      ERROR_ELEM_CONTENT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM HR.GHR_PA_INTERFACE_ERR_DTLS;

Dependencies

[top of page]

HR.GHR_PA_INTERFACE_ERR_DTLS does not reference any database object

HR.GHR_PA_INTERFACE_ERR_DTLS is referenced by following:

HR: GHR_PA_INTERFACE_ERR_DTLS#