List Of Values Cannot Be Found For POS: SM: Default Role for Internal User and POS: SM: Default Role for Supplier User Profiles (Doc ID 1502965.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On : 12.1.3 version, Set Up

When attempting to set "POS: SM: Default Role for Internal User" and "POS: SM: Default Role for Supplier User" from System Administrator,
the following error occurs.

ERROR
-----------------------
Error 1:
APP-FND-01436: List of Values cannot find any values for your 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.

Error 2:
Profiles couldn't determine the valid values for profile POS_SM_DEFAULT_ROLE_SUPP. This problem is usually due to an
error in the SQL validation for that profile. Use the 'Define Profiles' form to fix the SQL Validation for the
POS_SM_DEFAULT_ROLE_SUPP profile. This error may appear immediately following an Oracle error, which gives more
information about what was wrong with the SQL Validation.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. System administrator responsibility -> Query profile POS: SM: Default Role for Supplier User at Site level
2. Try setting value to this profile
3. Errors show up

Changes

Cause

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