Pick None Gives Error "Error Processing Task"
(Doc ID 1900865.1)
Last updated on JULY 08, 2020
Applies to:
Oracle Warehouse Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to select Pick None from the Exceptions LOV, while doing a Pick by Label
the following error occurs. This appears to have occurred after applying patch 18714625 to fix another issue.
The following messages are found in the debug log:
[Thu Jun 05 11:50:15 EDT 2014] (Thread-15) ReasonLOV: fieldEntered
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) ReasonLOV: fieldExited:2- Pick none Incorrect on-hand.
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) JFK mTaskLoadedCount :0
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) Go to Previous page is set
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) DiscrepancyFListener: Set next field to: MAIN.FROM_SUB_CONFIRM
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMFL: after new one: mDiscrepancyList.toString():[]
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMFL: after adding one: mDiscrepancyList.toString():[null]
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) In MAINPAGE.setDiscrepancy()
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) WorkFlowProcess String:NULL
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) reasonContextCode.. .PN
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMPG: Inside PickNone method
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) userID:xxx
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) transactionTempID: 333691802
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMPG: Calling cleanup task API with ......
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMPG: TEMPID: 333691802
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMPG: UserID: xxx
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMPG: EMPID: xxx
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMPG: quantityReasonID : 661
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMPG: exception occured when call cleanup_task :java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'CLEANUP_TASK'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[Thu Jun 05 11:50:17 EDT 2014] (Thread-15) AMPG: Exception Occured at Pick None
ERROR
-----------------------
Error Processing Task
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the Pick By Label page.
2. Enter the LPN.
3. Click the Exceptions button.
4. Select exception: "Pick none Incorrect on-hand".
5. See error message: Error processing task.
Changes
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 |
Changes |
Cause |
Solution |
References |