My Oracle Support Banner

ALLOC_DETAIL.IN_STORE_DATE Is Not Getting Populated (Doc ID 3056267.1)

Last updated on OCTOBER 29, 2024

Applies to:

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

Goal

On : 19.0.1 version, Other

ACTUAL BEHAVIOR
---------------
ALLOC_DETAIL.IN_STORE_DATE is not getting populated once data gets processed from RIB.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Process BOL message

*updated Steps to reproduce:

1. Allocation is created in RMS (for loc 5517)
2. Shipped to 2 locations from WMS (5517 & 3193) - messages attached
ASNOut_ASNOUTCRE_20230208225503445_908.xml & ASNOut_ASNOUTCRE_20230208230503109_908.xml.
Note:Message from WMS doesn't contain the IN_STORE_DATE for the shipment to 3193
3. RMS does not populate the INSTORE_DATE and so remains null in alloc_detail

Result: This causes the second new allocation not to flow to SIM with the exception: "Allocation not found from delivery".

Solution

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
Goal
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.