Fusion

Project Details – Auditor Query – FUSION

Introduction This Post illustrates the steps required to get Project Details in fusion Application. Script to Project Details in FUSION SELECT DISTINCT PPA.project_status_code ,HOU.name organization_name ,PPA.description ,OCT.name contract_type ,PPT.project_type ,PPA.segment1…

Query for Project Unbilled Balances – FUSION

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,…

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’ ||…

AP – 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,…

Fusion 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 =…

Fusion 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…

Fusion 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,…

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey