Invoice Print Error: Printing Selected Invoices Raises Error After upgrade to R12

(Doc ID 840268.1)

Last updated on AUGUST 25, 2017

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.
RAXINV_SEL

Symptoms

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 

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