Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 196 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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?
Best Answer
-
@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.
4
Answers
-
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!
1 -
Very informative and very helpful information.
Thank you very much @Ram-Oracle!
0 -
Thanks @Ram-Oracle and @Sumanth V -Oracle
0 -
Bookmarked - thanks very much for the information @Ram-Oracle
0 -
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.
0
