PDF Document Generation Failure JAVA.SQL.SQLSYNTAXERROREXCEPTION: ORA-01722: INVALID NUMBER

(Doc ID 2194638.1)

Last updated on JUNE 29, 2018

Applies to:

Oracle Purchasing - Version 12.1 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12  version, Approvals - Req, PO

ACTUAL BEHAVIOR
---------------
Buyers are receiving system generated PDF failure notifications after a PO is submitted and approved.

POXPOPDF: PO Output for Communication
+---------------------------------------------------------------------------+
...
Name:P_REGENERATE_DOCUMENT Value:Y
Name:P_PRINT_CANCELLED_LINES Value:Y
Name:P_PRINT_CLOSED_LINES Value:Y
ORGID:82
m_withTerms : Y
Executing the query for header id
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

 



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view PDF

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