Cloud BI

Call Fusion BIP Using ExternalReportWSSService Webservice

In 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...

2,486 views0 comments

Business units Query-Oracle Fusion

The below Query will be handy while fetching Business unit name in r13 instance. SELECT FUBU.BU_NAME, FUBU.SHORT_CODE, FUBU.STATUS,...

Bank Statement Import and rejected Query - Oracle ERP Cloud

Imported Query : select hp.party_name "Bank Name", cba.bank_account_name, cba.bank_account_num, csh.statement_number, csl.trx_type,...

Supplier and Site Query Oracle ERP Cloud

SELECT psv.vendor_name supplier_name, psv.vendor_id supplier_id, psv.segment1 supplier_number, psv.enabled_flag,...

3,607 views0 comments

SQL Query to fetch AP Invoice Rejections-Oracle ERP Cloud

SELECT i.LOAD_REQUEST_ID, i.INVOICE_ID, i.INVOICE_NUM, i.INVOICE_DATE, i.STATUS, i.SOURCE, i.REQUEST_ID, r.LOAD_REQUEST_ID...

1,994 views0 comments

SQL Script to fetch Employee Supervisor Details- HCM Cloud

SELECT emp.person_number employee_number, mgr.person_number supervisor_emp_num, --mgr.effective_start_date supervisor_Start_dt...

3,262 views0 comments