Why Does the REQEXT Replenishment Batch Abort with the Error Message 'RET-0103: generic function processing error'? (Doc ID 1063685.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 12.0.8 and later
Information in this document applies to any platform.
Checked for relevance July 2013

Goal

Why does the REQEXT replenishment batch abort with the error message:

'reqext_1~20100208043836~rms_round_to_packsize~~103~RET-0103: generic function processing error~Invalid pack size 0.000000'?


We have items set up with a STORE_ORD_MULT value of EACH, there is only 1 style that is set up as a CASE.  The style that is set up as CASE has SUPP_PACK_SIZE value of 3.


Steps to Reproduce:

1. Create a transaction level item.  Choose the STORE_ORD_MULT value of 'E' (Each).  Range the item to a store and a warehouse.
2. Add replenishment attributes to the item/store as follows:
    stock category = Direct to Store or Warehouse Stocked
    order control = Semi-Automatic
    replenishment method = Min Max or Floating Point
    review cycle = Every Week
3. Notice: A record is inserted into the following database tables: REPL_ITEM_LOC, REPL_DAY and REPL_ITEM_LOC_UPDATES.
4. Run the batch programs PREPOST, RILMAINT, PRE, and RILMAINT.PC. Records should be updated in table REPL_ITEM_LOC, such as NEXT_REVIEW_DATE, SUPP_PACK_SIZE, INNER_PACK_SIZE, STORE_ORD_MULT, etc.
5. Update table REPL_ITEM_LOC column STORE_ORD_MULT with value 'E' and column SUPP_PACK_SIZE with value 0. This is to force the error scenario.
6. Insert a STORE_ORDERS table record for the ITEM/STORE/NEED_DATE with a positive NEED_QTY value. This is to force the replenishment algorithm to return a positive ROQ.
7. To recreate the problem in REQEXT.PC, repeat steps 1 through 6. In step 2, the stock category must be 'Warehouse Stocked' or 'WH/Cross Link'.
8. Run the batch program OCIROQ.C. This will create an RPL_NET_INVENTORY_TMP record for the item/store. Update this item/store RPL_NET_INVENTORY_TMP with a value > 0 for ROQ, ORDER_POINT, and ORDER_UP_TO_POINT.
9. Determine which partition your item is in within the RPL_NET_INVENTORY_TMP table. Run the batch program REQEXT using this partition number. This will result in the fatal error:

'reqext_1~20100208043836~rms_round_to_packsize~~103~RET-0103: generic function processing error~Invalid pack size 0.000000'.



Solution

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