Oracle Application Practice Blog

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

OracleAppsPractice 1:40 AM

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

OracleAppsPractice 4:21 AM

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

OracleAppsPractice 4:56 AM

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

OracleAppsPractice 5:26 AM

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

OracleAppsPractice 5:30 AM

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

OracleAppsPractice 5:13 AM

Follow Us

Oracle HCM

About Me

Followers

Views