Pick None Gives Error "Error Processing Task" (Doc ID 1900865.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information 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:7864
[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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms