Requisition Creation and Approve process in Fusion
Description A requisition is used in business as an internal document used to notify stores or the purchasing department of items that are needed or need to be ordered. It…
Read MoreFusion 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 More