PO_INTERFACE_ERRORS

Stores the Interface errors from the PDOI Program

Details

• Schema: FUSION

• Object owner: PO

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
PO_INTERFACE_ERRORS_PK	INTERFACE_TYPE, INTERFACE_TRANSACTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INTERFACE_TYPE	VARCHAR2	25		Yes	Error message source
INTERFACE_TRANSACTION_ID	NUMBER		18	Yes	Error transaction unique identifier
COLUMN_NAME	VARCHAR2	30			Error column name
COLUMN_VALUE	VARCHAR2	4000			Error Column Value
ERROR_MESSAGE	VARCHAR2	2000			Error message text
PROCESSING_DATE	DATE				Error transaction date
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
PROGRAM_NAME	VARCHAR2	30			PROGRAM_NAME
PROGRAM_APP_NAME	VARCHAR2	30			PROGRAM_APP_NAME
ERROR_MESSAGE_NAME	VARCHAR2	30			Error message name
TABLE_NAME	VARCHAR2	30			Error related table
BATCH_ID	NUMBER		18		Unique identifier of batch being processed at the time of error
INTERFACE_HEADER_ID	NUMBER		18		Unique identifier of the header being processed at the time of error
INTERFACE_LINE_ID	NUMBER		18		Unique identifier of the line being processed at the time of error
INTERFACE_LINE_LOCATION_ID	NUMBER		18		Unique identifier of the line location being processed at the time of error
INTERFACE_DISTRIBUTION_ID	NUMBER		18		Unique identifier of the distribution being processed at the time of error
INTERFACE_ATTR_VALUES_ID	NUMBER		18		Unique identifier of the attribute values interface line being processed at the time of error
INTERFACE_ATTR_VALUES_TLP_ID	NUMBER		18		Unique identifier of the attribute values tlp interface line being processed at the time of error
PRICE_DIFF_INTERFACE_ID	NUMBER		18		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
INTERFACE_ASSIGNMENT_ID	NUMBER		18		Unique identifier of the org assignment being processed at the time of error

Indexes

Index	Uniqueness	Tablespace	Columns
PO_INTERFACE_ERRORS_N1	Non Unique	Default	INTERFACE_TRANSACTION_ID
PO_INTERFACE_ERRORS_N2	Non Unique	Default	REQUEST_ID
PO_INTERFACE_ERRORS_N3	Non Unique	Default	INTERFACE_HEADER_ID
PO_INTERFACE_ERRORS_N4	Non Unique	Default	INTERFACE_LINE_ID
PO_INTERFACE_ERRORS_N5	Non Unique	Default	BATCH_ID
PO_INTERFACE_ERRORS_U1	Unique	Default	INTERFACE_TYPE, INTERFACE_TRANSACTION_ID