Invoice Print Error: Printing Selected Invoices Raises Error After upgrade to R12
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.
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
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