My Oracle Support Banner

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

Last updated on JULY 21, 2020

Applies to:

Oracle Retail Merchandising System - Version 14.1.1 and later
Information in this document applies to any platform.


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

1. Entries in System_options:
            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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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