SCH_PR_EXCEPTIONS

This table contains the exceptions occurred during mass replacement and reinstate process with the details of exceptions that include attributes in error, attribute value and error messages.

Details

• Schema: FUSION

• Object owner: SCH

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SCH_PR_EXCEPTIONS_PK	EXCEPTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXCEPTION_ID	NUMBER		18	Yes	Unique identifier for the exception that happens during the mass replacement process.
REPLACEMENT_ID	NUMBER		18	Yes	Unique Identifier for a replacement instance initiated for a combination of supplier, supplier site and item in a procurement business unit.
REPLACEMENT_DETAIL_ID	NUMBER		18	Yes	Replacement Details Unique Identifier.
PO_DETAIL_ID	NUMBER		18	Yes	Unique identifier of the purchase order entity that undergoes mass replacement.
PO_EXCEPTION_TYPE	VARCHAR2	30		Yes	Indicates error type as cancel or create.
PO_HEADER_ID	NUMBER		18	Yes	Purchase Order Unique Identifier which is being replaced.
PO_LINE_ID	NUMBER		18		Purchase Order Line Unique Identifier which is being replaced.
PO_LINE_LOCATION_ID	NUMBER		18		Purchase Order Line Location Unique Identifier which is being replaced.
PO_DISTRIBUTION_ID	NUMBER		18		Purchase Order Distribution Unique Identifier which is being replaced.
REQUISITIONING_BU_ID	NUMBER		18	Yes	Requisitioning business unit unique identifier.
PRC_BU_ID	NUMBER		18	Yes	Procurement business unit unique identifier.
ATTRIBUTE	VARCHAR2	30			Attribute of purchase order entity that fails when change order is created on the purchase order by the mass replacement process.
VALUE	VARCHAR2	4000			Value for the attribute of purchase order entity with which the change order creation fails when it is created by the mass replacement process.
ERROR_MESSAGE	VARCHAR2	2000			Error message for the exception that happens during the mass replacement process.
TABLE_NAME	VARCHAR2	30			Name of the table that represents the purchase order entity at which the exception happens during the mass replacement process.
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.
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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
SCH_PR_EXCEPTIONS	SCH_PR_REPLACEMENTS	REPLACEMENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
SCH_PR_EXCEPTIONS_N1	Non Unique	Default	REPLACEMENT_ID, REPLACEMENT_DETAIL_ID
SCH_PR_EXCEPTIONS_N2	Non Unique	Default	PO_DETAIL_ID
SCH_PR_EXCEPTIONS_N3	Non Unique	Default	PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID
SCH_PR_EXCEPTIONS_U1	Unique	Default	EXCEPTION_ID