PO_COMMUNICATION_PVT.GENERATE_PDF_BUYER: CAUGHT ZIP GENERATION EXCEPTION ORA-01722: invalid number
Last updated on APRIL 10, 2018
Applies to:Oracle Purchasing - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.
PO Approval Workflow has Zip error.
The Buyer and Supplier receive are receiving error notifications.
It happens 100% of the time if the user chooses any Communication method
IE: All error IF user chooses print, fax or email. if user chooses "None" there is no issue.
PO Zip attachment Error = Unexpected
The issue can be reproduced at will with the following steps:
1. When choosing the communication method in the "Submit for Approval" step to anything other than none, the error happens.
The error can be seen in the Approval Analyzer output (<Note 1525670.1>: EBS Procurement Approval Analyzer)
In the wfstat section:
NOTIFY_ZIP_ERROR_BUYER / ZIP_UNEXPECTED_ERROR-BUYER Notify Zip Error To Buyer Zip Unexpected Error COMPLETE #NULL PL035695 20348707 OPEN
WFStat: Notification Activities
NOTIFICATION RESULT MESSAGE PLSQL_FUNCTION VAL DISPLAY_NAME
ZIP_UNEXPECTED_ERROR * ZIP_UNEXPECTED_ERROR X Zip Unexpected Error
WFStat: Notification Messages
MESSAGE DISPLAY_NAME PRTY SUBJECT TEXT_BODY HTML_BODY
ZIP_UNEXPECTED_ERROR Zip Unexpected Error 50 Attachment Generation Failure - &DOCUMENT_TYPE_DISP &CLM_DOCUMENT_NUMBER&RELEASE_NUM_DASH&RELEASE_NUM Text Body = Could not sent attachments with the &DOCUMENT_TYPE_DISP &CLM_DOCUMENT_NUMBER&RELEASE_NUM_DASH&RELEASE_NUM. Please contact buyer for details. HTML Body = Could not sent attachments with the &DOCUMENT_TYPE_DISP &DOCUMENT_NUMBER&RELEASE_NUM_DASH&RELEASE_NUM. Please contact buyer for details.
The PO WF debug data shows:
PO_COMMUNICATION_PVT.generate_pdf_buyer :Launching the Dispatch Purchase Order program
PO_COMMUNICATION_PVT.get_max_zip_size : Querying max_attachment_size
PO_COMMUNICATION_PVT.get_max_zip_size : maximum attachment size = 99999
PO_COMMUNICATION_PVT.generate_pdf_buyer: Checking for supplier file attachments
PO_COMMUNICATION_PVT.generate_pdf_buyer: Caught Zip generation exception ORA-01722: invalid number
PO_COMMUNICATION_PVT.generate_pdf_buyer : Request id is - 60517035
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