My Oracle Support Banner

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 OCTOBER 17, 2017

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

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
References


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