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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.