Introduction This Post illustrates the steps required to get Project Unbilled Balances in Fusion Application. .Script to Project Unbilled Balances in Fusion Application. WITH FUNCTION get_rev_todate_amt ( p_contract_id IN NUMBER,…
Read MoreIntroduction 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 MoreIntroduction 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 MoreBelow 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction: 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 MoreBelow 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 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 More