create a value set that depends on another [message #254314] |
Thu, 26 July 2007 07:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Abeer30
Messages: 110 Registered: March 2007
|
Senior Member |
|
|
hello,
I am registering a report in oracle apps. I need to bind a subinventory parameter to the organization parameter in a report. Subinventory parameter list of values will depend only on the choice of the oganization from the list of values of the parameter. Both parameters i have created with validation type: table.
How can I do this?
Please help...
|
|
|
Re: create a value set that depends on another [message #254423 is a reply to message #254314] |
Thu, 26 July 2007 13:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
This will probably NOT be very helpful as I don't know Oracle Apps, so there's possibility that it is, actually, possible there. However, let me say a word or two about the issue.
As you already know, Reports Builder doesn't allow you to reference one parameter's value upon the other. That's why we created our own "parameter form" form (using the Forms Developer). It will require you to create at least two additional tables (one to store reports and its "detail" table - reports' parameters. The form is based on those tables.
List of values, if necessary, can be "linked" to another parameter.
Finally, there's a push button which runs the report (and passes those parameters to it).
I hope I correctly understood what is bothering you, but - once again - I'm not sure it will help in any way.
|
|
|
Re: create a value set that depends on another [message #254841 is a reply to message #254423] |
Sun, 29 July 2007 06:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Abeer30
Messages: 110 Registered: March 2007
|
Senior Member |
|
|
hello,
i'm sorry but i think u misunderstood me.
i have 2 separate parameters
1. org
2. subinventory
each has it own set of values.
parameter 2 lov must depend on the choice of parameter one consider it as a 2 level forest.
each parameter will need to be be created using a separate value set in oracle apps. but how can i make subinventory parameter depends on parameter org?
how can i do this with oracle apps?
|
|
|
|
|
|
|
|