Oracle Fusion

Custom Role and Custom lookup Creation in Fusion

custom-role-and-custom-lookup-creation-in-fusion This document describes how create a custom role and custom lookup in Oracle Fusion. In this document we have listed all the required setup details with screen shot to…

AR Invoice Image Upload Using SOAP Request – Oracle Fusion

This blog contains sample payload to upload an image file in AR invoice attachments in Oracle Fusion Applications. During fusion implementation, we might come across a client requirement to upload…

Supplier Site Assignment Import Using FBDI – Fusion Applications

This blog describes the step by step process of Supplier Site Assignment migration in Fusion Application using File Based Data Import. Using this process we can assign one or more…

Supplier Site Import Using FBDI – Fusion Applications

This blog describes the step by step process of Supplier Site migration in Fusion Application using File Based Data Import. FBDI Template: SupplierSiteImportTemplate.xlsm Interface Tables: POZ_SUPPLIER_SITES_INT Base Table: POZ_SUPPLIER_SITES_ALL_M Import…

Supplier Address Import Using FBDI – Fusion Applications

This blog describes the step by step process of Supplier Address migration in Fusion Application using File Based Data Import. FBDI Template: SupplierAddressImportTemplate.xlsm Interface Tables: POZ_SUP_ADDRESSES_INT Base Table: HZ_CONTACT_POINTS, HZ_LOCATIONS,…

Supplier Import Using FBDI – Fusion Applications

This blog describes the step by step process of Supplier migration in Fusion Application using File Based Data Import. FBDI Template: SupplierImportTemplate.xlsm Interface Tables: POZ_SUPPLIERS_INT Base Table: POZ_SUPPLIERS Import Process:…

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

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

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