header ads
Matrix Report Output 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…

HDL Tables and Query to Fetch uploaded dat file using Content ID 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 Worker Contact Upload

Worker Contact Upload

OracleAppsPractice 5:13 AM

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

Worker Upload with Multiple Assignments

OracleAppsPractice 4:43 AM

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

New Worker upload

OracleAppsPractice 4:38 AM

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 Common lookup Upload HCM Quries

HCM Common lookup Upload

OracleAppsPractice 11:31 PM

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 Query to get Employee details without Payroll HCM Quries

HCM Query to get Employee details without Payroll

OracleAppsPractice 4:59 AM

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…