My Oracle Support Banner

Backorder Value Show Unexpected Value (Doc ID 2949612.1)

Last updated on MAY 17, 2023

Applies to:

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


On : 23.0 version, Operations & Maintenance

Backorder value show unexpected value

While creating an transfer the backorder value shows a value different than the one showed in the item_loc_soh table.

The available quantity is calculated using the following formula:
Available quantity = Stock_on_hand - (TSF_RESV + RTV + UNAVAIL + CUSTOMER_RESV + CUSTOMER_BACKORDER)
Available quantity = 0 - (0+0+0+0+3)
Available quantity = -3

On the transfer detail screen the available quantity is showed correctly but on the other hand the value of the backorder quantity should be 3 as seen in the item_loc_soh table but the displayed value is 0.


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.