【销售设置】11i 销售订单登记失败，报Create_Delivery_Details failed 错误

 

登记订单时，出现以下错误

1.Failed to import the order line because Create_Delivery_Details failed.
2. Workflow activity Ship has failed. Please fix the errors and retry the activity from the Order Form or the Workflow        Monitor.
3.Order has been booked.

 

后来在METALINK上查到解决方法，需要打一个补丁，编号为：688704，补丁后，能正常登记了

PS:在挑库时，没打这个补丁前，挑库的仓库选项也不能正常显示出现然的仓库，打完补丁后也能正常显示

以下是METALINK的原文

Symptoms

Checked for relevance on 25-May-2010

On 11.5.10.2 in Production:
When attempting to book a new sales order, the following error occurs.

ERROR
Error: Failed to import the order line because Create_Delivery_Details failed.
Workflow activity Ship has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.
Order has been booked.

Cause

The Import Shipping location is not importing the locations from the HR/HZ location tables having last_update_date as NULL. In the procedure Process_locations, the cursors selecting the eligible locations from HZ/HR locations is not handling the NULL last_update_date records.

This issue has been fixed in the file WSHLOCMB.pls in version 115.36.11510.7.

This is explained in the following bug:
Bug 4688704 : NO LOCATION SETUP FOR THE ORGANIZATION ERROR WHILE BOOKING ORDER

Solution

 

To implement the solution, please execute the following steps:

1. Please download and review the readme and pre-requisites for Patch 4688704.

2. Please ensure that you have taken a backup of your system before applying the recommended patch.

3. Please apply the patch in a test environment.

4. Please confirm the following file versions:

WSHLOCMB.pls 115.36.11510.7

5. Please retest the issue.

6. If the issue is resolved, please migrate the solution as appropriate to other environments.