Search This Blog

Wednesday, July 30, 2014

App-Pay-07070 Error Comes Up while Trying To Open a FastPath Form

ERROR
APP-PAY-07070: This menu option is invalid. Customization not valid for use with this form.
Cause: The menu option you have chosen has been defined to pass an incorrect form customization
name. The customization name is not valid for use with this form.


-- To implement the solution, please execute the following steps::
To implement the solutions, please follow the appropriate plan.

1) If the CustomForm has not yet been created, ensure that the responsibility used to create it is
associated with the desired Business Group ID.

a - Login to System Administrator
b - Navigate: Profile > System
c - Query the Responsibility that the form is to be created in and profile option HR:Business
Group ID.
d - Verify that the value associated with the profile option is valid. If it is inappropriate,
either change it or find a responsibility where the value of this profile option is appropriate.


2) If the CustomForm has already been created and you are now trying to attach to a
responsibility, verify the Business Group ID associated with the CustomForm.

a - Login to US HRMS Manager
b - Navigate: Security > CustomForm
c - Query the CustomForm in question.
d - On the menu toolbar, select Help > Diagnostics > Examine
NOTE: This will require a password that may need to be obtained from the IT team.
e - Query Block = PCR, Field = Business Group ID
f - Verify the value of the Business Group ID.
g - Login to System Administrator
h - Navigate: Profile > System
i - Query the Responsibility that the form is to be created in and profile option HR:Business
Group ID.
j - Verify that the value in the profile option matches the value associated with the CustomForm.

FND_SESSION in Custom Responsibility Session Effective Date Setting


Sunday, July 20, 2014

Salary Change Query in Oracle HRMS/Payroll

select papf.employee_number,     
       papf.full_name,
       ppp_old.proposed_salary_n old_sal,
       ppp_new.proposed_salary_n new_sal,
       ppp_new.change_date
--,ppp_old.last_change_date,ppp_new.last_change_date
  from apps.per_all_people_f      papf,
       apps.per_all_assignments_f paaf,
       apps.per_pay_proposals     ppp_old,
       apps.per_pay_proposals     ppp_new
where 1 = 1
   and papf.person_id = paaf.person_id
   and paaf.assignment_type = 'E'
   and paaf.primary_flag = 'Y'
   and paaf.assignment_id = ppp_old.assignment_id
   and trunc(sysdate) between papf.effective_start_date and
       papf.effective_end_date
   and trunc(sysdate) between paaf.effective_start_date and
       paaf.effective_end_date
      --and ppp_new.change_date between trunc(sysdate) - 60 and trunc(sysdate)
      --and ppp_new.approved = 'Y'
   and ppp_new.assignment_id = paaf.assignment_id
   and ppp_new.last_change_date = ppp_old.change_date
   and ppp_new.change_date =
       (select max(x.change_date)
          from per_pay_proposals x
         where x.assignment_id = paaf.assignment_id)

   and paaf.assignment_id = 282416

Grade Change Query in Oracle HRMS

select papf.employee_number,papf.full_name,
pg_old.name old_grade, pg_new.name new_grade,paaf_new.effective_start_date change_date
from apps.per_all_people_f papf,
apps.per_all_assignments_f paaf_old,
apps.per_grades pg_old,
apps.per_all_assignments_f paaf_new,
apps.per_grades pg_new
where 1=1
and papf.person_id = paaf_old.person_id
and papf.person_id = paaf_new.person_id
and paaf_old.person_id = paaf_new.person_id
and paaf_old.assignment_type = 'E'
and paaf_old.primary_flag = 'Y'
and paaf_new.assignment_type = 'E'
and paaf_new.primary_flag = 'Y'
and pg_old.grade_id = paaf_old.grade_id
and pg_new.grade_id = paaf_new.grade_id
and paaf_old.grade_id <> paaf_new.grade_id
and trunc(paaf_old.effective_end_date)+1 =trunc(paaf_new.effective_start_date)
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
and  trunc(sysdate) between paaf_new.effective_start_date and paaf_new.effective_end_date