Sandeep SatyavoluApr 7, 20221 minCall Fusion BIP Using ExternalReportWSSService WebserviceIn this Post I will outline the steps to call a webservice using SOAP UI. you need below components to get start with . A report Created...
Sandeep SatyavoluSep 20, 20201 minBusiness units Query-Oracle FusionThe below Query will be handy while fetching Business unit name in r13 instance. SELECT FUBU.BU_NAME, FUBU.SHORT_CODE, FUBU.STATUS,...
Sandeep SatyavoluJul 26, 20201 minBank Statement Import and rejected Query - Oracle ERP CloudImported Query : select hp.party_name "Bank Name", cba.bank_account_name, cba.bank_account_num, csh.statement_number, csl.trx_type,...
Sandeep SatyavoluJul 2, 20201 minSupplier and Site Query Oracle ERP CloudSELECT psv.vendor_name supplier_name, psv.vendor_id supplier_id, psv.segment1 supplier_number, psv.enabled_flag,...
Sandeep SatyavoluJul 2, 20201 minSQL Query to fetch AP Invoice Rejections-Oracle ERP CloudSELECT i.LOAD_REQUEST_ID, i.INVOICE_ID, i.INVOICE_NUM, i.INVOICE_DATE, i.STATUS, i.SOURCE, i.REQUEST_ID, r.LOAD_REQUEST_ID...
Sandeep SatyavoluJul 1, 20201 minSQL Script to fetch Employee Supervisor Details- HCM CloudSELECT emp.person_number employee_number, mgr.person_number supervisor_emp_num, --mgr.effective_start_date supervisor_Start_dt...