(POXPOCOM) Purchase Order Commitment By Period Report Ends With MSG-00099, ORA-01722 Error

(Doc ID 961525.1)

Last updated on JANUARY 18, 2018

Applies to:

Oracle Purchasing - Version: 11.5.10.2 and later   [Release: 11.5 and later ]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2:
When running concurrent program: Purchase Order Commitment By Period Report (POXPOCOM)
the following error occurs:

ERROR
------------
MSG-00099: 1 = 1
ORA-01722: invalid number
SELECT DECODE ( : P_SORT , 'VENDOR' , pov . vendor_name , 'BUYER' , hre . full_name , pov .
vendor_name ) break_group_column , DECODE ( : P_SORT , 'VENDOR' , hre . full_name , 'BUYER' , pov. vendor_name , hre . full_name ) other_group_column , poh .

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