Home » Applications » Oracle Fusion Apps & E-Business Suite » Table type value set (Oracle Apps 12 & 11i)
Table type value set [message #498878] Fri, 11 March 2011 13:32 Go to next message
barnanag
Messages: 2
Registered: March 2011
Junior Member
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?
Re: Table type value set [message #498915 is a reply to message #498878] Fri, 11 March 2011 20:56 Go to previous messageGo to next message
vamsi kasina
Messages: 2095
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Special Value Sets can be used in this scenario.

link 1
link 2

By
Vamsi
Re: Table type value set [message #498958 is a reply to message #498915] Sat, 12 March 2011 04:04 Go to previous messageGo to next message
barnanag
Messages: 2
Registered: March 2011
Junior Member
I use the above FLEX condition to dinamically enable/disable a parameter. Can you help me please with how to add this flex condition to a special type validation event?

[Updated on: Sat, 12 March 2011 04:07]

Report message to a moderator

Re: Table type value set [message #498964 is a reply to message #498958] Sat, 12 March 2011 05:02 Go to previous message
vamsi kasina
Messages: 2095
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try some thing like this.
FND PLSQL 
"BEGIN
    IF ':$FLEX$.TEST_PROG_ENABLE_OD' = 'Y' THEN
       NULL;
    END IF;
END;"
By
Vamsi
Previous Topic: XXLAAPPS_TOP issue
Next Topic: Requisitions with Project Information in Error --Req Import Program Failed
Goto Forum:
  


Current Time: Thu Jul 31 08:46:15 CDT 2014

Total time taken to generate the page: 0.18487 seconds