REF_PACK_NO Column Is Empty for the TRAN_CODE 33 (Book Transfer Out) on the TRAN_DATA Table
Last updated on JULY 10, 2017
Applies to:Oracle Retail Merchandising System - Version 13.2.8 and later
Information in this document applies to any platform.
While Book Transfer is created for a simple pack, REF_PACK_NO column is empty for the TRAN_CODE 33 (Book Transfer Out) on the TRAN_DATA table.
Steps to Reproduce:
1. Create a Simple pack item with one component.
2. Add two Virtual Warehouses (VWHs) to both Items and set some inventory to the first warehouse for both.
3. Create a Book Transfer from one VWH (that contains inventory) to the other, transferring the Pack item.
4. Check TRAN_DATA table for the component item.
5. Notice that REF_PACK_NO would be empty.
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