APP-JTF-210604 Error On Wave Planning Lines Tab (Doc ID 2209137.1)

Last updated on NOVEMBER 30, 2016

Applies to:

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

Symptoms

On : 12.2.5 version, Wave Planning

APP-JTF-210604 Error on Wave Planning Lines Tab

After partially shipping a delivery using a UPS tracking number (1Z....) (this issue is only when the tracking number had alpha and numeric characters), the Wave Planning form will error if a user tries to requery the wave. It is related to Oracle support note WMS Wave Dashboard Form DASH_BOARD Error FRM-40735, APP_TREE ORA-01722 ( Doc ID 2020786.1 ). Patch T21044331:R12.WMS.C was applied and resolved the issue.

Now when the wave is queried with a partially shipped delivery and a UPS tracking number (1Z....) entered the following error is received on the Wave Planning Lines Tab.

ERROR
-----------------------
Error Reads:
APP_JTF-210604: Program error: Please inform your system administrator or support representative that:

jtf_grid.populate package reports error:

An unexpected error occurred in jtf_grid.populate

grid: <JTF_BLOCK.JTF.ITEM>
datasource: <WMS_WP_LINE_GTMP>

the following information is avaiable

APP-JTF-210604, ORA-01722, ORA-06512


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Partially ship a delivery and a UPS tracking number (1Z....)
2. Query the Wave -
3. Get error



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