ASCP / DP Data Collections Self Service Load - SQL*Loader-466: Column REQUEST_ID does not exist in table "MSD" OR "MSC" (Doc ID 1953858.1)

Last updated on DECEMBER 14, 2022

Applies to:

Symptoms

Self Service Upload CTL files do not match the Tables

In Advanced Supply Chain Planning Collections, when using the Self Service Collections the *.CTL file used, has REQUEST_ID added to it and the Staging Table is expected to have the column for the concurrent request ID.
There are a few staging tables that are missing this column.

ERROR
-----------------------
After running a sample load, the tables that have this error are:
SQL*Loader-466: Column REQUEST_ID does not exist in table "MSD"."T_SRC_SALES_TMPL#".
SQL*Loader-466: Column REQUEST_ID does not exist in table "MSD"."MSD_DEM_INS_BASE_HISTORY#".
SQL*Loader-466: Column REQUEST_ID does not exist in table "MSD"."MSD_DEM_DPT_REP_USG_HISTORY#".
SQL*Loader-466: Column REQUEST_ID does not exist in table "MSD"."MSD_DEM_FLD_SER_USG_HISTORY#".
SQL*Loader-466: Column REQUEST_ID does not exist in table "MSD"."MSD_DEM_RETURN_HISTORY#".
SQL*Loader-466: Column REQUEST_ID does not exist in table "MSD"."MSD_DEM_SRP_RETURN_HISTORY#".
SQL*Loader-466: Column REQUEST_ID does not exist in table "MSC"."MSC_ITEM_FAILURE_RATES#".
SQL*Loader-466: Column REQUEST_ID does not exist in table "MSD"."MSD_SPF_ST_SPARE_USAGE#".


STEPS
-----------------------
Advanced Planning Administrator (R) -> Collections -> Legacy Systems -> Collect Flat File Data - Self Service
OR Advanced Supply Chain Planning (R)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.