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

Last updated on JULY 08, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.