Change workflow notifications refresh time in Oracle Fusion

Configurable workflow notifications refresh every 24 hours for better performance. So, if you have made some changes in workflow notifications it will reflect after 24 hours. To change this default behavior you have to use profile options to control when notifications reflect the changes you upload to the BI catalog. You can use these profile options to change the timing of this refresh. After testing you can turn back the refresh to 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.

Order of precedence is decided on Scope:

• Product - Highest 
• Product Family  - Higher than Global but lower than Product scope
• Global - Lowest

For example, if you have defined two profile options one with Product scope and the other with Global scope, in that case, Product scope takes precedence, and whatever the refresh time that you have put in Product scope it will be applied.

Now to define the profile options, follow these steps:

• Log in to your cloud instance
• Go to Setup and Maintenace, by going to Settings and Actions.

• Click on the Application Extensions functional area and select All Tasks in the Show drop-down and open the task Manage Applications Core Profile Options. 

• Search for BIP_CLIENT_REFRESH_TIME to check if the profile option is already there. If not found click on Add button to create a new profile option.

You can also run the below query to check it. 

SELECT *
FROM   fnd_profile_options
WHERE  profile_option_name LIKE 'BIP_CLIENT_REFRESH_TIME%'  

To know application name, short name and id use the below SQL:

SELECT fa.application_id,
       fa.application_short_name,
       fat.application_name
FROM   fnd_application fa,
       fnd_application_tl fat
WHERE  fa.application_id = fat.application_id
       AND fa.application_id = 0 ; 

To know about module names use the below SQL:

SELECT ft.module_id,
       ft.module_name,
       ft.module_type,
       ft.module_key,
       ft.product_code,
       ftt.user_module_name,
       ftt.description
FROM   fnd_appl_taxonomy ft,
       fnd_appl_taxonomy_tl ftt
WHERE  ft.module_id = ftt.module_id
       AND ft.module_name = 'FndAppCore' ;

• Enter the below details to create the profile option and click the Save button

• If you want to provide drop-down to select the value for this profile option you can use the below SQL and put it in SQL Validation:

SELECT '15 minutes' meaning,

       '15'         lookup_code

FROM   dual

UNION

SELECT '30 minutes' meaning,

       '30'         lookup_code

FROM   dual  

• In case you want True/False value for any profile option value use the below SQL:

SELECT meaning,

       lookup_code

FROM   fnd_lookups

WHERE  lookup_type = 'FND_TRUE_FALSE_TYPE' 

 

• In Profile Option Levels, select Enabled and Updatable at the Site Level. Click the Save button once done.

• Open the task Manage Applications Core Administrator Profile Values 

• Search for BIP_CLIENT_REFRESH Profile Option Code and click the Add button to add a new Profile Value

• Add a new value at the Site level and 15 as Profile Option Value and save your work. It will set the refresh time as 15 minutes.

• Once you're done with your testing you can revert the value to 24 hours by setting the profile value as 1440 (minutes). Even if you don't change it the value will be reverted to 1440 after 8 hours.

Source: https://docs.oracle.com