1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Table type validation value set

Discussion in 'Oracle Apps Technical' started by barnanag, Mar 11, 2011.

  1. barnanag

    barnanag Guest

    Hi there,

    I need to create a value set which accepts dates and add the following condition to it :$FLEX$.TEST_PROG_ENABLE_OD = 'Y'

    In this way I must create a value set of table type validation, but must define a table and a column for the validation too. Is there any table which has a date type column and contains every day of the years? I tried to use the creation_date of the oe_order_headers_all table which works, but the validation takes more than 5 minutes, which is a lot.. Moreover, it is possible, that there is a date for which is no record in the oe_order_headers_all table...

    Do you have any ideas?

    Is that possible to use somehow that FLEX condition in a value set of Special type validation?
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Nag,
    The best suggestion is :
    First check your query in Toad or Sql Developer (what ever it be),
    and modify the query according to it.
     
  3. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    HI

    Why dont you try with Sysdate where you will not miss any date...
    Let me know will this works for you.

    Cheers
    Kamal
     
  4. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Are you looking this type of solution

    Code (SQL):
    SELECT level+trunc(sysdate) FROM dual
    CONNECT BY level <= 1000;
    if yes, create value set using this query. this query gives 1000 days advance from the sysdate.
     
  5. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    Hi Kiran,

    He is not Expecting that.
    He is using oe_order_headers_all table creation_date.
    BUt you can tell all days they will create order (ie.. today they may create order and creation_date is today date and tomorrow they wont create and day after they will create order again and tat time there is a gap in creation date).

    For that i suggested to use sysdate which will not give gap in the date column
     
    kiran.marla likes this.
  6. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Yes , You are right. sysdate will really helps in this situation.