Oracle Applications

Saturday, October 10, 2015

EOImpl should be declared abstract

In order to avoid the error just Copy past the below lines into your EOImpl

public void setLastUpdateLogin( oracle.jbo.domain.Number n ) {}
public void setLastUpdatedBy( oracle.jbo.domain.Number n ) {}
public void setLastUpdateDate( oracle.jbo.domain.Date n ) {}
public void setCreationDate( oracle.jbo.domain.Date n ) {}
public void setCreatedBy( oracle.jbo.domain.Number n ) {}

Wednesday, October 7, 2015

Query to get employee leave history Oracle EBS

select distinct
       papf.employee_number "Employee Number",
       papf.full_name "Emp. Name",
       paat.name "Leave Name",
       paa.date_start "Start Date",
       paa.date_end "End Date"
from per_all_people_f papf,
       per_all_assignments_f paaf,
       per_absence_attendance_types paat,
       per_absence_attendances paa,
       per_business_groups pbg
where papf.person_id = paaf.person_id
   and paat.absence_attendance_type_id = paa.absence_attendance_id
   and paa.person_id = papf.person_id
   and pbg.business_group_id = paaf.business_group_id
order by 1 asc, date_start desc;

Wednesday, September 2, 2015

On-Insert Trigger Raised Unhandled Exception ORA-29273

Navigate: Profileà System.

Type % IRC: Geocode Host% in Profile and Press Find Button

Clear Site Text Box.

Save & Close.

Try again to add Location

Tuesday, August 4, 2015

FRM - 18108: Failed to load the following objects while Opening Forms in Form Builder

SOLUTION for FRM-18108: Failed to load the following objects.

Copy the PLL libraries from resource folder to local PC (e.g. C:\DevSuiteHome\resource).
Copy APPSTAND.fmb from US folder to your local PC (e.g. C:\DevSuiteHome\resource).

Add C:\DevSuiteHome\resource in variable environment.

Note: Create resource folder if it is not existing.

How to Delete Grade Rate using API in Oracle HRMS

DECLARE
   CURSOR get_pay_details IS

   SELECT * FROM pay_grade_rules_f;

   l_effective_start_date         DATE                      := NULL;
   l_effective_end_date        DATE          := NULL;
   l_grade_rule_id                  NUMBER               := NULL;
   l_object_version_number   NUMBER           := NULL;
   l_err_msg                          VARCHAR2 (500) := NULL;
   l_rate_id                            NUMBER               := NULL;

BEGIN

Before deleting the grade I would recommend you to understanding the p_datetrack_delete_mode Control Parameter.

The p_datetract_update_mode control parameter enables one to define the type of DateTrack deletion     that has to be made. This parameter is mandatory and must be set to one of the following said values:

     1. ZAP: ZAP mode Completely removes the grade rate from the database
     2. DELETE : DELETE mode Sets end date to effective date
     3. FUTURE_CHANGE : It removes all scheduled changes
     4. DELETE_NEXT_CHANGE: It removes next change

   FOR i IN get_pay_details
   LOOP
      BEGIN
         hr_grade_rate_value_api.delete_grade_rate_value (
            p_validate                => FALSE,
            p_effective_date          => SYSDATE,
            p_datetrack_delete_mode   => 'ZAP',
            p_grade_rule_id           => i.grade_rule_id,
            p_object_version_number   => i.object_version_number,
            p_effective_start_date    => l_effective_start_date,
            p_effective_end_date      => l_effective_end_date
         );

         COMMIT;
         DBMS_OUTPUT.put_line (
                                   'Grate Rate has been Deleted: ' || i.grade_rule_id
                                 );
      EXCEPTION
         WHEN OTHERS
         THEN
            l_err_msg := SQLERRM;
            DBMS_OUTPUT.put_line ('Inner Exception: ' || l_err_msg);
      END;
   END LOOP;
EXCEPTION
   WHEN OTHERS
   THEN
      l_err_msg := SQLERRM;
      DBMS_OUTPUT.put_line ('Main Exception: ' || l_err_msg);
END;