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

TABLE: JA.JAI_INTERFACE_ERR_LINES

Object Details
Object Name: JAI_INTERFACE_ERR_LINES
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_INTERFACE_ERR_LINES
Subobject Name:
Status: VALID


This is an error logging table to log the errors during the validation of OFI tax import concurrent, India Interface Tax Import


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_INTERFACE_ERR_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_ERROR_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ERROR_ID NUMBER
Yes Interface Error ID
INTERFACE_LINE_ID NUMBER

Interface Line ID
INTERFACE_SOURCE_LINE_ID NUMBER
Yes Source line id
ERROR_TYPE VARCHAR2 (20) Yes LINE or TAX
ERROR_MESSAGE VARCHAR2 (2000)
Error Message Name
INVALID_VALUE VARCHAR2 (240)
Invalid Value
ATTRIBUTE1 VARCHAR2 (150)
Other Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Other Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Other Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Other Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Other Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Other Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Other Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Other Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Other Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Other Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Other Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Other Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Other Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Other Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Other Attribute15
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
REQUEST_ID NUMBER

Program request id
CREATION_DATE DATE
Yes Creation date
CREATED_BY NUMBER
Yes Created By
LAST_UPDATE_DATE DATE
Yes Last update date
LAST_UPDATE_LOGIN NUMBER
Yes Last update login
LAST_UPDATED_BY NUMBER
Yes Last updated by
Query Text

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


SELECT INTERFACE_ERROR_ID
,      INTERFACE_LINE_ID
,      INTERFACE_SOURCE_LINE_ID
,      ERROR_TYPE
,      ERROR_MESSAGE
,      INVALID_VALUE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      REQUEST_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM JA.JAI_INTERFACE_ERR_LINES;

Dependencies

[top of page]

JA.JAI_INTERFACE_ERR_LINES does not reference any database object

JA.JAI_INTERFACE_ERR_LINES is referenced by following:

SchemaJA
ViewJAI_INTERFACE_ERR_LINES#