Oracle Communities

Oracle Analytics and AI

Child Item

How can we manually trigger refresh for fusion pipeline even we have scheduled refresh in place

Hello,

How can we manually trigger a refresh for the Fusion pipeline? I attempted to do this by selecting 'Enterprise Resource Planning' and then choosing 'Refresh Data' for the functional area General Ledger. However, I received the error message below:
"An incremental load is scheduled to run in the next few hours. Please submit an ad hoc data refresh request after some time."

We cannot afford to wait until the next day for the data to be refreshed. Is there a way to manually trigger the refresh right now?

Find more posts tagged with

FDI

Fusion AI Data Platform

Accepted answers

Ram-Oracle

@Vrinda Choraria your daily incremental load starts at 5:30pm india time and on average the loads are completing at 9:30pm and from pipeline settings ,please check last refresh date and once todays loads are completed ,you can submit the ad-hoc request GL functional area.

You can't submit a data pipeline for a functional area in the following situations:

Load in progress: If an incremental load is in progress.
An impending load: If an incremental load is scheduled to run in the next hour.
Exceeded the number of daily refresh requests: The maximum number of ad hoc data refresh requests for the day is four. If you've exceeded this number, then you can submit a request the following day.

https://docs.oracle.com/en/cloud/saas/analytics/22r2/fawag/data-pipelines-functional-areas.html

All comments

Sumanth V -Oracle

@Vrinda Choraria -

There is no other option to refresh the data instantly apart from using the 'Refresh Data' option. However, the error indicates that your incremental load is scheduled to start in a few hours. Since 'Refresh Data' also performs an incremental load, it is being skipped or merged with the upcoming incremental load schedule. Thank you!

Ram-Oracle

You can't submit a data pipeline for a functional area in the following situations:

Load in progress: If an incremental load is in progress.
An impending load: If an incremental load is scheduled to run in the next hour.
Exceeded the number of daily refresh requests: The maximum number of ad hoc data refresh requests for the day is four. If you've exceeded this number, then you can submit a request the following day.

https://docs.oracle.com/en/cloud/saas/analytics/22r2/fawag/data-pipelines-functional-areas.html

Bhaskar Konar

Very informative and very helpful information.

Thank you very much @Ram-Oracle!

Vrinda Choraria

Thanks @Ram-Oracle and @Sumanth V -Oracle

Clare Murtagh

Bookmarked - thanks very much for the information @Ram-Oracle

PRATHEEK

Thank you Oracle team for your answers-.

@Sumanth V -Oracle @Ram-Oracle

Just following up on this post could anyone recommend the best approach or best practices for scheduling regular data reload jobs from Fusion ERP into the FDI environment? This is currently a key requirement for FDI-ERP Analytics.