ra_interface_lines_all.ship_date_actual Is Wrong
Last updated on DECEMBER 07, 2017
Applies to:Oracle Order Management - Version 126.96.36.199 and later
Information in this document applies to any platform.
On : 188.8.131.52 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms