My Oracle Support Banner

REF_PACK_NO Column Is Empty for the TRAN_CODE 33 (Book Transfer Out) on the TRAN_DATA Table (Doc ID 2087772.1)

Last updated on MARCH 15, 2019

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.


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.