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 MARCH 04, 2015

Applies to:

Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Information in this document applies to any platform.

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


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms