My Oracle Support Banner

Why Are The TRAN_CODE 20 (Codes For Consignments) Sent To Retail Data Warehouse (RDW) ? (Doc ID 2546824.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

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


In Retail Merchandising System (RMS) for consignment items used for Retail Data Warehouse (RDW), using program ivrcpildex, there is no filter applied to eliminate tran_code 20 records (related to consignment).

Given the fact that consignment items are non-inventory items, and these tran_code 20 records are just quasi-receipts used in order to self-generated invoices, there is no reason to send these records to RDW.

Is this behavior intentional and if so, what is the reason for sending consignment tran_code 20 records to RDW ?


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.