EICS - Item Details Shows Incorrect Value For "Received Today" (Doc ID 3075369.1)

Last updated on MARCH 06, 2025

Applies to:

Symptoms

EICS - Item Details shows incorrect value for "Received Today"

When looking at EICS Item Detail screen (from Item Lookup) the value shown at "Received Today" for an item received multiple times on the same day at a store, does not seem correct. The value we see just shows the last receipt value and not the total received quantity during that day.

Steps to reproduce:

1. Observe LAST_RECEIVED_QUANTITY for an item with stock (in a store A)
2. Move item stock from another location (WH) to store A in 3 transfers
  - TSF1 (20 Units)
  - TSF2 (10 Units)
  - TSF3 (5 Units)
3. Receive transfers one by one, in the same day, and observe that:
  - LAST_RECEIVED_QUANTITY is updated with latest received QTY.
  - In EICS Item Lookup > Item Detail screen the value shown at "Received Today" matches LAST_RECEIVED_QUANTITY
  However expectation here is to have the sum all all received quantity for that day, not just the last received quantity.

Cause

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