ra_interface_lines_all.ship_date_actual Is Wrong (Doc ID 1957396.1)

Last updated on AUGUST 31, 2016

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Transaction Fulfillment

When attempting to run AutoInvoice Validation Report, found the following error:

ERROR
-----------------------
 Errors: 1) Unable to derive a gl date for your transaction. Please ensure that your transaction is in a gl period which you
  have defined

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


Cause

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