My Oracle Support Banner

Stock on Hand Is Incorrectly Updated at the Finisher Location (Doc ID 2560226.1)

Last updated on OCTOBER 23, 2019

Applies to:

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

Symptoms


Actual Behavior
---------------

The Stock on Hand (SOH) updates component instead of the Pack thereby the Component becomes negative and the Pack remains at the same quantity at the Internal Finisher (IF).


Expected Behavior
-----------------------
The expected behaviour would be for IF to have 0 SOH.

Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Item A is a pack made of 30 units of Item B;
2. Let Wh1 and Wh2 be two Virtual Warehouses (Wh's) that belong to different Physical Warehouses;
3. Let IF1 be an Internal finisher of the same Physical Warehouse as Wh2;
4. Create a 2-legged Transfer from Wh1 to Wh2 and with Internal Finishing on IF1 (Wh1 -> IF1 -> Wh2);
5. The SOH is initially:
  - Item A, Wh1 = 100
  - Item B, Wh1 = 0
  - Item A, Wh2 = 100
  - Item B, Wh2 = 0
  - Item A, IF1 = 0
  - Item B, IF1 = 0
6. The 1st leg transfer is fully shipped from Wh1 and received at IF1;
7. SOH upon reception of the merchandise is the following:
  - Item A, Wh1 = 90
  - Item B, Wh1 = 0
  - Item A, Wh2 = 100
  - Item B, Wh2 = 0
  - Item A, IF1 = 10
  - Item B, IF1 = 0
8. The transfer is manually closed in RMS before completing the Work Order at IF1.
9. Create an Inventory Adjustment to move the stock of Item A from IF1 to Wh2 (within the same physical location)
10. SOH after Inventory Adjustment is:
  - Item A, Wh1 = 90
  - Item B, Wh1 = 0
  - Item A, Wh2 = 110
  - Item B, Wh2 = 0
  - Item A, IF1 = 10
  - Item B, IF1 = -300

The expected behaviour would be for IF to have 0 SOH of both items A and B (refer to the steps below) .
However, what seems to have happened was that the 10 items moved to Wh2 were created out of the components of the pack leaving the Internal Finisher (IF1) with -300 units of Item B and 10 units of Item A.
It seems logical that if the pack is available as-is in IF1, it should only affect the SOH of the pack and not its components.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.