Checking operating system version: must be 5.0, 5.1, 5.2. Actual 6.1 Failed

Follow the below steps to solve this issue:

1. Copy the installation folder to your local harddesk.
2. Search the folder for oraparam.ini.    
3. Edit the file using notepad.
4. Add 6.1 to the below section.    
5. Save the file and start the installation again.

Unable To Install Oracle Workflow Builder On Windows

Oracle Workflow Builder Client has not been Certified yet to run on Windows 64bit.

To configure the compatibility mode for an application, just locate the installation directory.

    1. Navigate to the WF Builder installer (setup.exe) in the file system

  


 2. Right-Click on the “setup.exe” > then go to Properties

  


 3. Check Compatibility Mode and  Select “Windows XP (Service Pack 3)”

    4. Press OK Button
    5. Now restart the Installer for the Workflow Builder.

Query to get User name and related assigned responsibilities

select fu.user_name "User Name",
         frt.responsibility_name  "Responsibility Name"
 from fnd_user fu,
         fnd_user_resp_groups furg,
         fnd_responsibility_tl frt,
         fnd_application_tl fat
where fu.user_id = furg.user_id
   and frt.application_id = fat.application_id
   and furg.responsibility_application_id = frt.application_id
   and furg.responsibility_id = frt.responsibility_id
   and ltrim(rtrim(fu.user_name)) is not null
order by 1 asc nulls last;

EXP-00091: Exporting questionable statistics.

Please use STATISTICS=None while export.
or
set export NLS_LANG=american_america.AR8ISO8859P6

Query to Find All Active Employees and Current Salary

select distinct
       ppf.employee_number "Employee Number",
       ppf.full_name       "Employee Name",
       ppt.user_person_type "Person Type",
       ppp.proposed_salary_n "Basic Salary",
       ppp.change_date       "Change Date",
       ppp.next_sal_review_date "Next Review Date"
from per_people_f ppf,
       per_assignments_f paf,
       per_pay_proposals ppp,
       per_person_types ppt,
       per_person_type_usages_f pptu
 where ppf.person_id     = paf.person_id
   and paf.assignment_id = ppp.assignment_id
   and ppf.employee_number is not null
   and ppp.change_date in (
                            select max(ppp1.change_date)
                              from per_pay_proposals ppp1
                             where ppp1.assignment_id = paf.assignment_id
                               and ppp1.approved = 'Y'
                          )
   and paf.payroll_id = 1131
   and :p_effective_date between ppf.effective_start_date and ppf.effective_end_date
   and :p_effective_date between paf.effective_start_date and paf.effective_end_date
   and ppf.person_id   = pptu.person_id
   and ppf.effective_start_date between pptu.effective_start_date and pptu.effective_end_date
   and pptu.person_type_id = ppt.person_type_id
   and ppt.system_person_type = 'EMP'
order by ppp.change_date desc,
         lpad(ppf.employee_number,10,0),
         ppp.proposed_salary_n,
         ppf.full_name asc; 

Query to Find out all Earning and Deduction Elements and values after running Payroll

select ppx.employee_number "Employee Number",
         ppx.full_name "Employee Name",  
         to_char(ppa.effective_date,'dd/mm/yyyy') "Effective Date",
         ptp.period_name "Period Name",  
         sum(decode(pecv.classification_name,'Earnings', prrv.result_value,0)) Earnings,
         sum(decode(pecv.classification_name,'Voluntary Deductions',
                                         prrv.result_value, 'Involuntary Deductions',
                                         prrv.result_value, 'Employer Charges',
                                         prrv.result_value, 0
                            )
               ) Deductions
  from per_people_x ppx,
          per_assignments_x pax,
          pay_assignment_actions paa,
          pay_payroll_actions ppa,
          pay_run_results prr,
          pay_run_result_values prrv,
          pay_element_types_f petf,
          pay_input_values_F pivf,
          per_time_periods ptp, '
          pay_element_classifications_vl pecv
where ppx.person_id = pax.person_id
    and pax.assignment_id = paa.assignment_id
    and paa.assignment_action_id = prr.assignment_action_id 
    and ppa.payroll_action_id = paa.payroll_action_id
    and prr.element_type_id = petf.element_type_id
    and pivf.element_type_id = petf.element_type_id
    and prrv.run_result_id = prr.run_result_id
   and prrv.input_value_id = pivf.input_value_id
   and ptp.time_period_id = ppa.time_period_id
   and petf.classification_id = pecv.classification_id
   and pivf.name = 'Pay Value'
   and ppx.person_id = 5
group by ppx.employee_number,
          ppx.person_id,
          ppx.full_name,
          ppa.time_period_id,
          ppa.effective_date,
          ptp.period_name,
          pax.organization_id;