Monday, October 23, 2017

When submitting Concurrent Program "Invoice Print Selected Invoices" Transaction Type parameter list of values are not showing

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.

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)