Refresh Product Hub Snapshots
Use the Refresh Product Hub Snapshots scheduled process after making any changes in the catalog category setup in Oracle Product Hub before creating or viewing the Oracle Transactional Business Intelligence (OTBI) reports on catalog category hierarchy,
The scheduled process will update the catalog hierarchy OTBI reports.
When to Use
If any changes are made to catalog category setup using the import process, the Refresh Product Hub Snapshots scheduled process will be submitted as soon as the import process is complete. If a web service or the user interface is used, the changes will be automatically submitted in the next schedule. There are six scheduled windows per day.
If the OTBI reports need to be refreshed immediately, submit the Refresh Product Hub Snapshots process manually or create a custom schedule.
- Click Schedule a New Process.
- Select Refresh Product Hub Snapshots, update the criteria under Process Options or Advanced, if needed.
- Click Submit.
This process will immediately refresh all the catalog hierarchy OTBI reports.
Privileges Required
- Refresh Material View (EGI_REFRESH_MTL_VIEW_PRIV)
Specifications
Review the following before setting up this scheduled process:
| Specification | Description |
|---|---|
| Job Type |
Ad hoc job or scheduled There are six scheduled windows per day. Typically, when any changes are made to the catalog category setup and you want to update the catalog hierarchy OTBI reports immediately, you run the process as an ad hoc job. |
| Frequency | Six scheduled windows per day |
| Time of Day | If the category hierarchy is large, it’s recommended to schedule the job after work hours. |
| Duration | Variable based on the number of reports to be refreshed. |
| Compatibility | There’s no current functional need to run multiple instances of this process simultaneously. |
Parameters
None.
Troubleshooting Information
- You can view the status of the Refresh Product Hub Snapshots process in the Scheduled Processes work area.
- The validation errors and warning messages, if any, are displayed in the error log.
- Any interactive warning validations aren’t performed.
- When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area.
Related Topics
Get Catalog Category Hierarchy Updates Automatically in Reports