1. Tables and Views for Procurement
  2. POZ_VALIDATION_RESPONSE

POZ_VALIDATION_RESPONSE

This Table stores the values received from validation rest responses.

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

POZ_VALIDATION_RESPONSE_PK

RESPONSE_ID

Columns

Name Datatype Length Precision Not-null Comments
RESPONSE_ID NUMBER 18 Yes Unique identifier assigned to each request response record.
VENDOR_ID VARCHAR2 255 Unique identifier for the supplier.
FLOW_NAME VARCHAR2 4000 Yes Identifies the specific workflow or process used to call the external data provider API for supplier attribute validation.
EXT_DATA_PROVIDER_CODE VARCHAR2 255 Yes Abbreviation that identifies the external data provider for suppliers.
FLOW_IDENTIFIER VARCHAR2 255 Yes Unique identifier for the supplier flow request record.
RESPONSE_VALUE_1 VARCHAR2 4000 Stores the first supplemental response value returned from the supplier attribute validation.
RESPONSE_VALUE_2 VARCHAR2 4000 Stores the second supplemental response value returned from the supplier attribute validation.
RESPONSE_VALUE_3 VARCHAR2 4000 Stores the third supplemental response value returned from the supplier attribute validation.
RESPONSE_VALUE_4 VARCHAR2 4000 Stores the fourth supplemental response value returned from the supplier attribute validation.
RESPONSE_VALUE_5 VARCHAR2 4000 Stores the fifth supplemental response value returned from the supplier attribute validation.
RESPONSE_VALUE_6 VARCHAR2 4000 Stores the sixth supplemental response value returned from the supplier attribute validation.
RESPONSE_VALUE_7 VARCHAR2 4000 Stores the seventh supplemental response value returned from the supplier attribute validation.
FINAL_VALIDATION_STATUS VARCHAR2 4000 Stores the final outcome status of the validation performed on the supplier attribute.
REF_RESPONSE_ID NUMBER 18 Identifier for the originating response record used in creating this entry.
ITERATION_NUMBER NUMBER 18 Indicates how many times the validation service was called for this supplier flow request record.
TIMESTAMP TIMESTAMP Indicates the time when the row was Inactivated.
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.

Indexes

Index Uniqueness Tablespace Columns
POZ_VALIDATION_RESPONSE_U1 Unique FUSION_TS_TX_DATA RESPONSE_ID