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: PON.PON_INTERFACE_ERRORS

Object Details

Object Name:	PON_INTERFACE_ERRORS
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_INTERFACE_ERRORS
Subobject Name:
Status:	VALID

PON_INTERFACE_ERRORS stores the error information resulting from processing the different negotiation interfaces (item, response, and award upload). The interface is identified in INTERFACE_TYPE and BATCH_ID indicates the interface job that produced the error.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_INTERFACE_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID
PON_INTERFACE_ERRORS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Comments
INTERFACE_TYPE	VARCHAR2	(30)	Interface type
COLUMN_NAME	VARCHAR2	(240)	Column name
TABLE_NAME	VARCHAR2	(30)	Table name
BATCH_ID	NUMBER		Batch ID for interface job
INTERFACE_LINE_ID	NUMBER		Interface line ID where error occurred
ERROR_MESSAGE_NAME	VARCHAR2	(2000)	Most of the time this column stores error message text. So increase the length to 2000
ERROR_VALUE	VARCHAR2	(4000)	Error value entered by the user
CREATED_BY	NUMBER		Standard Who Column
CREATION_DATE	DATE		Standard Who Column
LAST_UPDATED_BY	NUMBER		Standard Who Column
LAST_UPDATE_DATE	DATE		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Standard Who Column
PAYMENT_ID	NUMBER		Identifier of the payment if this error is on a negotiation payment
BID_PAYMENT_ID	NUMBER		Identifier of the payment if this error is on a response payment
REQUEST_ID	NUMBER		The concurrent request id. This id will be used to uniquely identify one offline process.
EXPIRATION_DATE	DATE		Creation date + 7 days by default.
ENTITY_TYPE	VARCHAR2	(25)	The entity object type that we are validating against.
ENTITY_ATTR_NAME	VARCHAR2	(30)	The entity attribute name, such as "BidCurrencyUnitPrice" or "Quantity"
ERROR_VALUE_DATE	DATE		Bad value of date type.
ERROR_VALUE_NUMBER	NUMBER		Bad value of number type.
ERROR_VALUE_DATATYPE	VARCHAR2	(3)	The datatype of error value, such as "TXT", "NUM", "DAT".
AUCTION_HEADER_ID	NUMBER		Negotiation header id
BID_NUMBER	NUMBER		Bid number
LINE_NUMBER	NUMBER		Line number
ATTRIBUTE_NAME	VARCHAR2	(4000)	Attribute name
PRICE_ELEMENT_TYPE_ID	NUMBER		Price element type id
SHIPMENT_NUMBER	NUMBER		Shipment number
PRICE_DIFFERENTIAL_NUMBER	NUMBER		Price differential number
TOKEN1_NAME	VARCHAR2	(30)	Message token name
TOKEN1_VALUE	VARCHAR2	(2000)	Message token value
TOKEN2_NAME	VARCHAR2	(30)	Message token name
TOKEN2_VALUE	VARCHAR2	(2000)	Message token value
TOKEN3_NAME	VARCHAR2	(30)	Message token name
TOKEN3_VALUE	VARCHAR2	(2000)	Message token value
TOKEN4_NAME	VARCHAR2	(30)	Message token name
TOKEN4_VALUE	VARCHAR2	(2000)	Message token value
TOKEN5_NAME	VARCHAR2	(30)	Message token name
TOKEN5_VALUE	VARCHAR2	(2000)	Message token value
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Application short name as some error messages may come from other product team.
WORKSHEET_NAME	VARCHAR2	(80)	Worksheet Name
ENTITY_MESSAGE_CODE	VARCHAR2	(30)	Message code for the entity name
WORKSHEET_SEQUENCE_NUMBER	NUMBER		Sequence Number to display Worksheet

Query Text

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


SELECT INTERFACE_TYPE
,      COLUMN_NAME
,      TABLE_NAME
,      BATCH_ID
,      INTERFACE_LINE_ID
,      ERROR_MESSAGE_NAME
,      ERROR_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PAYMENT_ID
,      BID_PAYMENT_ID
,      REQUEST_ID
,      EXPIRATION_DATE
,      ENTITY_TYPE
,      ENTITY_ATTR_NAME
,      ERROR_VALUE_DATE
,      ERROR_VALUE_NUMBER
,      ERROR_VALUE_DATATYPE
,      AUCTION_HEADER_ID
,      BID_NUMBER
,      LINE_NUMBER
,      ATTRIBUTE_NAME
,      PRICE_ELEMENT_TYPE_ID
,      SHIPMENT_NUMBER
,      PRICE_DIFFERENTIAL_NUMBER
,      TOKEN1_NAME
,      TOKEN1_VALUE
,      TOKEN2_NAME
,      TOKEN2_VALUE
,      TOKEN3_NAME
,      TOKEN3_VALUE
,      TOKEN4_NAME
,      TOKEN4_VALUE
,      TOKEN5_NAME
,      TOKEN5_VALUE
,      APPLICATION_SHORT_NAME
,      WORKSHEET_NAME
,      ENTITY_MESSAGE_CODE
,      WORKSHEET_SEQUENCE_NUMBER
FROM PON.PON_INTERFACE_ERRORS;

Dependencies

[top of page]

PON.PON_INTERFACE_ERRORS does not reference any database object

PON.PON_INTERFACE_ERRORS is referenced by following:

APPS: PON_INTERFACE_ERRORS