1. Tables and Views for SCM
  2. VCS_IMPORT_DATA_REQUESTS

VCS_IMPORT_DATA_REQUESTS

Identifies individual requests to track submitted import data.

Details

  • Schema: FUSION

  • Object owner: VCS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

VCS_IMPORT_DATA_REQUESTS_PK

IMPORT_REQUEST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
IMPORT_REQUEST_ID NUMBER 18 Yes Uniquely identifies user's request to import data.
VENDOR_ID NUMBER 18 Value that uniquely identifies the trading partner invoking the B2B message.
DOCUMENT_ID NUMBER 18 Yes Identifies the attachment document id to process for the request.
PROCESS_ID NUMBER 18 Identifies the scheduled process that was used to make the request.
FILENAME VARCHAR2 512 Yes Name of the file uploaded to initiate the import process.
REFRESH_NUMBER NUMBER 18 Refresh identifier populated by the Load Supply Data for Externally Managed Organizations job and used by collections.
STATUS_CODE VARCHAR2 32 Yes Identifies the current state of the import data request. Active
SOURCE_SYSTEM_CODE VARCHAR2 30 Yes This identifies the product data model source system.
COLLECTION_TYPE_CODE VARCHAR2 32 Yes Identifies whether the parameter is for 'Net Change' or 'Targeted' Collections.
REQUESTED_BY_PARTY VARCHAR2 30 Yes Identifies type of the user that made a request to import the data.
USER_LANGUAGE VARCHAR2 4 Indicates the code of the language into which the contents of the translatable columns are translated.
USER_LOCALE VARCHAR2 32 Indicates the locale of the user that created the request.
LOAD_PROCESS_ID NUMBER 18 Identifies the process that was used to load data for the request.
LOAD_ERRORS_COUNT NUMBER 9 Count of errors encountered loading supply data for externally managed organizations prior to collections.
SOH_EXPORT_STATUS_CODE VARCHAR2 32 Identifies the current state of exporting supplier on-hand to Supply Chain Collaboration process.
COLLECTION_PROCESS_ID NUMBER 18 Identifies the process used by planning cloud to collect data.
STATUS_MESSAGE_CODE VARCHAR2 32 Abbreviation that identifies the detailed message associated with current status.
NOTES VARCHAR2 500 Capture additional notes of supply 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. Active
MSC_PO_UPLD_STATE VARCHAR2 30 Yes Identifies the load state of the purchase orders and requisitions object associated with this supply data request. Valid values are 0, 1, or 2. 0 means the object was not included, 1 means the object was included and was successfully loaded, and 2 means the object was included but failed during load.
MSC_SOH_UPLD_STATE VARCHAR2 30 Yes Identifies the load state of the supply on hand object associated with this supply data request. Valid values are 0, 1, or 2. 0 means the object was not included, 1 means the object was included and was successfully loaded, and 2 means the object was included but failed during load.
MSC_WIP_DEMANDS_UPLD_STATE VARCHAR2 30 Yes Identifies the load state of the work order component demands object associated with this supply data request. Valid values are 0, 1, or 2. 0 means the object was not included, 1 means the object was included and was successfully loaded, and 2 means the object was included but failed during load.
MSC_WIP_OR_UPLD_STATE VARCHAR2 30 Yes Identifies the load state of the work order operation resources object associated with this supply data request. Valid values are 0, 1, or 2. 0 means the object was not included, 1 means the object was included and was successfully loaded, and 2 means the object was included but failed during load.
MSC_WOS_UPLD_STATE VARCHAR2 30 Yes Identifies the load state of the work order supplies object associated with this supply data request. Valid values are 0, 1, or 2. 0 means the object was not included, 1 means the object was included and was successfully loaded, and 2 means the object was included but failed during load.
VCS_INT_COL_PROCESS_ID NUMBER 18 Identifies the process that was used to initiate collection of data for the pending requests.
B2B_MESSAGE_ID VARCHAR2 256 ID that identifies the B2B Collaboration Message.
B2B_USER VARCHAR2 64 Indicates the user who submitted the B2B Collaboration Message.
B2B_FLAG VARCHAR2 1 Yes Indicates if the request originated from a B2B Collaboration Message.

Indexes

Index Uniqueness Tablespace Columns
VCS_IMPORT_DATA_REQUESTS_N1 Non Unique Default STATUS_CODE
VCS_IMPORT_DATA_REQUESTS_U1 Unique Default IMPORT_REQUEST_ID