Oracle Fusion: SQL Query to Get Reference Data Sets and their Assigned with Business Units

 SELECT fsa.reference_group_name,

         fs.set_id,

         fs.set_code,

         fs.set_name,

         fs.description,

         bu.bu_name

    FROM fnd_setid_assignments   fsa,

         fun_all_business_units_v bu,

         fnd_setid_sets_vl       fs

   WHERE     1 = 1

         AND fsa.determinant_type = 'BU'

         AND fsa.determinant_value = bu.bu_id

         AND fsa.set_id = fs.set_id

         AND fsa.reference_group_name LIKE 'PER%'

ORDER BY reference_group_name,

         set_code,

         set_name,

         bu_name

Oracle Fusion: ADFDI sheet is blank after opening

Subject: ADFDI spreadsheet is completely blank after opening

Resolution:

1.  If you are not seeing the desktop integrator then follow the action plan in following document:
   
1. How To Instal ADFdi | How to Edit Role and Privileges for ADFDi - Download Desktop Integrator
2. Make sure you have latest version of file integrator. You can download from installer from application Navigator >> Download Desktop Integration Installer.

Now Install the Software.

Open the Excel > File > Option > Add-ins > Select Manage Com Add-ins > Click on Go

Select Oracle ADF Desktop Integration Add-in for Excel . Click Ok.

Now Close the Excel and Reopen.

Now ADFDi Addins added in the excel. User Can Open the spreadsheet without any issue.

Oracle Fusion: Foreign Currency Purchase Requisitions Creation Issue due to the Daily Rate Conversion

Subject: Enter PR Line Currency Conversion Rate Issue.

Resolution:

Navigation: Setup and Maintenance > Finance Application > Search Manage Daily Rates.

Click on Daily Rates Tab.

Search From EUR to GBP Currency conversion details for the Sep22 period. We not found Spot Conversion Rate for the 15SEP2022. We need to create Conversion Rate for this date to resolve the issue.

 

Click on Spread Sheet Button.

If SpreadSheet not asking to connect with Oracle Application than Excel ADFDi Addins are missing.

User Need to Enable those Addins. Refer below link for enabling ADFDi Addin.

Oracle Fusion: ADFDI sheet is blank after opening

We need to connect spreadsheet with oracle instance. Click on Yes

Enter User Name and Password of Oracle Application and Login.

Enter the Spread Sheet Data For Conversion Rate. Click on Submit button from the Top Menu.

Click on Ok. It will Run Background Request.

It will process the data

 

It will show record successfully Inserted.

We can verify the data from Manage Daily Rate Screen. Now we can able to see the daily rates for 15SEP2022

 

Now we user try to create foreign currency requisition system will not through an error.

 

Oracle Fusion: SQL Query to get the User Assigned Roles Access

 SELECT

    pu.user_id,

    pu.username,

    ppnf.full_name,

    prdt.role_id,

    prdt.role_name,

    prd.role_common_name,

    prdt.description,

    to_char(pur.start_date, 'DD-MON-YYYY') role_start_date,

    to_char(pur.end_date, 'DD-MON-YYYY')   role_end_date,

    prd.abstract_role,

    prd.job_role,

    prd.data_role,

    prd.duty_role,

    prd.active_flag

FROM

    per_user_roles     pur,

    per_users          pu,

    per_roles_dn_tl    prdt,

    per_roles_dn       prd,

    per_person_names_f ppnf

WHERE

        1 = 1

    AND pu.user_id = pur.user_id

    AND prdt.role_id = pur.role_id

    AND prdt.language = userenv('lang')

    AND prdt.role_id = prd.role_id

    AND nvl(pu.suspended, 'N') = 'N'

    AND ppnf.person_id = pu.person_id

    AND ppnf.name_type = 'GLOBAL'

    AND pu.active_flag = 'Y'

    AND nvl(pu.start_date, sysdate) <= sysdate

    AND nvl(pu.end_date, sysdate) >= sysdate

    AND pu.username = 'cr@gmail.com' -- Enter the Username 

ORDER BY

    pu.username,

    prdt.role_name