My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Purchasing - Version 11.5.10.2 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

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.