Sunday, 6 October 2013

Failed to import the order line because Create_Delivery_Details failed

Registration order, the following error
1.Failed to import the order line because 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. 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. 3.Order has been booked.


Later in METALINK found on solutions, the need to fight a patch number is: 688704, patch, normal registered

PS: In the pick library, did not play this patch before picking warehouse option can not be displayed correctly appear natural warehouses, kick patches can also show normal

From METALINK :

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

ERROR ERROR
Error: Failed to import the order line because Create_Delivery_Details failed. 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. 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. Order has been booked.

Cause 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. 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 issue has been fixed in the file WSHLOCMB.pls in version 115.36.11510.7.

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

Solution Solution


To implement the solution, please execute the following steps: To implement the solution, please execute the following steps:

1. Please download and review the readme and pre-requisites for Patch 4688704. 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. 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. 3. Please apply the patch in a test environment.

4. Please confirm the following file versions: 4. Please confirm the following file versions:

WSHLOCMB.pls 115.36.11510.7 WSHLOCMB.pls 115.36.11510.7

5. Please retest the issue. 5. Please retest the issue.

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



4 comments:

  1. Thanks a lot, i would like request you to provide more informations. I am working in ERP Software Developers Chennai

    ReplyDelete
  2. Thank you so much. I've a problem like that when upgraded db12c version.

    ReplyDelete
  3. Nice post.Thanks for sharing this post .I really appreciate the kind of topics you post here
    hr and payroll software in chennai

    ReplyDelete
  4. I think this is a real great article post.Thanks Again. Really Cool.
    learn informatica online
    online informatica course

    ReplyDelete