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

Oracle Fusion: BPM - SQL Query to Get Approval Group Details

 SELECT 

FWG.APPROVALGROUPID ,

PPNF.DISPLAY_NAME EMP_NAME,

PAPF.PERSON_NUMBER EMP_NUM,

FWGM.MEMBER USER_NAME, 

FWGM.TYPE, 

FWGM.SEQUENCE,

FWG.APPROVALGROUPNAME

FROM 

FA_FUSION_SOAINFRA.WFAPPROVALGROUPS FWG,

FA_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS FWGM,

PER_USERS PU,

PER_PERSON_NAMES_F PPNF,

PER_ALL_PEOPLE_F PAPF

WHERE 1=1

AND FWG.APPROVALGROUPID = FWGM.APPROVALGROUPID

AND FWGM.MEMBER=PU.USERNAME

AND PU.PERSON_ID=PPNF.PERSON_ID

AND PPNF.NAME_TYPE='GLOBAL'

AND PAPF.PERSON_ID=PPNF.PERSON_ID

AND PAPF.PERSON_NUMBER = NVL(:P_EMP_NUM,PAPF.PERSON_NUMBER)

AND FWGM.MEMBER=NVL(:P_USERNAME,FWGM.MEMBER)

GROUP BY

PPNF.DISPLAY_NAME ,

PAPF.PERSON_NUMBER ,

FWGM.MEMBER , 

FWGM.TYPE, 

FWGM.SEQUENCE,

FWG.APPROVALGROUPNAME

ORDER BY PPNF.DISPLAY_NAME ,FWG.APPROVALGROUPNAME