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 JULY 10, 2017

Applies to:

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

Symptoms

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.

Cause

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