My Oracle Support Banner

Wrong Data In Tran_Data Upon Receipt With Expenses Through Importer WH (Doc ID 2975692.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.


When receiving an order with expenses, through an importer WH, the tran_code 20 (purchase) is associated to the virtual warehouse. This code should be associated only to the importer warehouse.

STEPS to reproduce the issue:
1. Have a physical WH with one WH as an importer.
2. Have a physical WH with one WH as a virtual.
3. Have an order defined with:
- invoice location -> the importer warehouse
- final location -> the virtual warehouse
- one item
- expenses associated with the item
4. Submit and approve the order.
5. Ship and receive the order.
6. Check the transaction in the TRAN_DATA table.


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.