Attempting to run "Invoice Print Selected Invoices" Concurrent Program
and selecting Transaction Type LOV showing below error messages:
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
Solution:-
Concurrent programs are defined with an operating unit mode of 'S' for single operating unit or 'M' for multiple operating units. This mode is set automatically during the upgrade to Release 12.
The following query should return one row with a value of 'S':
Select MULTI_ORG_CATEGORY
from FND_CONCURRENT_PROGRAMS
where concurrent_program_name = 'RAXINV_SEL';
If the result is not 'S', please do the following:
Responsibility: System Administration (Take note use System Administration and not System Administrator)
Navigation: Concurrent > Programs-->
Enter the following:
Application = Receivables
Short Name = RAXINV_SEL
Click on Go button.
Click on Update icon (pencil) to update the details of report
Click on Request tab
Select Operating Unit Mode = 'Single' and save it.
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
Solution:-
Concurrent programs are defined with an operating unit mode of 'S' for single operating unit or 'M' for multiple operating units. This mode is set automatically during the upgrade to Release 12.
The following query should return one row with a value of 'S':
Select MULTI_ORG_CATEGORY
from FND_CONCURRENT_PROGRAMS
where concurrent_program_name = 'RAXINV_SEL';
If the result is not 'S', please do the following:
Responsibility: System Administration (Take note use System Administration and not System Administrator)
Navigation: Concurrent > Programs-->
Enter the following:
Application = Receivables
Short Name = RAXINV_SEL
Click on Go button.
Click on Update icon (pencil) to update the details of report
Click on Request tab
Select Operating Unit Mode = 'Single' and save it.
No comments:
Post a Comment