Reflect Changes from Edited Reports Sooner

When you use the Customize option to edit a predefined report, your changes won't be reflected until a refresh that happens every 24 hours. For changes to take effect sooner, use profile options to change the refresh interval.

The refresh applies your changes to Oracle Fusion Cloud Applications, but you can immediately see your changes in Microsoft Word and Oracle Analytics Publisher. For example, you download a predefined .rtf layout template and edit the file in Word. You can see the modified output using the preview in Word. After you upload the .rtf file to the catalog, you can open the report in Analytics Publisher and see your changes. But, if you're accessing the report from Fusion Applications, you see the updated output only after the refresh.

When you're done configuring and testing reports, use the same profile options to turn the refresh back to every 24 hours. But even if you don't, the refresh automatically resets to 24 hours when it's been more than 8 hours since you set the profile options. The 24-hour refresh interval helps optimize performance.

Create Profile Options to Control the Refresh

Your profile options can apply to all workflow tasks, a product family, or a product. Based on the scope you want, your profile option must have a profile option code that follows a certain format.

Scope

Profile Option Code

Examples

Global

BIP_CLIENT_REFRESH_TIME

BIP_CLIENT_REFRESH_TIME

Product Family

BIP_CLIENT_REFRESH_TIME_<FAMILY>

  • BIP_CLIENT_REFRESH_TIME_FIN

  • BIP_CLIENT_REFRESH_TIME_HCM

  • BIP_CLIENT_REFRESH_TIME_PRC

  • BIP_CLIENT_REFRESH_TIME_PRJ

  • BIP_CLIENT_REFRESH_TIME_SCM

Product

BIP_CLIENT_REFRESH_TIME_<FAMILY>_<PRODUCT>

  • BIP_CLIENT_REFRESH_TIME_FIN_AP

  • BIP_CLIENT_REFRESH_TIME_HCM_PER

  • BIP_CLIENT_REFRESH_TIME_PRC_PON

  • BIP_CLIENT_REFRESH_TIME_PRJ_PJE

  • BIP_CLIENT_REFRESH_TIME_SCM_EGO

The profile options with a smaller scope take precedence. For example, you have profile option A with a global scope and profile option B with a product scope. If you're currently configuring notifications for a particular product, use profile option B to adjust the refresh time just for that product. But based on profile option A, the refresh is still at 24 hours for all other configurable notifications in all other products. Profile option B takes precedence over profile option A only for that one product.

Tip: To find the product family or product code, go to the Setup and Maintenance work area. Use the Manage Taxonomy Hierarchy task in the Application Extensions functional area for any offering. In the hierarchy, expand the root node and then the Oracle Fusion node. Find the row for the family or product and look in the Module Key column for the code.

Now you're ready to create your profile options!

  1. In the Setup and Maintenance work area, go to the Manage Applications Core Profile Options task in the Application Extensions functional area for your offering.

  2. On the Manage Applications Core Profile Options page, click the New icon.

  3. On the Create Profile Option page, enter the profile option code in the format that corresponds to the scope you want.

  4. Enter a display name that you can easily remember to help you find the profile option later.

  5. From the Application list, select Oracle Middleware Extensions for Applications.

  6. From the Module list, select Application Core.

  7. Specify a start date.

  8. Click Save and Close.

  9. On the Manage Applications Core Profile Options page, make sure that your new profile option is selected in the Search Results: Profile Options subsection.

  10. In the <Profile Option>: Profile Option Levels subsection, select the Enabled and Updatable check boxes for the Site level.

  11. Save your work.

Set the Refresh Interval

In the Setup and Maintenance work area, go to the Manage Applications Core Administrator Profile Values task in the Application Extensions functional area. Set your profile option at the Site level and enter 15 or higher for the refresh interval in minutes. If you enter 15, your changes are reflected in Fusion Applications 15 minutes after they're saved in the BI catalog. For example, 15 minutes after you upload an edited .rtf layout template to the catalog, or after you update report properties in Analytics Publisher.

Caution: Make sure to enter a whole number.

When you're done making and testing your changes, set the profile option back to 1440, which is 24 hours in minutes. If you forget and leave your profile option as is for longer than 8 hours, don't worry! At that point, the profile option resets itself back to 1440 minutes.