Oracle Application

Tuesday, 26 November 2019

Subject: Specific user not getting a workflow notification in system or email for any transaction.

Solution:

Step 1: Run following query for specific username.

Sql Query:

select name, notification_preference

from apps.wf_users

where notification_preference = 'DISABLED'

and status = 'ACTIVE'

and name='2346';

- Current user account notification preference is disabled required to enable.

Step2: Required to enable User account notification preference.

Step3: Login with Specific User Account.

Step4: Click on Preference link.

Step5: The bottom part of the window ensure that their notification preference is set appropriately.

Step6: Required to set Email Style= ‘HTML mail with Attachments’ and click on the Apply button.

- Now in future this user will get notification & attachment after enable those preference settings.

- If you check this user details using the same query, now it will not found in the query list.

Requirement: Oracle Report will give output for specific code combination only which is based on User Security profile option.

Step1: Required to create a parameter

Step2: Create Flexfield with following details.

- Now when you run the report it will give output for only those account which is enabled at User Security profile for that user.

Note:

1. we have to use the table GL_CODE_COMBINATION_KFVS main Dataset table alias name in Code Combination Table Alias name in configuration

2. We can enable User Security profile on Dataset level only not on Parameter level using this process.

Requirement: 7 decimal numeric string required to arrange in numeric sequence.

Example:

2.1

2.1.1

2.1.2.3

2.1.2.3.4

2.1.2.3.4.5

2.1.2.3.4.5.6

2.1.2.3.4.5.6.7

Solution:

SQL Order BY syntax:

Note: Required to replace the ‘COLUMN_NAME’ as per your requirement and add into the SQL query.

order by