POSUPLD.PC Fails with "ORA-01840: input value not long enough for date format"
(Doc ID 2017848.1)
Last updated on SEPTEMBER 01, 2020
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!