Introduction This Post illustrates the steps required to Project Accounting Labor Revenue in fusion Application Script to Project Accounting Labor Revenue in fusion Application SELECT prd.org_id employee_cost_org_id, prd.gl_period_name gl_period, NVL…
Read MoreIntroduction This Post illustrates the steps required to PA Invoice Detail in Fusion Application Script to PA Invoice Detail Query in Fusion Application SELECT PEI.expenditure_item_id ,PPA.segment1 project_number ,PPA.name project_name ,PPA.segment1||’-‘||pih.invoice_num…
Read MoreIntroduction This Post illustrates the steps required to AR Aging 4 Bucket with project details in fusion application Script to AR Aging 4 Bucket with project details in fusion WITH …
Read MoreIntroduction This Post illustrates the steps required to HCKT Hard Limit Reached Events in Fusion Script to HCKT Hard Limit Reached Events in Fusion Purpose Purpose of the report is to…
Read MoreIntroduction 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…
Read MoreIntroduction 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 More