MES Job Traveler Unexpected Error ORA-01722
(Doc ID 1923885.1)
Last updated on MARCH 23, 2020
Applies to:Oracle MES for Discrete Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Other Components
When attempting to print MES job traveler the following error occurs.
Unexpected error ORA-01722
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.
The issue has the following business impact:
User is unable to print MES job traveler
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