POSUPLD.PC Fails with "ORA-01840: input value not long enough for date format"
Last updated on JANUARY 04, 2018
Applies to:Oracle Retail Merchandising System - Version 13.0.7 and later
Information in this document applies to any platform.
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.
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