Query to AP Supplier Invoices in FUSION
Introduction This Post illustrates the steps required to get the AP Supplier Invoices in – FUSION Application Script to AP Supplier Invoices query – FUSION SELECT gp.period_name, (SELECT ‘Q’ ||…
Read MoreAP – Employee invoices query – FUSION
Introduction This Post illustrates the steps required to get the AP – Employee invoices query FUSION Application Script to AP – Employee invoices query – FUSION SELECT gp.period_name,…
Read MoreFusion HCM – Calling a Fast Formula from another Formula
Below is a Sample Formula showing How to Call a Fast Formula from another Formula : DEFAULT FOR ASG_HR_ASG_ID is 0 DEFAULT FOR PAY_EARN_PERIOD_END is ‘4712/12/31 00:00:00’ (date) SET_INPUT(‘HR_ASSIGNMENT_ID’,ASG_HR_ASG_ID) v_asg_id =…
Read MoreFusion HCM – Getting HR Data in Fast Formula
Introduction This Post illustrates the steps required to get the hr data in fast formula-Fusion HCM Script to get the hr data in fast formula-Fusion HCM To get HR Data in…
Read MoreFusion HCM – Query for Absence Accrual Balance
Introduction This Post illustrates the steps required to Absence Accrual Balance-Fusion Application Script to Absence Accrual Balance-Fusion HCM SELECT peo.person_number emp_id, aapft.NAME absence_plan_name, acc_ent.end_bal balance FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name,…
Read MoreFusion HCM – Query for OTL Time Entries Details
Introduction This Post illustrates the steps required to OTL Time Entries Details in Fusion Application Script to OTL Time Entries Details – Fusion HCM SELECT papf.person_number emp_id, TO_DATE (TO_CHAR (sh21.start_time, ‘DD/MM/YYYY’),…
Read MoreFusion HCM – Query for Personal Payment Method Details
Introduction: This Post illustrates the steps required to get Personal Payment Method Details in Fusion HCM Script to Personal Payment Method Details in Fusion HCM SELECT per_pay.* FROM per_all_people_f peo,…
Read MoreQuery to Calling a Value Set in Fast Formula-fusion HCM
Below is a Sample Formula shows How to Call a Value set in Fast Formula : Inputs are hr_id (number), eff_st_date(text), eff_end_date(text), mode (text) l_hr_per_id = hr_id l_eff_st_date =…
Read MoreFunction To Get Bill Rate Of Employee in Specific Project in Oracle Fusion
FUNCTION get_bill_rate ( p_project_id IN NUMBER, p_person_id IN NUMBER )RETURN NUMBERAS ln_bill_rate NUMBER;BEGIN SELECT DISTINCT bro.rate INTO ln_bill_rate FROM pjb_bill_plans_b bpb, pjb_bill_rate_ovrrds bro, per_all_people_f_v ppn, (SELECT DISTINCT…
Read MoreQuery to Find AP Reimbursable Expenses in Oracle Fusion
WITH GET_PERIOD_AVG_RATE AS ( SELECT gper.avg_rate, gsob.CURRENCY_CODE AS functional_currency, gper.period_name, gper.to_currency_code FROM GL_LOOKUPS lk, GL_TRANSLATION_RATES gper, gl_sets_of_books gsob WHERE lk.lookup_type = ‘TRANSLATION_BAL_TYPE’ AND gper.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID AND lk.lookup_code = gper.actual_flag …
Read More