My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.