Fusion HCM – Automating Payroll Batch Loader
Description This post illustrates what are the steps we needs to follow for Automate payroll batch loader in Fusion Application. Below are the Steps to Automate Payroll Batch Loader :…
Read MorePROJECT UNBILLED BALANCES- FUSION
Introduction This Post illustrates the steps required to find PROJECT UNBILLED BALANCES- FUSION Application Script to PROJECT UNBILLED BALANCES- FUSION This report will display all project unbilled details. SELECT ppa.project_id, ppa.segment1…
Read MoreFusion HCM – Managing an Array Type Fast Formula
Below is a Sample Array Type Fast Formula : DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ASSIGNMENT_ID IS 0 DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ASSIGNMENT_TYPE IS ‘x’ DEFAULT_DATA_VALUE FOR PER_HIST_ASG_EFFECTIVE_START_DATE IS ‘1951/01/01 00:00:00’ (DATE) DEFAULT_DATA_VALUE FOR PER_HIST_ASG_EFFECTIVE_END_DATE IS…
Read MorePA – Project Revenue exception
Introduction This Post illustrates the steps required to project Revenue Exception in Fusion Application. Script to PA – Project Revenue exception SELECT pcdl.prvdr_gl_period_name ei_latest_gl_period_name, gcc.segment1 r_company, peia.revenue_recognized_flag ei_revenue_distributed_flag, ppat.NAME ei_project_name, ppab.segment1…
Read MoreQuery for Project Accounting Labor Revenue in fusion Application
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 MorePA Invoice Detail in Fusion Application
Introduction 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 MoreAR Aging 4 Bucket with project details in fusion
Introduction 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 MoreHCKT Hard Limit Reached Events in Fusion
Introduction 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 MoreProject 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…
Read MoreQuery 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,…
Read More