Shipment And Booking History (Self Service)-- Loader Worker Fails - Column not found before end of logical record (use TRAILING NULLCOLS) (Doc ID 2147884.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4.1 version

Customer is trying to run collection using the Self Service form to load DemHistory.dat

Collections: Legacy Systems > Shipment and Booking History -Self Service

The Loader worker failed with following error

Record 1: Rejected - Error on table "DEMANTRA"."T_SRC_SALES_TMPL", column EBS_BASE_MODEL_CODE.
Column not found before end of logical record (use TRAILING NULLCOLS)


The concurrent request logs show

Table "DEMANTRA"."T_SRC_SALES_TMPL", loaded from every logical record.
Insert option in effect for this table: APPEND

  Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ACTUAL_QTY FIRST * ~ CHARACTER
SALES_DATE NEXT * ~ CHARACTER
DM_ITEM_CODE NEXT * ~ CHARACTER
DM_ORG_CODE NEXT * ~ CHARACTER
DM_SITE_CODE NEXT * ~ CHARACTER
EBS_SALES_CHANNEL_CODE NEXT * ~ CHARACTER
EBS_DEMAND_CLASS_CODE NEXT * ~ CHARACTER
EBS_BOOK_HIST_BOOK_QTY_BD NEXT * ~ CHARACTER
EBS_BOOK_HIST_REQ_QTY_BD NEXT * ~ CHARACTER
EBS_BOOK_HIST_BOOK_QTY_RD NEXT * ~ CHARACTER
EBS_BOOK_HIST_REQ_QTY_RD NEXT * ~ CHARACTER
EBS_SHIP_HIST_SHIP_QTY_SD NEXT * ~ CHARACTER
EBS_SHIP_HIST_SHIP_QTY_RD NEXT * ~ CHARACTER
EBS_SHIP_HIST_REQ_QTY_RD NEXT * ~ CHARACTER
EBS_BASE_MODEL_CODE NEXT * ~ CHARACTER
COMPONENT_CODE_LEGACY NEXT 4000 ~ CHARACTER
EBS_ITEM_SR_PK CONSTANT
  Value is '-23453'
EBS_ORG_SR_PK CONSTANT
  Value is '-23453'
EBS_SITE_SR_PK CONSTANT
  Value is '-23453'
EBS_SALES_CHANNEL_SR_PK CONSTANT
  Value is '-23453'
EBS_DEMAND_CLASS_SR_PK CONSTANT
  Value is '-23453'

value used for ROWS parameter changed from 1000 to 126
Record 1: Rejected - Error on table "DEMANTRA"."T_SRC_SALES_TMPL", column EBS_BASE_MODEL_CODE.
Column not found before end of logical record (use TRAILING NULLCOLS)

Table "DEMANTRA"."T_SRC_SALES_TMPL":
 0 Rows successfully loaded.
 1 Row not loaded due to data errors.
 0 Rows not loaded because all WHEN clauses were failed.
 0 Rows not loaded because all fields were null.


EXPECTED BEHAVIOR
-----------------------
Able to load data

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Login to VCP
2. Navigate--> Collections: Legacy Systems > Shipment and Booking History -Self Service


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load data

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