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: PO.PO_INTERFACE_ERRORS

Object Details

Object Name:	PO_INTERFACE_ERRORS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_INTERFACE_ERRORS
Subobject Name:
Status:	VALID

PO_INTERFACE_ERRORS contains error message information generated by
the open interface programs in Oracle Purchasing. For every interface
transaction row with errors, this table contains a row for each column
that has an error.
.
The INTERFACE_TYPE and INTERFACE_TRANSACTION_ID columns identify the
Oracle Purchasing program and interface transaction that generated the
error message. The COLUMN_NAME and ERROR_MESSAGE columns identify the
interface column in error with a descriptive error message. The
PROCESSING_DATE column contains the date when the error message was
generated.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_INTERFACE_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_TRANSACTION_ID
PO_INTERFACE_ERRORS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_HEADER_ID INTERFACE_LINE_ID
PO_INTERFACE_ERRORS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_LINE_ID
PO_INTERFACE_ERRORS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_TYPE	VARCHAR2	(25)	Yes	Error message source
INTERFACE_TRANSACTION_ID	NUMBER		Yes	Error transaction unique identifier
COLUMN_NAME	VARCHAR2	(30)		Error column name
ERROR_MESSAGE	VARCHAR2	(2000)		Error message text
PROCESSING_DATE	DATE			Error transaction date
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ERROR_MESSAGE_NAME	VARCHAR2	(30)		Error message name
TABLE_NAME	VARCHAR2	(30)		Error related table
BATCH_ID	NUMBER			Unique identifier of batch being processed at the time of error
INTERFACE_HEADER_ID	NUMBER			Unique identifier of the header being processed at the time of error
INTERFACE_LINE_ID	NUMBER			Unique identifier of the line being processed at the time of error
INTERFACE_DISTRIBUTION_ID	NUMBER			Unique identifier of the distribution being processed at the time of error
COLUMN_VALUE	VARCHAR2	(4000)		Error Column Value
INTERFACE_LINE_LOCATION_ID	NUMBER			Unique identifier of the line location being processed at the time of error
INTERFACE_ATTR_VALUES_ID	NUMBER			Unique identifier of the attribute values interface line being processed at the time of error
INTERFACE_ATTR_VALUES_TLP_ID	NUMBER			Unique identifier of the attribute values tlp interface line being processed at the time of error
PRICE_DIFF_INTERFACE_ID	NUMBER			Unique identifier of the price differential being processed at the time of error
TOKEN1_NAME	VARCHAR2	(100)		1st token name of the message
TOKEN1_VALUE	VARCHAR2	(200)		1st token value of the message
TOKEN2_NAME	VARCHAR2	(100)		2nd token name of the message
TOKEN2_VALUE	VARCHAR2	(200)		2nd token value of the message
TOKEN3_NAME	VARCHAR2	(100)		3rd token name of the message
TOKEN3_VALUE	VARCHAR2	(200)		3rd token value of the message
TOKEN4_NAME	VARCHAR2	(100)		4th token name of the message
TOKEN4_VALUE	VARCHAR2	(200)		4th token value of the message
TOKEN5_NAME	VARCHAR2	(100)		5th token name of the message
TOKEN5_VALUE	VARCHAR2	(200)		5th token value of the message
TOKEN6_NAME	VARCHAR2	(100)		6th token name of the message
TOKEN6_VALUE	VARCHAR2	(200)		6th token value of the message
APP_NAME	VARCHAR2	(50)		Application Short Name

Query Text

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


SELECT INTERFACE_TYPE
,      INTERFACE_TRANSACTION_ID
,      COLUMN_NAME
,      ERROR_MESSAGE
,      PROCESSING_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ERROR_MESSAGE_NAME
,      TABLE_NAME
,      BATCH_ID
,      INTERFACE_HEADER_ID
,      INTERFACE_LINE_ID
,      INTERFACE_DISTRIBUTION_ID
,      COLUMN_VALUE
,      INTERFACE_LINE_LOCATION_ID
,      INTERFACE_ATTR_VALUES_ID
,      INTERFACE_ATTR_VALUES_TLP_ID
,      PRICE_DIFF_INTERFACE_ID
,      TOKEN1_NAME
,      TOKEN1_VALUE
,      TOKEN2_NAME
,      TOKEN2_VALUE
,      TOKEN3_NAME
,      TOKEN3_VALUE
,      TOKEN4_NAME
,      TOKEN4_VALUE
,      TOKEN5_NAME
,      TOKEN5_VALUE
,      TOKEN6_NAME
,      TOKEN6_VALUE
,      APP_NAME
FROM PO.PO_INTERFACE_ERRORS;

Dependencies

[top of page]

PO.PO_INTERFACE_ERRORS does not reference any database object

PO.PO_INTERFACE_ERRORS is referenced by following:

PO: PO_INTERFACE_ERRORS#