[OAUGNet]-PA_DEFAULT_EXP_ORG

["Zimmerman, Wade" <zimmermanwade@lcsnet.com>]

I am attempting to set the Profile Option 'PA: Default Expenditure
Organization in AP/PO' but I continue to receive the following errors:

"APP-FND-01436: List of Values cannot find any values for you to choose.
Cause: The SQL statement specified to fdlfch() failed to return any
values."

"Profiles couldn't determine the valid value for the profile
PA_DEFAULT_EXP_ORG.  The problem is usually due to an error in the SQL
validation for the profile.  Use the 'Define Profiles' form the fix the
SQL Validation....."

I have pulled the SQL and it is as follows:

"SELECT DISTINCT HRORG.name Organization, HRORG.name 
INTO  :visible_option_value ,  :profile_option_value 
FROM  HR_ORGANIZATION_UNITS HRORG, pa_all_organizations PAORG 
WHERE PAORG.ORGANIZATION_ID = HRORG.ORGANIZATION_ID 
AND  PA_ORG_USE_TYPE = 'EXPENDITURES' 
ORDER BY name"
COLUMN="Organization(30)"

If I comment the INTO line and the COLUMN line then SQL*Plus returns the
correct organizations.

Does anyone have any idea why I would not be able to update the Profile
Option?  Why there is no LOV?  

We are on 11.5.10.2, PA.M RUP4, AP.O

Regards,

Wade K. Zimmerman
ERP Financial Systems Manager
 
zimmermanwade@LCSnet.com
 
CONFIDENTIALITY NOTICE: This electronic mail transmission and any
documents accompanying this electronic mail transmission is intended by
Life Care Services LLC for the use of the named addressee(s)to which it
is directed and may contain information that is privileged, or otherwise
confidential.  It is not intended for transmission to, or receipt by,
anyone other than the named addressee(s) (or a person authorized to
deliver it to the named addressee(s)). It should not be copied or
forwarded to any unauthorized persons. If you have received this
electronic mail transmission in error, please delete it from your system
without copying or forwarding it, and notify the sender of the error by
reply e-mail or by calling Life Care Services LLC at (515) 875-4500, so
our address record can be corrected.
 

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>