Skip to Main Content

E-Business Suite

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!

Adstrtal.sh script does not startup forms_server1 managed server

Jenny zhenJul 28 2020 — edited Feb 9 2021

Hello, we have downloaded fresh install R1224 from edelivery, everything works fine but when we startup the application use Adstrtal.sh script, it can not startup forms_server1 managed server

we have to manually start it up, the same for shutdown, have to shutdown it manually.  which is very strange.

any idea what the problem should be? everything up and running fine after bring it up

Thanks

This post has been answered by Jenny zhen on Jul 29 2020
Jump to Answer

Comments

Tom Petrus

1/ Give your chart region a static ID. (eg I used "chart2" in my sample code)

2/ Create a dynamic action to fire on Page Load with true action execute javascript. Use this code2

AnyChart.getChartById($("#chart2_chart object").attr("id"))

.addEventListener("pointClick", function(e){

  alert("Value of selected datapoint: " + e.data.YValue);

  $s("P2_SELECTED_VALUE", e.data.YValue);

});

You will need to change 2 things in this code:

2.1:  the chart selector: "#chart2_chart object" . Since I gave my chart region a static ID of chart2 you will need to change that portion of the selector to the id you gave yours.

Eg if you call it

emp_chart

this selector would become

"#emp_chart_chart object"

2.2: the affected item: I am storing the selected datapoint value into an item called P2_SELECTED_VALUE. Change this to an item's name on your page (remember that if this item is hidden you may want to set the "Protect Value" property to "No" if the page is being submitted at all).

Basically, this code attaches an event listener to the chart throug the AnyChart javascript API to the pointClick event. This event occurs when you selected a datapoint on the chart. In the function I first show an alert which will show you the selected value (not label!) and then set this value in a page item. Because the $s function from apex is used this will also trigger a change event on the item.

3/ Next, edit your to-be-affected report region and add the item you are storing the value in to the "Page Items To Submit" item. This will ensure that the correct value is used to filter the report data when it is refreshed.

4/ Then finally, create another dynamic action to fire "On Change" of the item which will hold the selected value. As a true action set it to refresh the report region.

Alternatively, you could skip creating this extra dynamic action and just refresh the report region by doing this from the pointclick event handler by doing

$("#report_region_id").trigger("apexrefresh");

But you may like using a dynamic action for this better because you'll have less javascript to worry about or you might like how the dynamic action exposes more of what happens. Whichever you fancy more!

1 - 1

Post Details

Added on Jul 28 2020
10 comments
62 views