You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Custom SQL queries against Cloud ERP via OAICS

    edited Jul 18, 2018 1:04PM in Integration 2 comments

    Summary

    Custom SQL queries against Cloud ERP via OAICS

    Content

    Hi All,

    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;

    SELECT POH.SEGMENT1
    ,      POS.VENDOR_NAME
    ,      POSS.ADDRESS_LINE1 
    FROM   PO_HEADERS_ALL POH

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!