My Oracle Support Banner

ORA-01480 Error ("Trailing Null Missing...") While Executing HSTBLDMTH Batch (Doc ID 1634296.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 and later
Information in this document applies to any platform.

Symptoms

ORA-01480 Error ("Trailing Null Missing...") occurs while executing HSTBLDMTH Batch.

Steps to Reproduce:

1. Insert one row into ITEM_LOC_HIST_MTH table with SALES_ISSUES >= 100000. You can use the following statement:
insert into  ITEM_LOC_HIST_MTH (ITEM,CREATE_DATETIME,LAST_UPDATE_DATETIME,LAST_UPDATE_ID,LOC,LOC_TYPE,EOM_DATE,MONTH_454,YEAR_454,SALES_TYPE,SALES_ISSUES,VALUE,GP,STOCK,RETAIL,AV_COST)
select '90066357', to_date('30102013','ddmmyyyy'), to_date('30102013','ddmmyyyy'),'RMS',220,'S',to_date('31102013','ddmmyyyy'),10,2013,'R',110000,3320.4,1549.52,null,null,null from dual;

2. Add the department number into hist_rebuild_mask table:
insert into hist_rebuild_mask (DEPT,CLASS,SUBCLASS) values (15,null,null);

3. Run hstbldmth batch in the rebuild mode.

4. The batch is aborted with error:

hstbldmth_1~20131031195528~insert_records~dept_sales_hist_mth~-1480~ORA-01480: trailing null missing from STR bind value~Error in INSERT.

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


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