Fusion

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

Fusion HCM – Query for OTL Time Entries Details

Introduction This Post illustrates the steps required to OTL Time Entries Details in Fusion Application Script to OTL Time Entries Details – Fusion HCM SELECT papf.person_number emp_id, TO_DATE (TO_CHAR (sh21.start_time, ‘DD/MM/YYYY’),…

Fusion HCM – Query for Personal Payment Method Details

Introduction: This Post illustrates the steps required to get Personal Payment Method Details in Fusion HCM Script to Personal Payment Method Details in Fusion HCM SELECT per_pay.* FROM per_all_people_f peo,…

Query to Calling a Value Set in Fast Formula-fusion HCM

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_id l_eff_st_date =…

Function To Get Bill Rate Of Employee in Specific Project in Oracle Fusion

FUNCTION get_bill_rate ( p_project_id IN NUMBER, p_person_id IN NUMBER )RETURN NUMBERAS ln_bill_rate NUMBER;BEGIN SELECT DISTINCT bro.rate INTO ln_bill_rate FROM pjb_bill_plans_b bpb, pjb_bill_rate_ovrrds bro, per_all_people_f_v ppn, (SELECT DISTINCT…

Query to Find AP Reimbursable Expenses in Oracle Fusion

WITH GET_PERIOD_AVG_RATE AS ( SELECT gper.avg_rate, gsob.CURRENCY_CODE AS functional_currency, gper.period_name, gper.to_currency_code FROM GL_LOOKUPS lk, GL_TRANSLATION_RATES gper, gl_sets_of_books gsob WHERE lk.lookup_type = ‘TRANSLATION_BAL_TYPE’ AND gper.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID AND lk.lookup_code = gper.actual_flag …

Query to Find NonBillable Expense in Oracle Fusion

SELECT pcdl.prvdr_gl_period_name gl_period, trx_org.NAME expenditure_organization, prb.project_id, NVL (prb.segment1, ‘N/A’) project_number, NVL (prl.NAME, ‘N/A’) project_name, NULL project_type_class_code, ppn.full_name employee_vendor, papf.person_number employee_number, ptv.task_name, pec.expenditure_category_name expenditure_category, pet.expenditure_type_name expenditure_type, pcdl.prvdr_gl_date week_ending, pei.expenditure_item_date expenditure_date, pcdl.denom_currency_code…

Query to Find Project Estimation To Complete in Oracle Fusion

SELECT A.PROJECT_STATUS, A.OPERATING_UNIT_NAME, A.AGREEMENT_TYPE, A.PROJECT_ORGANIZATION_NAME, A.PROJECT_NUMBER, A.PROJECT_NAME, A.START_DATE, A.COMPLETION_DATE, A.TASK_NUMBER, A.TASK_NAME, A.PROJECT_CURRENCY, ROUND(A.BUDGETED_REV_PROJ_CURR) BUDGETED_REV_PROJ_CURR, ROUND(A.ACTUAL_REV_ITD_PRJ_CURR) ACTUAL_REV_ITD_PRJ_CURR, ROUND(A.BILLABLE_HOURS_ACTUAL_ITD) BILLABLE_HOURS_ACTUAL_ITD, ROUND(A.TOTAL_HOURS_ACTUAL_ITD) TOTAL_HOURS_ACTUAL_ITD, A.FUNC_CURRENCY, ROUND(A.ACTUAL_REV_ITD_FUNC_CURR) ACTUAL_REV_ITD_FUNC_CURR, (ROUND ( ( (A.ACTUAL_REV_ITD_PRJ_CURR /…

Query to Find Projects Not Accruing Revenue in Oracle Fusion

–**** Project Not Accruing Revenue Due to Expenditure Exception ****– SELECT PE.accounting_period AS GL_PERIOD ,OKH.contract_number ,OKL.line_number ,PPA.segment1 AS project_number ,PPA.name AS project_name ,PT.task_number ,PT.task_name ,PEI.expenditure_item_id trx_number ,PEC.expenditure_category_name ,NVL(PPN.full_name, PS.vendor_name) AS…

Query to find AR Open Balance Of a Project in Oracle Fusion

WITH FUNCTION get_outstanding_amount ( p_payment_schedule_id IN NUMBER, p_as_of_date IN DATE, p_invoice_type IN VARCHAR2, p_amt_due_remaining IN NUMBER, p_amount_applied IN NUMBER, p_amount_adjusted IN NUMBER, p_amount_credited IN NUMBER, p_amount_in_dispute IN NUMBER, p_amount_adjusted_pending IN …

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