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 laterInformation 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 :
- Create an Order either though Conversion / Integration
- Order will be created in Approved Status and Original Approval Date is same as Creation Date.
- 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 |