Error ORA-00938: Not enough arguments for function When Trying to Manage Tasks In Warehouse Control Board (Doc ID 2180731.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to manage the tasks via the Warehouse Control Board (WMSCTLBD) , the following error occurs ONLY in RUSSIAN Language

ERROR
-----------------------
Original Russian error:
ORA-00938: недостаточно аргументов для функции
FRM-40735: JTF_GRID_EVENT триггер вызвал необработанное исключение ORA-06502.

Error translated into english:
ORA-00938: Not enough arguments for function
FRM-40735: JTF_GRID_EVENT trigger called an unhandled exception ORA-06502.

The session with Language = American works without any errors.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Log into Oracle using Russian session with WMS_SU responsibility
2) Navigate : Inquiry -> Warehouse Control Board -> Status - Unreleased, Pending (both flagged), Source - Outbound flagged
3) Then Click Find. There will be list of tasks displayed.
4) When you select the task line and try to click Manage button, the error occurs.

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