Custom SQL queries against Cloud ERP via OAICS
SummaryCustom SQL queries against Cloud ERP via OAICS
I am building an integration in OAICS, based on (I expect a common scenario) where we are creating Requisitions in Cloud ERP, from a flat file delivered to an FTP Server. I'm using the bulk import process, FBDI.
I need to enrich the Requisition data I receive, before creating the requisition. Specifically, we are given a Blanket Purchase Order number, and I need to obtain from this certain supplier details. I have a SQL query as follows;
FROM PO_HEADERS_ALL POH