Retail Merchandising System (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center