REVERSE CHARGE MECHANISM
Reverse charge is a mechanism where the recipient of the goods and/or services is liable to pay GST instead of the supplier. Normally, the supplier of goods or services pays…
Read MorePROJECT UNBILLED BALANCES- FUSION
This report will display all project unbilled details. SELECT ppa.project_id, ppa.segment1 project_number, NVL ((SELECT pt.project_type FROM pjf_project_types_tl pt, pjf_projects_all_vl…
Read MoreHCKT Hard Limit Reached Events in Fusion
Purpose of the report is to display project hours and hard-limit amount with interactive mode. with XXANSR_PA_EVENTS_cte as (SELECT evt.ROWID as “ROW_ID”, evt.event_id as “EVENT_ID”,…
Read MoreREVENUE TRANSFER REPORT (FUSION)
Purpose of this report is to derive all projects expenditure and event details with cost information. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number,…
Read MoreASSET DEPRECIATION LOGIC QUERY
This query fetches the details of those assets which are partially and fully depreciated. SELECT ASSET_CATEGORY_ID ,MAJOR_CATEGORY ,OPENING_DAY_ASSET_COST ,OPEN_ACC_ASSET_COST_FY …
Read MoreNEW ASSETS ADDITION QUERY
This query fetches the detailed information related to those assets which are added newly for a particular period. SELECT FAL.segment1 SOL_ID ,FFV.description BRANCH_NAME …
Read MoreLeases which are expiring 15,30,60,180 days before respectively
This query fetches those leases which are going to expiry within 15,30,60,90,180 days respectively based on the parameter. SELECT GCC.segment4 SOL_ID ,gl_flexfields_pkg.get_description_SQL(GCC.chart_of_accounts_id ,4,GCC.segment4) BRANCH_NAME …
Read MoreFusion 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 0DEFAULT 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 = ASG_HR_ASG_ID l_date_earned…
Read MoreFusion HCM – Calling a Value Set in Fast Formula
Below 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_idl_eff_st_date = eff_st_datel_eff_end_date =…
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 ‘4712/12/31 00:00:00’…
Read More