Search This Blog

Friday, February 8, 2008

Calender in Concurrent Request Parameter

One of the problem with concurrent request date parameter is that we cannot attach a calendar the way we have for forms. But there is an alternate solution to have a List of values.

Create a view using following query


CREATE OR REPLACE VIEW xx_date
AS
(SELECT (TO_DATE (SYSDATE - 1 + LEVEL, 'DD-MON-RRRR')) date_range
, (TO_CHAR (SYSDATE - 1 + LEVEL, 'Month, DD RRRR')) date_word
FROM DUAL x
CONNECT BY LEVEL <= 1000)

In the above query sysdate can be replaced with the date range as per requirement. Also the above query will result in 1000 records which can be altered by changing the connect by level value.

Now that we have created a view, a table value set can be created based on it and this can be used in the request parameter.

4 Comments:

Rama Krishna Mateti said...

Hi Suresh,

I could not able to create a value set using the above query as I am getting the following error message,
Test of value set XX_DATE failed with the following error message
ORA - 00902, Table / View does not exist,
select date_range value,date_word description from xx_date where rownum = 1

Suresh Vaishya said...

Have you created the view using the query mentioned. What is the step that you used and why are you using rownum=1 in your condition.

You can also refer to my post
Calender in Concurrent program. to create calendar LOV

vvvv said...

Dear Suresh,

How to create a Special Value set?
Can u plz help me?

Thanks and Regards,
Venkat

OracleAppsCentral said...

Amazing! Really helpful tip.

Copyright (c) All rights reserved. Presented by Suresh Vaishya