My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

Applies to:

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

Symptoms

NOTE:
In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

On : 12.2.5 version, Wave Planning

APP-JTF-210604 Error on Wave Planning Lines Tab

After partially shipping a delivery using a Shipping Company 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

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
Cause
Solution
References


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