POSUPLD.PC (Point of Sale Upload) Fails with "ORA-01840: input value not long enough for date format"

(Doc ID 2017848.1)

Last updated on JULY 21, 2017

Applies to:

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

Symptoms

The POSUPLD.PC (Point of Sale Upload) fails with the following ORA-01840 error.

posupld_1~20150224165208~post_pack~item_loc_soh~-1840~ORA-01840: input value not long enough for date format~ARRAY UPDATE: NUM_RECORDS_PROCESSED=0, loc=0000000505, item=126270, last_hist_export_date=2


Steps to Recreate
1. Process large POSU file which contains pack items and in-store promos.
2. Note that error message occurs.
3. Move pack items to separate POSU file; note that both files process successfully.

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