The useless bits of info to see if we can make a million posts thread

[Bill Gaheer]

Though I will put all to sleep,

This is what I am reading this morning.

My Oracle Support (the new MetaLink) Bookmarks Admin Profile Feedback Sign Out Help

Headlines Knowledge Service Request Collector Patches & Updates Community Certify
Knowledge Browser Advanced Search Bug Search

Quick Find
All Sources Knowledge Base Knowledge Base (Including Archived Articles) Bug Database Technical Forums Document ID (Knowledge Base, Forum, or Bug) Service Request Number Error Code Patch Number Go
Advanced Saved Searches



Did this article help solve your problem? Select Yes No Does Not Apply Would you recommend this document to others? Select Yes No Not Sure



TIP: Click help for a detailed explanation of this page.
Bookmark Go to End

Subject: Pick Selection List Generation Completes With Error
Doc ID: 758135.1 Type: PROBLEM
Modified Date : 24-DEC-2008 Status: MODERATED

In this Document
Symptoms
Cause
Solution
References



--------------------------------------------------------------------------------


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.



Applies to:
Oracle Inventory Management - Version: 11.5.1 to 12.0.6
This problem can occur on any platform.

Symptoms
-- Problem Statement:
On 12.0.6 in Production:
When attempting to pick release the following error occurs:

ERROR:

[...]
Calling program unit INV_PICK_RELEASE_PUB.PICK_RELEASE
.....
INV_QUANTITY_TREE_PVT: CREATE_TREE Entered
INV_QUANTITY_TREE_PVT: CreateTree ending with g_exc_unexpected_error.User-Defined Exception
...
INV_Pick_Release_Pub.Pick_Release l_return_status ==> U
Error occurred in Inv_Pick_Release_Pub.Pick_Release
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
in Package INV_Quantity_Tree_PVT Procedure Lock_Tree
Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Exiting WSH_PICK_LIST.RELEASE_BATCH_SUB - EXCEPTION:E_RETURN
...
errbuf ==> Exception occurred in WSH_PICK_LIST
Error occurred in Release_Batch_Sub
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST
[...]


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

enter sales order
save
book order
navigate to shipping > relase sales orders
choose an relevant shipping rule
choose order number
hit concurrent
Pick Selection List Generation program completes with error

view log file
Due to this issue, users cannot ship items on the orders


Cause
Two possible reasons for this problem:

Profile option INV: Quantity tree timeout for lock is not set properly.

The conversion that fail in procedure lock_tree is:
l_lock_timeout:=to_number(fnd_profile.value('INV_QTY_TREE_TIMEOUT'));


Organization Attiributes values which has been defined on Master Item Screen.

All items are lot controlled. So you should set attributes for ... as well:

Lot Spit Enabled
Lot Divisible
Solution
-- To implement the solution, please execute the following steps::

1st Case:

1. Go into the responsibility: System Administrator
2. Navigate to Profile > System
3. Set profile INV: Quantity tree timeout for lock to a proper value, par example 300
4. Please retest the issue
5. If the issue is resolved, please migrate the solution as appropriate to other environment(s)

2nd Case:

Organization Attiributes values which has been defined on Master Item Screen.
All items are lot controlled. So we should set attributes for...

Lot Spit Enabled
Lot Divisible
...as well.
Retest the issue and if it resolved, please migrate the solution as appropriate to other environment(s)


References
Note 365082.1 - Get Error INV_PICK_RELEASE_PICK_CONFIRM_FAILED When Allocate Move Orders
Note 462235.1 - Not Able To Save Line Information While Creating A Sales Order Error ORA-06502

Keywords
TIME~OUT ; INV_QTY_TREE_TIMEOUT ; UNEXPECTED~ERROR ; LIST~GENERATION ; INV_QUANTITY_TREE_PVT ; WSH_PICK_LIST ;
--------------------------------------------------------------------------------

Help us improve our service. Please email us your comments for this document. .


My Oracle Support (the new MetaLink) Bookmarks Admin Profile Feedback Sign Out Help

Copyright  2006, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement