OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Table type value set (Oracle Apps 12 & 11i)

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

Table type value set [message #498878]

Fri, 11 March 2011 13:32

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?

Report message to a moderator

Re: Table type value set [message #498915 is a reply to message #498878]

Fri, 11 March 2011 20:56

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Special Value Sets can be used in this scenario.

link 1
link 2

By
Vamsi

Report message to a moderator

Re: Table type value set [message #498958 is a reply to message #498915]

Sat, 12 March 2011 04:04

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

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Try some thing like this.

FND PLSQL 
"BEGIN
    IF ':$FLEX$.TEST_PROG_ENABLE_OD' = 'Y' THEN
       NULL;
    END IF;
END;"

By
Vamsi

Report message to a moderator

Previous Topic:	XXLAAPPS_TOP issue
Next Topic:	Collection Plan - Quality Module

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 07:52:22 CDT 2024