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_LINES

Object Details

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

Maintains information about items/prices/schema elements that the loader rejected during a load job. For every line rejected, all user-given information is stored in this table. This data is then used for reporting to the user and in the case of items/prices to allow the user to correct the incorrect data online.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_FAILED_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOB_NUMBER LINE_NUMBER DESCRIPTOR_KEY

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.
ACTION	VARCHAR2	(30)	Yes	Action requested for the Item/Price or Schema element.
ROW_TYPE	VARCHAR2	(30)	Yes	Row Type owning the rejection. Possible values are: CATEGORY, DESCRIPTOR, ITEM_PRICE, PRICE, RELATIONSHIP
DESCRIPTOR_KEY	VARCHAR2	(250)	Yes	Key for the descriptor whose value is stored in descriptor_value for the rejected line.
DESCRIPTOR_VALUE	VARCHAR2	(2000)		Value given for the descriptor in the file submitted for loading.
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
,      ACTION
,      ROW_TYPE
,      DESCRIPTOR_KEY
,      DESCRIPTOR_VALUE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
FROM ICX.ICX_POR_FAILED_LINES;

Dependencies

[top of page]

ICX.ICX_POR_FAILED_LINES does not reference any database object

ICX.ICX_POR_FAILED_LINES is referenced by following:

ICX: ICX_POR_FAILED_LINES#