| Profile Option LOV Behaving Weird ? [message #96527] |
Mon, 13 December 2004 07:22 |
Nitin
Messages: 35
Registered: July 1999
|
Member |
|
|
Hie,
Have created a user profile thru
Application Dev > Profile Window
Name : FO_INV_TRX_TYPE
SQL Query ~~
SQL="SELECT S.NAME "Name",
S.CUST_TRX_TYPE_ID,
'PER_BUSINESS_GROUP_ID',
S.ORG_ID,
O.NAME "Business Group"
INTO :VISIBLE_OPTION_VALUE,
:PROFILE_OPTION_VALUE,
:DERIVED_NAME,
:DERIVED_VALUE,
null
FROM RA_CUST_TRX_TYPES_ALL S,
HR_ALL_ORGANIZATION_UNITS O
WHERE S.TYPE = 'INV'
AND O.ORGANIZATION_ID = S.ORG_ID
ORDER BY S.NAME"
COLUMN=" "Name"(*), "Business Group"(*)"
HEADING=" "Name"(*), "Business Group"(*)"
TITLE="FO:TRANSACTION TYPE"
Now when i go to sys admin and set a value for this profile for a particular responsibility, the LOV ( holding the results of above query) pops up automatically as i select the profile option in the find system profile values window ,
It keeps popping up again and again until i select a value 3 to 4 times and then allows me to save it.
Can Someone let me know what is wrong here ??? Is there a problem with my query ??
Thanks
..Nitin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
