POSUPLD Aborted
POSUPLD Aborted last night July 28, 2014 with the following error;
>
> posupld_1~20140729012836~post_item_loc~item_loc_soh~-1438~ORA-01438:
> value larger than specified precision allowed for this
> column~ARRAY UPDATE: NUM_RECORDS_PROCESSED=800,
> loc=0000000002, item=105107768, sales_qty=3693888.000000,
> eow_date=20140803
>
> Tue Jul 29 01:28:33 Program: posupld.sh: PID = :
> Started by rms13prd
> Process=POSU_2_20140728_20140729004939.1
> Tue Jul 29 01:28:36 Program: posupld.sh: PID = : Aborted
We have encountered this problem last July 28, 2014. We have reprocessed the file, but to our dismay, some items/transactions are loaded twice in RMS tran_data_history table and sales are deducted twice in stock_on_hand.
Is there any settings/options in the POSUPLD batch that checks whether the line or transactions are already processed, so that it would not be loaded twice in RMS tables?