My Oracle Support Banner

R12 AP: APXIIMPT - Payables Open Interface Import Concurrent Program Shows No List of Values for Parameter Operating Unit (Doc ID 947303.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.
REPORT:APXIIMPT.RDF - Payables Open Interface Import
EXECUTABLE:APPRVL - Invoice Validation

***Checked for relevance on 25-Dec-2015***


Symptoms


When attempting to run Payables Open Interface import, Clicking on LOV of the Parameter: Operating Unit gives the following error:

ERROR
No entries found for list-of-values
APP-FND-01436: List-of-value cannot find any values for you to choose.
Cause: The list-of-value execution failed to find any values.
Cause: The SQL statment specify 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 (ROUTINE = fdlfch)

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Run Payables Open Interface Import
2. Click LOV of Parameter Operating Unit

Note: This issue may occur for any Concurrent Program which has parameter 'Operating Unit'.



Cause

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
Symptoms
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.