Introduction This Post Provides the SQL Query to get Last Run Parameter Value in BI Report Query SELECT TO_DATE (SUBSTR (rpj.VALUE, INSTR (rpj.VALUE, ‘”}’) – 10, 10), ‘MM-DD-YYYY’) eff_date…
Read MoreIntroduction This Post Provides the SQL Query that returns the Assignment Details of the Employees Query SELECT peo.person_number employee_number, loc.internal_location_code location_code, loc.location_name LOCATION, per_name.last_name, per_name.first_name, per_name.middle_names middle_name, pa.address_line_1, pa.address_line_2,…
Read MoreThis 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 MoreThis 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 MoreThis 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 MoreThis 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 MoreDescription Step how to Define a PROJECT in FUSION Applications. Define the Implementation Project. Please find the below steps to define a project Step1: Login as Application User. Step2: you will be…
Read MoreStep1: Click on Next button to assign Offerings and Options. Which we have planned to implement. we will navigate to Select offerings to implement window as below Step2: we are assuming…
Read MoreDescription Step how to Define a CALENDAR in FUSION Applications. 1 Define a CALENDAR Please find the below steps to define a CALENDAR Step1: Login as Application User Step2: you will be in home page as…
Read MoreDescription Step how to Add a Year to the CALENDAR in Fusion Applications. When a financial year ends and starts a new financial year, we have to define calendar in advance Please follow the below…
Read More