Logo

Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Flexfield
#3431
manos (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Flexfield 11 Years, 9 Months ago  
key flexfield segment attached to a value set is a Free text. Is it possible to make the validation format type of the value set as TitleCase?, If so how can I do it?.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3441
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Flexfield 11 Years, 9 Months ago  
Try creating a value set with validation type set as special.
Then place PL/SQL function based validation in there.

Event: Validation

Function:
FND PLSQL " declare
x_value varchar2(10) := :!value ;
begin
if <condition> then
fnd_message.set_name('FND','FND_GENERIC_MESSAGE' );
fnd_message.set_token('MESSAGE','Invalid Value');
fnd_message.raise_error;
end if;
END; "
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 
Copyright © 2009
SAP Training| Online Information Technology Training| Free IT Tutorials| Oracle Financials| Oracle Applications Training| Free Tutorials| Free Training| Excel Tutorial| Information Technology Tutorials| SQL Tutorial| PL/SQL Tutorial| Project Management Training| JDeveloper Tutorial| Oracle DBA Tutorial| Ruby on Rails Tutorial| Resources