OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » How to create value set (11i)

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

How to create value set [message #474003]

Wed, 01 September 2010 23:56

yknev
Messages: 38
Registered: August 2010

Member

Hi All,

I would like to create a report with Parameters. I have doubt on creation of Parameter while registering of report. Could hlep me..

My code:-

Code: [Select all] [Show/ hide]

SQL> select * from table1;

      SINO VNAME             SAL ISS_DT                                         
---------- ---------- ---------- ---------                                      
         5 ANTONY                02-SEP-10                                      
         1 SMITH            1000 01-JAN-10                                      
         2 ALLEN            2000 01-FEB-10                                      
         1 LION             2000 26-JAN-10                                      
         3 TIGER            4000 15-MAR-10                                      
           VISION           4000 13-MAR-10                                      
         3 VISION           2000 10-SEP-09                                      

7 rows selected.

SQL> select * from table1
  2  where iss_dt>='21-JAN-2010';

      SINO VNAME             SAL ISS_DT                                         
---------- ---------- ---------- ---------                                      
         5 ANTONY                02-SEP-10                                      
         2 ALLEN            2000 01-FEB-10                                      
         1 LION             2000 26-JAN-10                                      
         3 TIGER            4000 15-MAR-10                                      
           VISION           4000 13-MAR-10                                      

SQL> select * from table1
  2  where iss_dt>='21-JAN-2010'
  3  and sal is not null;

      SINO VNAME             SAL ISS_DT                                         
---------- ---------- ---------- ---------                                      
         2 ALLEN            2000 01-FEB-10                                      
         1 LION             2000 26-JAN-10                                      
         3 TIGER            4000 15-MAR-10                                      
           VISION           4000 13-MAR-10                                      

SQL> select * from table1
  2  where iss_dt>='21-JAN-2010'
  3  and sal is not null
  4  and sino is not null;

      SINO VNAME             SAL ISS_DT                                         
---------- ---------- ---------- ---------                                      
         2 ALLEN            2000 01-FEB-10                                      
         1 LION             2000 26-JAN-10                                      
         3 TIGER            4000 15-MAR-10

Now, i want to create one parameter with List of values(LOV)like

Code: [Select all] [Show/ hide]

Parameter Name:- SAL
List of Values:- ALL (i want to execute upto:- iss_dt>='21-JAN-2010')
                 SAL (I want to execute upto:- and sal is not null)            
                 SINO(my quey execute upto:- FULL Query|)

How to create the Parameters using above conditions. Please help me.

Regards,

Yknev.

Report message to a moderator

Re: How to create value set [message #474041 is a reply to message #474003]

Thu, 02 September 2010 04:26

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

What exactly is the question? Do you want to know how to create a value set to be used in the parameter.
Or do you want to create a query that has a where clause dependent on the value of a parameter?

For the first one, create a value set (system administrator/application/flexvield/validation) with type independent. And enter the ALL, SAL, SINO in the values form.

Then in your report, you can use something like: select .... from .... where (:Param = 'ALL') or (:param = 'SAL' and sal is not null) or (:param = 'SINO' and sal is not null and sino is not null)

Regards,

Arian

Report message to a moderator

Previous Topic:	User Friendly Manuals Oracle Financials
Next Topic:	lournal import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 03:27:32 CDT 2025