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: ICX.ICX_POR_FAILED_LINE_MESSAGES

Object Details

Object Name:	ICX_POR_FAILED_LINE_MESSAGES
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_POR_FAILED_LINE_MESSAGES
Subobject Name:
Status:	VALID

Maintains information about items/prices/schema elements that the loader rejected during a load job. In particular it stores the data that caused the rejection. This information is used to report the errors to the user. For any rejected line there may exist multiple error messages.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_FAILED_LINE_MSGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_NUMBER LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_NUMBER	NUMBER		Yes	Internally generated identifier for the batch process.
LINE_NUMBER	NUMBER		Yes	Line number rejected during the load.
DESCRIPTOR_KEY	VARCHAR2	(250)	Yes	Key for the descriptor causing the rejection if any.
MESSAGE_NAME	VARCHAR2	(30)	Yes	Name of the message describing the cause for the rejection.
TOKEN_LIST	VARCHAR2	(4000)		token list
REQUEST_ID	NUMBER			Standard Concurrent Request Column: Identifies the concurrent request instance that spawned the concurrent program
PROGRAM_APPLICATION_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Application that spawned the concurrent program
PROGRAM_ID	NUMBER			Standard Concurrent Request Column: Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Applications Concurrent Program Login ID

Query Text

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


SELECT JOB_NUMBER
,      LINE_NUMBER
,      DESCRIPTOR_KEY
,      MESSAGE_NAME
,      TOKEN_LIST
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
FROM ICX.ICX_POR_FAILED_LINE_MESSAGES;

Dependencies

[top of page]

ICX.ICX_POR_FAILED_LINE_MESSAGES does not reference any database object

ICX.ICX_POR_FAILED_LINE_MESSAGES is referenced by following:

ICX: ICX_POR_FAILED_LINE_MESSAGES#