Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cascading Combo Box

882750Nov 19 2011 — edited Nov 19 2011
I have a page with 2 cascading Single Once Choice (SOC). Price list SOC and Product list SOC. The requirement is that a customer ID will be sent into the page via url parameters which will filter the dropdown value for Price List. Price list SOC will drive what the Product list dropdown values are. The model design is as follows

* Price List VO with a view criteria for customer ID
* Product List VO with a view criteria for PriceList ID
* A MainVO that uses both PriceList VO and Product List VO with 2 VA (Price List ID and Product List ID) and 2 LOVs PriceListVO1 and ProductListVO1

We used the LOVs to create 2 SOCs in the page with partial trigger setting. We create an AM method to receive the value from the URL param and parse it to determine the customer id and set the PriceList view criteria. We are using a taskflow that actually receives the url values and calls the AM method to process it and set the PriceList VO and then pass the flow control to the page with SOCs.

We were able to make the following work

* Taskflow is able to receive the values from url and call the AM method
* AM method executes the logic to determine customer ID and is able to set the Price List VO customer ID and execute Price List VO query. I used VO.getrow count to check the row count and notice that the VO is correctly set

But when the Taskflow passes the control to the pages with cascading SOCs it is not working. The PriceList SOC does not have any values indicating that the VA PriceListVO1 which is based on PriceList VO does not have any rows indicating that the criteria is not set.

I dont know what I am doing wrong. I tried to programmatically access the VA - PriceListVO1 in the same AM method and set the Viewcriteria to CustomerID execute the query but the result is the same. When the taskflow is passing the control to page the PriceList VO criteria are all removed.


Kndly help

I am using Jdeveloper 11.1.1.5.0

Edited by: user4220874 on Nov 19, 2011 6:38 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2011
Added on Nov 19 2011
1 comment
224 views