PON_INTERFACE_ERRORS

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.

Details

• Schema: FUSION

• Object owner: PON

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INTERFACE_TYPE	VARCHAR2	30			Interface type
COLUMN_NAME	VARCHAR2	240			Column name
TABLE_NAME	VARCHAR2	30			Table name
BATCH_ID	NUMBER		18	Yes	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
PAYMENT_ID	NUMBER				Not currently used. Identifier of the payment if this error is on a negotiation payment
BID_PAYMENT_ID	NUMBER				Not currently used. Identifier of the payment if this error is on a response payment
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_DATETIME	DATE				Bad value of datetime 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		18		Negotiation header id
BID_NUMBER	NUMBER		18		Bid number
LINE_NUMBER	NUMBER				Line number
ATTRIBUTE_NAME	VARCHAR2	4000			Attribute name
PRICE_ELEMENT_TYPE_ID	NUMBER		18		Price element type id
SHIPMENT_NUMBER	NUMBER				Shipment number
PRICE_DIFFERENTIAL_NUMBER	NUMBER				Not currently used. 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
WORKSHEET_NAME	VARCHAR2	80			Worksheet Name
ENTITY_MESSAGE_CODE	VARCHAR2	240			Message code for the entity name
WORKSHEET_SEQUENCE_NUMBER	NUMBER				Sequence Number to display Worksheet
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_NAME	VARCHAR2	30			Identifies the concurrent program
PROGRAM_APP_NAME	VARCHAR2	50			Identifies the Application name spawning the Concurrent Request
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
COLUMN_NAME_CODE	VARCHAR2	240			The resource bundle key of the spreadsheet column name.
COLUMN_NAME_BUNDLE	VARCHAR2	240			The resource bundle name of the spreadsheet column name.
ERROR_TYPE	VARCHAR2	30			Indicates whether it's a warning or error.

Indexes

Index	Uniqueness	Tablespace	Columns
PON_INTERFACE_ERRORS_N1	Non Unique	Default	BATCH_ID
PON_INTERFACE_ERRORS_N2	Non Unique	Default	REQUEST_ID
PON_INTERFACE_ERRORS_N3	Non Unique	Default	BID_NUMBER