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 JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Data Collections

Self Service Upload CTL files do not Match the TEMP Tables

In ASCP/DP 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
-----------------------
The issue can be reproduced at will with the following steps:
(1) Advanced Planning Administrator
  --> Collections
  --> Legacy Systems
  --> Collect Flat File Data - Self Service

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms