| AOL - query [message #214392] |
Tue, 16 January 2007 04:18  |
Lachmi
Messages: 18
Registered: June 2004
|
Junior Member |
|
|
How is lookups different from Value sets ?
What does FND stand for ?
How do we validate 2 parameters in a Concurrent Program without using Value Sets ?
How do we optain paramater 2 based on the parameter 1 value in the above Concurrent Program (for a Report) ?
Thanks in advance
|
|
|
|
| Re: AOL - query [message #214393 is a reply to message #214392] |
Tue, 16 January 2007 04:25  |
world.apps
Messages: 70
Registered: January 2007
Location: Hyderabad
|
Member |
|
|
Hi
I know a little bit in your question.
fnd means foundation. All foundation tables start with fnd_ as prefix.
|
|
|
|
| Re: AOL - query [message #214439 is a reply to message #214392] |
Tue, 16 January 2007 08:16 |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
Lachmi,
Value sets are used in flexfields whereas lookups are used in predefined columns. Lookups are always just a smallish list of possible values, whereas value sets also can be free text, dates, values in a specific table and a lot of other things.
Apparently, Oracle originally intended to name the Application Object Library "Foundation" and used the short name "FND". For trademark reasons they had to rename it, but they kept the short name in order to not have to perform massive changes in what had been developed.
If you want to validate the parameters passed to a concurrent program in the form where you start concurrent programs, you have to use value sets. You also can (and should) perform validation on the parameters in the concurrent program itself. If they are invalid, a descriptive error message should be printed in the log and the concurrent program should exit with an error.
As to your last question, I am not sure what you mean.
--
Aleksander Dragnes
|
|
|
|
| Re: AOL - query [message #214471 is a reply to message #214392] |
Tue, 16 January 2007 10:41 |
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
|
Senior Member |
|
|
>>>>How do we optain paramater 2 based on the parameter 1 value in the above Concurrent Program (for a Report) ?
you have to select :$FLEX$.value_set_name_of_parameter1 from dual
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
