- Home
- Oracle HCM
- _Functional
- __Core HR
- __Absence Management
- __Learning Management System
- __Functional General
- _Technical
- __Fast Formula
- __HCM Reports
- __Workflow-Notifications
- __Page Composer
- __Technical General
- __HCM Queries
- __HCM Data Loader
- __Security
- Oracle Apps Technical
- Oracle HRMS
- OIC
- Useful Links
- _Fusion HCM
OTL SQL Queries
Oracle Fusion Time and Labor
Oracle Fusion Time and Labor 1. We can use below query to get HCM groups assigned to a person in HCM OTL. select papf.papfson_number, ppnf.last_name, ppnf.first_name, grp.group_name, mem.effective_s…
Enabling Advance Edit In HCM Extracts
Enabling Advance Edit In HCM Extracts
Enabling Advance Edit In HCM Extracts Most of you noticed after recent 24A patch we are unable to see "Advance Edit" icon in HCM Extracts. As a technical consultant it is more important fo…
HCM Scheduled Process
Schedule Process
Schedule Process Scheduled processes do tasks that are too complex or time-consuming to do manually, for example importing data or updating many records. You can run scheduled processes on a recurri…
Get Session Details for BIP Report
Get Session Details for BIP Report
Get Session Details for BIP Report We can use below session variables to get the session details like username, user roles etc in runtime. Sample Requirement: BIP report should fetch only details/re…
Pivot Reports
Matrix Report Output
Matrix Report Output We can use below tags/syntax for developing complex matrix reports. We can use below concepts both in RDF report templates and fusion BIP Report outputs. Sample Use Case We need…
Query to Fetch uploaded dat file using Content ID
HDL Tables and Query to Fetch uploaded dat file using Content ID
We can use below Query to fetch the dat file details using content id. We need to replace the content id with original content id. SELECT fl.TEXT ,bo.data_file_name FROM fusion.hrc_dl_file_li…
Worker Contact Upload
Worker Contact Upload
We can use below dat file to upload Contact details of an employee. File Name: Contact.dat METADATA|Contact|PersonNumber|StartDate|EffectiveStartDate|EffectiveEndDate|BloodType|CorrespondenceLangua…
Worker Upload with Multiple Assignments
Worker Upload with Multiple Assignments
We can use below dat file to upload Worker with multiple Assignments. Few field values might change based on the client configuration File name: Worker.dat METADATA|Worker|SourceSystemOwner|SourceS…
New Worker upload
New Worker upload
We can use below .dat file to create new worker in oracle fusion application. Few fields might change based on the client environment File Name: Worker.dat METADATA|Worker|SourceSystemOwner|SourceS…
HCM Quries
HCM Common lookup Upload
HCM Common lookup Upload Many times we face a requirement like we need to bulk upload common lookup values in oracle fusion. Below method we can use for bulk upload of lookups. Step 1: Prepare a .…
HCM Quries
HCM Query to get Employee details without Payroll
HCM Query to get Employee details without Payroll We can use below query to get employee details to whom payroll is not assigned SELECT papf.person_number ,ppnf.full_name ,paam.assignm…
HCM Reports
BIP Report Automation to DOR
BIP Report Automation to DOR We need to keep a track of letters released through bursting, thus wanted to keep a record of that via keeping a copy in DOR section. We need to make use of HCM Extract…
Oracle HRMS
Query to fetch list of Custom Reports
Query to fetch list of Custom Reports We can use below query to fetch list of custom reports which are registered under custom Module In below query we are using application ID as 20003 which refers …
Oracle HCM
HCM Design Studio
HCM Design Studio HCM Design Studio mainly used for page personalization. Using the Transaction Design Studio, you create rules to configure transactions and pages. You can change how sections and f…
Oracle HRMS
How to Correct Person Type in HRMS
How to Correct Person Type in HRMS As the title explains Person Type field in person management page is not editable but sometimes due to manual mistakes we tend to update wrong person type. We can…
Remove Template
Remove Template, Data Definition, Bursting File
Remove Template, Data Definition, Bursting File Many times we will be getting requirement to remove bursting file from data definition. Unfortunately Oracle does not provide front end option to rem…
XML Publisher Bursting
XML Publisher Bursting
XML Publisher Bursting Below is the piece of code which we will be using in XML Bursting process Step 1: Use below code in After Trigger section in Report Builder function AfterReport return boolea…
You cannot delete application users
You cannot delete application users
You cannot delete application users Below is the common error message when we tried to purge an employee from HRMS Error Message : APP-PAY-06274 You cannot delete application users Solution : Step…
Oracle HCM
GET_PLAN_BALANCE and GET_ACCRUAL_BALANCE
GET_PLAN_BALANCE and GET_ACCRUAL_BALANCE GET_PLAN_BALANCE gives you the plan balance of the last accrual run prior to effective date while GET_ACCRUAL_BALANCE gets you the balance value as of balan…
Oracle HCM
Global Absence Discretionary Disbursement Rule
Global Absence Discretionary Disbursement Rule This formula type can be used to define the limit of the amount of leave balance that a worker is eligible to request to be disbursed as cash. The f…
Social Plugin