Receiving Value Report Error (Doc ID 2070370.1)

Last updated on NOVEMBER 14, 2015

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Receiving Value Report for an organization name greater than 60 characters, the following error occur.

ERROR
-----------------------

MSG-00001: before report
MSG-00999: 20: ORA-06502: PL/SQL: numeric or value error
ORA-01403: no data found
MSG-00999: POXRRCVV >X Tue Sep 29 12:28:42 2015
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00001: before report
MSG-00999: 20: ORA-06502: PL/SQL: numeric or value error
ORA-01403: no data found
MSG-00999: POXRRCVV >X Tue Sep 29 12:28:42 2015
REP-1419: 'beforereport': PL/SQL program aborted.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using Purchasing responsibility, navigate to Reports-Run-Single Request- select Receiving Value report
2. Enter all required parameters->The report fails


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