PGP Key Encryption in AP Payment Outbound Interface
PGP Key Encryption in AP Payments Generally, the PGP keys will be used to Encrypt and Decrypt the messages transferred between one system to another to enable the security. In…
Read MoreQuery to get tax registration at supplier level – Oracle Fusion
The below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party_name supplier_name ,SUP.segment1 supplier_number ,ZR.TAX_REGIME_CODE ,ZR.REGISTRATION_NUMBER tax_registration_number ,ZR.EFFECTIVE_FROM…
Read MoreCustom 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…
Read MoreAR 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…
Read MoreSupplier 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…
Read MoreSupplier 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…
Read MoreSupplier 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,…
Read MoreSupplier 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:…
Read MoreQuery 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…
Read MoreQuery 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 /…
Read More