OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Profile Option LOV Behaving Weird ?

Home » Applications » Oracle Fusion Apps & E-Business Suite » Profile Option LOV Behaving Weird ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	apps question
Next Topic:	Oracle Applications 1159 Installation on WindowsXP Prof

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 19:26:42 CDT 2025