MES Job Traveler Unexpected Error ORA-01722 (Doc ID 1923885.1)

Last updated on MARCH 23, 2020

Applies to:

Symptoms

On : 12.1.3 version, Other Components

When attempting to print MES job traveler the following error occurs.

ERROR
-----------------------
 Unexpected error ORA-01722

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) WIP: Create and release job for assembly
2) Ensure job has attachments.
3) Responsibility: MES Operator. Select released job and Actions: View and Print Traveler


The issue can be replicated in user's environment which contains new data using the standard WIPMESDATT.xml template.

Users have their own custom template, based on the standard WIPMESDATT.xml.

User has found that in the 'Job Traveler Template Setup' parameter, if they turn off the 'Include PDF attachments in Job Traveler'
option, their custom traveler then prints (but the standard traveler still errors).
 
Users do not have pdf attachments, this has reduced the severity of the problem for them (they are in 'final' user acceptance testing).

Users have determined that that issue is due to code in WIPMESDATT.xml checking table FND_ATTACHED_DOCUMENTS
for non-numeric values in PK2_VALUE.

In their new environment, there are now entries for entity PA_STRUCT_VER with a value of 'MPP' in PK2_VALUE.

So problem is that MES Traveler is checking for non-numeric values although these are allowed in other parts of the system.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:

User is unable to print MES job traveler

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.