Home » Applications » Oracle Fusion Apps & E-Business Suite » AOL - query
AOL - query [message #214392] Tue, 16 January 2007 04:18 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: AOL - query [message #214532 is a reply to message #214439] Tue, 16 January 2007 22:07 Go to previous message
Lachmi
Messages: 18
Registered: June 2004
Junior Member
Thanks
Previous Topic: Looking for Knowledgable Oracle Individuals
Next Topic: Sales Order Booking
Goto Forum:
  


Current Time: Sun Dec 08 18:11:55 CST 2024