Tran_Code 22 is Getting Posted as TRAN_DATA Overage (Doc ID 2238066.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Symptoms

Tran_code  22 is getting posted as TRAN_DATA overage.  Consider the below scenario:

Pre-requists:
1. Entries in System_options:
  TSF_FORCE_CLOSE_IND TSF_OVER_RECEIPT_IND
            NL                                         NL
2. Consider a SKU which has two different EAN's associated to it. Like
  SKU     EAN
  SKU1   EAN1
  SKU1   EAN2

Steps to recreate:
1. Create an Allocation (Alloc1) for above SKU for below mentioned quantities, from warehouse (W1) to store (Str1):
  Item    Qty
  SKU1    9

2. Shipping is performed with the below criteria:
  SKU     EAN   Qty
  SKU1   EAN1  4
  SKU1   EAN2  5

3. Once the shipment is confirmed, two different records for individual EAN's will be populated in SHIPSKU table.
Data in shipsku:
  Shipment item   ref_item qty_received qty_expected
  S1           SKU1   EAN1             9                   4
  S1           SKU1   EAN2             0                   5

4. A record will be populated with tran_code as 22 saying trandata_overage with units as -5
  Data in tran_data:
  Item   Loc_type  Location  tran_code units Ref_no_1  ref_no_2 pgm_name
  SKU1       W             W1        22            -5    Alloc1             S1     STOCK_ORDER_RCV_SQL.TRANDATA_OVERAGE

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.