Introduction 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 MoreIntroduction: This XML data tempalte will help us to create a AR Applied Register Report in Excel format <?xml version=”1.0″ encoding=”UTF-8″?> <dataTemplate name=”xxxxx” Version=”1.0″> <parameters> <parameter name=”p_org” dat_idaType=”varchar2″ /> <parameter…
Read MoreIntroduction: This query will display the PO details(Delta extract) select prha.attribute1 triprojectnumbertx, –project_number, poh.segment1 cstPONumberTX, –po_number, cstPOUniqueKeyTX prla.attribute4 cstCostCodeIDTX, — Added this as per the latest Cost code change request.…
Read Morethis query useful to extract the Query_to_Get_ARInvoice_Balance_Due_Amount invoice details of balance due that was paid by customer query_to_get_invoice_balance_due_amount
Read MoreIntroduction: Error : failError!! Could not deliver the output for Delivery channel:null On : 12.1.3 version, XML Publisher Report Bursting Program is getting Error Out CAUSE : Bursting control…
Read MoreIntroduction: This query is about to get the advance collections related columns for the customers. SELECT HCA.CUST_ACCOUNT_ID, IST.STATUS_CODE STRATEGY_STATUS, ISTT.STRATEGY_NAME, (SELECT ISWI.STATUS_CODE FROM IEX_STRATEGY_WORK_ITEMS ISWI WHERE ISWI.STATUS_CODE IN(‘OPEN’,’PRE-WAIT’) AND ISWI.STRATEGY_ID=IST.STRATEGY_ID…
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 MoreIntroduction: This report will showing all Oracle US and Canada suppliers with payment type of XXX select AP_SUP.SEGMENT1 SUPPLIER_NUMBER ,AP_SUP.VENDOR_NAME SUPPLIER_NAME ,SUP_SITES.VENDOR_SITE_CODE SUPPLIER_SITE ,(select APT.NAME from apps.AP_TERMS_TL APT where…
Read More