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;