Oracle Fusion: How to Create New Requisition Approval Rules

 

Step1:

Navigate to: 

Setup and Maintenance > Setup Select: Procurement > Search with Manage%Approval

 

Step2: Select Header Stage > Edit Rule

 

Step3: Click on “+” Icon

 

Step4: Enter the Rule Name, Set the Priority (High/Medium/Low) & Description

Step5: Enter Condition and Action.

 

Step6:

Click on Save.

Click on Deploy.

Lets check Newly created Approval Rule is working or not.

Step7: Create Requisition.

 

Step8: Click on Manage Approval.

We can able to see the new approval coming in the approval list.

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.