My Oracle Support Banner

ra_interface_lines_all.ship_date_actual Is Wrong (Doc ID 1957396.1)

Last updated on DECEMBER 07, 2017

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

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.