List Of Values Cannot Be Found For POS: SM: Default Role for Internal User and POS: SM: Default Role for Supplier User Profiles
Last updated on OCTOBER 17, 2017
Applies to:Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Information in this document applies to any platform.
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.
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.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms