My Oracle Support Banner

Issue In Estimated_instock_date Calcuation For Purchase Order (Doc ID 2919420.1)

Last updated on JANUARY 05, 2023

Applies to:

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

Symptoms

On : NA version, Operations & Maintenance

ESTIMATED_INSTOCK_DATE calculated incorrectly at Ordloc level is less than NOT_BEFORE_DATE at Ordhead level.

ESTIMATED_INSTOCK_DATE is calculated base on the Sum of below details at item level:

ORDHEAD - ORIG_APPR_DATE
ITEM_LOC - INBOUND_HANDLING_DAYS
TRANSIT_TIME - TRANSIT_TIME
ITEM_SUPP_COUNTRY - LEAD TIME

If the user wont maintain Inbound_Handling_Days, Transit_Time and Lead_Time days Then ESTIMATED_INSTOCK_DATE is same as ORIG_APPR_DATE.


 Steps to recreate :

  1. Create an Order either though Conversion / Integration
  2. Order will be created in Approved Status and Original Approval Date is same as Creation Date.
  3. Validate that Estimated_Instock_date is less than Not_before_date

 

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