1. Tables and Views for Procurement
  2. POR_REQ_IMPORT_ERRORS

POR_REQ_IMPORT_ERRORS

POR_REQ_IMPORT_ERRORS stores error information generated in requisition import.

Details

  • Schema: FUSION

  • Object owner: POR

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

POR_REQ_IMPORT_ERRORS_PK

REQ_IMPORT_ERROR_ID

Columns

Name Datatype Length Precision Not-null Comments
REQ_IMPORT_ERROR_ID NUMBER 18 Yes Identifier of a requisition import error
COLUMN_NAME VARCHAR2 30 Column name
COLUMN_VALUE VARCHAR2 240 Column value
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_APP_NAME VARCHAR2 50 Yes Program application name
PROGRAM_NAME VARCHAR2 30 Program name
INTERFACE_TYPE VARCHAR2 30 Yes Indicate the interface type. A valid value is one of 'HEADER', 'LINE', 'DISTRIBUTION'
INTERFACE_ID NUMBER 18 Indicate header, line or distribution interface id depends on interface_type.
TEXT_LINE VARCHAR2 2000 Yes Message text
MESSAGE_NAME VARCHAR2 30 Message name
TOKEN_NAME1 VARCHAR2 30 Token name 1 of the message
TOKEN_VALUE1 VARCHAR2 1000 Token value 1 of the message
TOKEN_NAME2 VARCHAR2 30 Token name 2 of the message
TOKEN_VALUE2 VARCHAR2 1000 Token value 2 of the message
TOKEN_NAME3 VARCHAR2 20 Token name 3 of the message
TOKEN_VALUE3 VARCHAR2 1000 Token value 3 of the message
TOKEN_NAME4 VARCHAR2 30 Token name 4 of the message
TOKEN_VALUE4 VARCHAR2 1000 Token value 4 of the message
TOKEN_NAME5 VARCHAR2 30 Token name 5 of the message
TOKEN_VALUE5 VARCHAR2 1000 Token value 5 of the message
IMPORT_SOURCE VARCHAR2 25 Requisition import source code
IMPORT_BATCH_ID NUMBER 18 Requisition import batch id
REQ_BU_ID NUMBER 18 Yes Identifier of requisition business unit
NEXT_REQUISITION_NUMBER NUMBER 9 Next requisition number
GROUP_BY_CODE VARCHAR2 20 Group by code
INITIATE_REQ_APPROVAL_FLAG VARCHAR2 1 Yes Indicate whether or not initiate req approval
MAX_BATCH_SIZE NUMBER 9 Max batch size
PARTIAL_FLAG VARCHAR2 10 Indicate whether a requisition can be created with only the lines that pass validation even though some lines fail validation.
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.
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.
INTERFACE_KEY VARCHAR2 50 Cloud interface alternate key code for integrating applications to be able to identify the requisition data loaded in the interface table.
CLOUD_FLAG VARCHAR2 1 To indicate whether the requisition import is submitted from a cloud environment
LOAD_REQUEST_ID NUMBER 18 SQL Loader request Identifier

Indexes

Index Uniqueness Tablespace Columns
POR_REQ_IMPORT_ERRORS_N1 Non Unique Default INTERFACE_TYPE, INTERFACE_ID
POR_REQ_IMPORT_ERRORS_N2 Non Unique Default REQUEST_ID
POR_REQ_IMPORT_ERRORS_N3 Non Unique Default IMPORT_BATCH_ID
POR_REQ_IMPORT_ERRORS_U1 Unique Default REQ_IMPORT_ERROR_ID