DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.HR_API_BATCH_MESSAGE_LINES

Object Details
Object Name: HR_API_BATCH_MESSAGE_LINES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_API_BATCH_MESSAGE_LINES
Subobject Name:
Status: VALID


HR_API_BATCH_MESSAGE_LINES holds the results and messages generated
during batch API processing.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_API_BATCH_MESSAGE_LINES_PK
  1. ColumnLINE_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_API_BATCH_MESSAGE_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
HR_API_BATCH_MESSAGE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_RUN_NUMBER
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER (9) Yes System-generated primary key column.
API_NAME VARCHAR2 (61) Yes Name of the API.
BATCH_RUN_NUMBER NUMBER (9) Yes Indicates the batch run for the line.
STATUS VARCHAR2 (30) Yes Indicates whether the API call succeeded or failed.
ERROR_MESSAGE VARCHAR2 (512)
Holds the SQLERRM if STATUS = Fail.
ERROR_NUMBER NUMBER (9)
Holds the SQLCODE if STATUS = Fail.
EXTENDED_ERROR_MESSAGE VARCHAR2 (2000)
Holds the extended message text if STATUS = Fail.
SOURCE_ROW_INFORMATION VARCHAR2 (2000)
Free text that uniquely identifies the source row information.
SECURITY_GROUP_ID NUMBER (15)
Foreign Key to FND_SECURITY_GROUPS.
Query Text

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


SELECT LINE_ID
,      API_NAME
,      BATCH_RUN_NUMBER
,      STATUS
,      ERROR_MESSAGE
,      ERROR_NUMBER
,      EXTENDED_ERROR_MESSAGE
,      SOURCE_ROW_INFORMATION
,      SECURITY_GROUP_ID
FROM HR.HR_API_BATCH_MESSAGE_LINES;

Dependencies

[top of page]

HR.HR_API_BATCH_MESSAGE_LINES does not reference any database object

HR.HR_API_BATCH_MESSAGE_LINES is referenced by following:

SchemaAPPS
SynonymHR_API_BATCH_MESSAGE_LINES
SchemaPUBLIC
SynonymHR_API_BATCH_MESSAGE_LINES