ra_interface_lines_all.ship_date_actual Is Wrong
(Doc ID 1957396.1)
Last updated on JANUARY 28, 2020
Applies to:Oracle Order Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
On : 126.96.36.199 version, Transaction Fulfillment
When attempting to run AutoInvoice Validation Report, found the following error:
Errors: 1) Unable to derive a gl date for your transaction. Please ensure that your transaction is in a gl period which you
The issue can be reproduced at will with the following steps:
1.Create sales order
2.Pick release the sales order line, but it has been partially fulfilled, as the inventory stock is not enough. This happened in previous period.
3.On the next period, put enough stock into Inventory, pick the remaining quantity.
4.Ship confirm the two deliveries.
5.Run Interface trip stop
6.Run this query“SELECT SHIP_DATE_ACTUAL
FROM RA_INTERFACE_LINES_ALL”，found the ship date actual is not correct, it stampted with the last period date.
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