Summary

Ideas on how to design a custom SQL for Oracle Analytics Cloud Data Sync on-prem

Content

Greetings!
I have just finished installing Oracle Analytics Cloud Data Sync on a machine on-prem which I would like to use for reading Suppliers and account combinations from our ERP Fusion Cloud.

It seem's as if I am only able to use VO's provided by Oracle to use the "SQL" within Oracle Analytics Cloud Data Sync.

Does anybody know how I can design and use a custom raw sql to use with Oracle Analytics Cloud Data Sync.

Please have a look at the query running today on our Ebusiness from 2001!

Version

Fusion ERP 20D

Code Snippet

        SELECT
                PV.SEGMENT1,
                PVS.VENDOR_SITE_CODE,
                PV.VENDOR_TYPE_LOOKUP_CODE,
                PV.VENDOR_NAME,
                PVS.ORG_ID,
                PVS.ADDRESS_LINE1,
                PVS.ADDRESS_LINE2,
                PVS.ADDRESS_LINE3,
                PVS.CITY,
                PVS.STATE,
                PVS.PROVINCE,
                PVS.ZIP,
                PVS.COUNTRY,
                APT.NAME,
                PVS.LAST_UPDATE_DATE,
                PVS.INVOICE_CURRENCY_CODE,
                PVS.INACTIVE_DATE,
                APB.BANK_NAME,
                APB.BANK_BRANCH_NAME,
                APB.BANK_BRANCH_TYPE,
                APBAA.BANK_ACCOUNT_NAME,
                APBAA.BANK_ACCOUNT_NUM,
                APBAA.BANK_ACCOUNT_TYPE,
                APBAA.GLOBAL_ATTRIBUTE_CATEGORY,
                APBAA.GLOBAL_ATTRIBUTE1
                FROM
                   PO.PO_VENDORS PV,
                   PO.PO_VENDOR_SITES_ALL PVS,
                   AP.AP_TERMS_TL APT,
                   AP.AP_BANK_BRANCHES APB,
                   AP.AP_BANK_ACCOUNTS_ALL APBAA,
                   AP.AP_BANK_ACCOUNT_USES_ALL APBAUA
                WHERE
                   PV.VENDOR_ID=PVS.VENDOR_ID
                AND
                   PVS.TERMS_ID = APT.TERM_ID
                AND
                   PVS.VENDOR_ID = APBAUA.VENDOR_ID (+)
                AND
                   PVS.VENDOR_SITE_ID = APBAUA.VENDOR_SITE_ID (+)
                AND
                  APBAUA.EXTERNAL_BANK_ACCOUNT_ID = APBAA.BANK_ACCOUNT_ID (+)
                AND
                  APBAA.BANK_BRANCH_ID = APB.BANK_BRANCH_ID (+)
                AND
                   APT.LANGUAGE = 'S'
                AND
                   ((PV.last_update_date >= p_update_date)
                   OR
                   (PVS.last_update_date >= p_update_date)
                   OR
                   (APT.last_update_date >= p_update_date)
                   OR
                   (APB.last_update_date >= p_update_date)
                   OR
                   (APBAA.last_update_date >= p_update_date));