My Oracle Support Banner

Invoice Print Error: Printing Selected Invoices Raises Error After upgrade to R12 (Doc ID 840268.1)

Last updated on MARCH 14, 2022

Applies to:

Oracle Receivables - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.


Attempting to run Invoice Print Selected Invoices and receive the following error:.
APP-FND-01436: List of Values cannot find any values for you to choose
Cause: The List of Values execution failed to find any values. 
Cause: The SQL statement specified to fdlfch() failed to return any values. Action: Check the message stack for any SQL statement failure messages. 
Check to make sure your SQL statement works in SQL*Plus. No entries found for List of Values

Responsibility:  Receivables Manager.
Navigation:  Print Documents > Invoices > Invoice Print Selected Invoices
Click on either Transaction Type or Transaction Number list of values


Additionally you may encounter the following in the Output when printing RAXINV_SEL (Invoice Print Selected Invoices)

MSG-00100: DEBUG:  AfterParam_Procs.Get_Country_Details
 REP-1401: 'afterpform': Fatal PL/SQL error occurred.
 ORA-01422: exact fetch returns more than requested number of rows 


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

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