Query to get Organization name in Fusion HCM

-
SELECT HOUFT.NAME     
      FROM FUSION.HR_ORGANIZATION_UNITS_F_TL HOUFT
     WHERE HOUFT.ORGANIZATION_ID = &P_ORG_ID
       AND HOUFT.LANGUAGE = USERENV('LANG')
       AND TRUNC(SYSDATE) BETWEEN HOUFT.EFFECTIVE_START_DATE AND
           HOUFT.EFFECTIVE_END_DATE;

Comments

Post a Comment

Popular posts from this blog

Query to get Salary Change details in Fusion HCM

-
 SELECT papf.person_number PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name, ple.name LEGAL_EMPLOYE, (CASE  when cs.SALARY_BASIS_CODE = 'ANNUAL' THEN 'Salary Change'  else  'Hourly Rate Change' end)  ACTION_NAME, to_char(cs_old.salary_amount) OLD_DATA,  to_char(CS.salary_amount) NEW_DATA    ,TO_CHAR(cs.date_from, 'MM/DD/YYYY') EFFECTIVE_DATE    ,  TO_CHAR(cs.creation_date, 'MM/DD/YYYY') CHANGED_DATE    , cs.LAST_UPDATED_BY CHANGED_BY           from  fusion.CMP_SALARY cs,           CMP_SALARY cs_old,   PER_ALL_ASSIGNMENTS_M  PAAM,   PER_ALL_PEOPLE_F PAPF   ,per_legal_employers ple          where 1 = 1    AND PAPF.PERSON_ID = P...
Read more

CAPTCHA IMAGE GENERATION IN OAF PAGE

-
Image
THE DOCUMENT DESCRIBES HOW TO CREATE CAPTCHA IMAGE IN OAF PAGE: Step 1: get captcha: // to get the captchaImage Field in OAF page(code to be written in controller)=>     OAImageBean captchaImage = (OAImageBean)webBean.findIndexedChildRecursive("CaptchaImageField");     captchaImage.setSource("captchaservlet"); Step 2: Creation of captcha servlet: Step 3:  captchaservlet code to generate captcha image: import com.sun.java.util.collections.Random; import java.awt.Color; import java.awt.Font; import java.awt.Graphics2D; import java.awt.image.BufferedImage; import java.io.IOException; import java.io.OutputStream; import javax.imageio.ImageIO; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.awt.GradientPaint; import java.awt.RenderingHints;   public class CaptchaServlet ex...
Read more

Oracle Fusion HCM :: Creating and Assigning a Work Schedule Activity

-
A  Work Schedule Activity  defines a recurring period of work for employees, including hours, shifts, and work patterns. Assigning it ensures correct time, absence, and payroll calculations. 1. Navigate to Work Schedule Activities Login to  Oracle HCM Cloud . Navigate to: My Client Groups → Work Structures → Work Schedules → Work Schedule Activities Click  Tasks → Manage Work Schedule Activities . 2. Create a New Work Schedule Activity Click  Create . Enter the following details: Name : Descriptive name for the activity (e.g., “Regular Shift”). Code : Short identifier. Description : Optional, e.g., “Standard office hours 9 AM – 5 PM.” Assignment Type : Select  Full-Time ,  Part-Time , or other relevant type. Work Hours : Specify start time, end time, and duration. Frequency : Daily, weekly, or custom recurrence pattern. Time Zone : If your enterprise spans multiple regions. Optionally, define  Breaks : Break name, start, duration, and whether it’s...
Read more