OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Personalization issue (Oracle ebusiness suite 11.5.10 Red hat)

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

Personalization issue [message #514529]

Tue, 05 July 2011 05:30

davholla
Messages: 116
Registered: August 2009
Location: London

Senior Member

I created a personalisation so that when the values in
per_analysis_criteria.id_flex_num = '53543'
Some fields do not appear.

This is the condition I created :-

$(:ANALYSES.ID_FLEX_NUM)=to_number('53543')

I get ORA-00911: Invalid character

Any ideas on how to fix this?

[Updated on: Tue, 05 July 2011 05:46]

Report message to a moderator

Re: Personalization issue [message #514548 is a reply to message #514529]

Tue, 05 July 2011 06:11

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't use Oracle Apps., but - shouldn't it be ":=" instead of "="? Such as

$(:ANALYSES.ID_FLEX_NUM) := to_number('53543')

Report message to a moderator

Re: Personalization issue [message #514595 is a reply to message #514529]

Tue, 05 July 2011 08:44

davholla
Messages: 116
Registered: August 2009
Location: London

Senior Member

Thanks I will try that

Report message to a moderator

Re: Personalization issue [message #514936 is a reply to message #514595]

Thu, 07 July 2011 05:57

davholla
Messages: 116
Registered: August 2009
Location: London

Senior Member

Actually this is the fix

:ANALYSES.ID_FLEX_NUM='53543'

Report message to a moderator

Previous Topic:	Workflow Notification Vacation Rule
Next Topic:	How to restrict To date parameter, based on From date parameter ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 08 00:08:03 CDT 2025