Posts

Posts

  • Stephen Bryant
    Extract Data from SaaS to VBCS ApplicationAnswered41
    Topic posted June 10, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Adapters, Connection, ERP Cloud, Integration, Mapping, Orchestration, PaaS, REST, SOAP, Web Services in Integration > Integration public
    Title:
    Extract Data from SaaS to VBCS Application
    Summary:
    Extract Data using an OTBI Report
    Content:

    Hello,

    I have a requirement to retrieve data from our Oracle ERP Cloud applications. I need to extract the data via an OTBI report and then display those results in a VBCS application.  I realize that the report is retrieved from SaaS using a SOAP service (that I can connect to in the SOAP UI) but VBCS only uses REST so a conversion is necessary.

    Has anyone done this?  In particular, how does the mapping from SOAP to REST work?

    Thanks,

    Steve

    Version:
    19.1.3
  • logu Prasanth
    How to create a post REST service in OIC25
    Topic posted March 27, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Case Management, Cloud, Connection, Database, E-Business Suite, Events, Integration, Mapping, Orchestration, PaaS, Process, REST, SOAP, Web Services, xml in Integration > Integration public
    Title:
    How to create a post REST service in OIC
    Summary:
    We have a requirement to create a REST service in OIC. And this service will be exposed to the client to POST their JSON data.
    Content:

    We have a requirement to create a REST service in OIC. And this service will be exposed to the client to POST their JSON data.

    Can you please provide any artifact /whitepaper/ procedure for creating simple REST service in OIC.

     

     

     

     

     

  • Jon Cooper
    Web Services for Sales Cloud255.0
    Topic posted February 18, 2014 by Jon CooperRed Ribbon: 250+ Points, tagged Web Services in Sales > Sales public
    Title:
    Web Services for Sales Cloud
    Summary:
    Has anyone managed to achieve updating / creating of records via web service?
    Content:

    Hello,

    We're exploring a web service alternative to file import across customers, sales accounts, contacts, opportunities and revenue lines and I would like to get feedback from people who are currently using web services, for example, have they worked across releases? Have you had any issues with getting data out (fetchSize / fetchStart)? Are certain characters supported in file import but not web services and so on

    Any information / advice you have would be greatly appreciated

    Thank you,
    Jon

  • Mohana Gopal Selvam
    Internal Server ErrorAnswered235.0
    Topic posted June 16, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged REST, Web Services in Integration > Integration public
    Title:
    Internal Server Error
    Content:

    I have tried to convert the WSDL API into Rest API since OIC VBCS does not support WSDL API. We have followed the steps as mentioned in the forum https://cloudcustomerconnect.oracle.com/posts/18fc9cc15f. Created 2 connection successfully. Created one integration successfully.  But when I hit the Rest API URL, we got the Internal Server Error.

    What might be the cause?

    Thanks,

    Mohan

  • logu Prasanth
    How to calculate signature in OIC using HMAC sha 256Answered195.0
    Topic posted February 12, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, API, E-Business Suite, Integration, Mapping, Orchestration, PaaS, REST, SOAP, Web Services, xml in Integration > Integration public
    Title:
    How to calculate signature in OIC using HMAC sha 256
    Summary:
    Calculate signature in OIC using HMAC sha 256
    Content:

    Hi All,

    In OIC, How to calculate signature using HMAC sha256

    Is there any script available in OIC calculate HMAC sha256 ??

     

    Regards,

    Logu,

     

  • Stephen Bryant
    OTBI Report to VBCS Rest Endpoint **SOLVED**Answered18
    Topic posted June 28, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Adapters, API, Cloud, ERP Cloud, Integration, Mapping, Orchestration, REST, SOAP, Web Services, xml in Integration > Integration public
    Title:
    OTBI Report to VBCS Rest Endpoint **SOLVED**
    Summary:
    Extracted OTBI Report - map to POST to store in VBCS Business Object
    Content:

    Hello,

    I've successfully extracted the contents of an OTBI Report from our ERP Cloud system and presented that data in a VBCS Application Page.  Thanks to those here who helped me (Mani, Hemanth, and others).  

    At this point, I want to do the same extract from SaaS (no problem) and post that data directly to a VBCS Business Object.  The problem I am having is the OTBI Report is in XML and the REST API for the Business Object wants JSON.  I tried simply mapping the XML output to the Rest API in the mapper but that does not work.

    The data is about 500 lines.  How would I go about this?  I thought the mapping automatically took care of this.

    I am able to successfully Post to the Business Object in POSTMAN in batch mode but cannot replicate this in OIC.

    Any help is greatly appreciated.

    Thanks,

    Steve

    Version:
    19.1.3
    Image:
  • M Sridhar
    OIC: for-each inside for-each issue18
    Topic posted December 14, 2018 by M SridharSilver Medal: 2,000+ Points, tagged Cloud, ERP Cloud, Integration, Mapping, Orchestration, PaaS, REST, Web Services, xml in Integration > Integration public
    Title:
    OIC: for-each inside for-each issue
    Summary:
    for-each inside for-each issue
    Content:

    Hi All,

     

    I tried to enable a integration that has for-each inside for-each activity. it is throwing below error.

     

    If I take out one inside for-each , integration getting activated...Please comment if you have any pointers.

     

    Deployment Failed: Error occurred during deployment of component: FRTCLS_TEST to service engine: implementation.bpel, for composite: FRTCLS_TEST: ORABPEL-05215 Error while loading process. The process domain is encountering the following errors while loading the process "FRTCLS_TEST" (composite "oracleinternalics/FRTCLS_TEST!01.00.0000*d8d042d4-3804-4cc2-8ee6-5464539efd52"): Failed to compile bpel generated classes. failure to compile the generated BPEL classes for BPEL process "FRTCLS_TEST" of composite "oracleinternalics/FRTCLS_TEST!01.00.0000*d8d042d4-3804-4cc2-8ee6-5464539efd52" The class path setting is incorrect. Ensure that the class path is set correctly. If this happens on the server side, verify that the custom classes or jars which this BPEL process is depending on are deployed correctly. Also verify that the run time is using the same release/version. . This error contained an exception thrown by the underlying process loader module. Check the exception trace in the log (with logging level set to debug mode). If there is a patch installed on the server, verify that the bpelcClasspath domain property includes the patch classes.

  • M Sridhar
    Oracle OIC Integration with OTBI IssueAnswered18
    Topic posted November 13, 2018 by M SridharSilver Medal: 2,000+ Points, tagged Cloud, Integration, Orchestration, PaaS, SOAP, Web Services in Integration > Integration public
    Title:
    Oracle OIC Integration with OTBI Issue
    Summary:
    Oracle OIC Integration with OTBI Issue
    Content:

    Hello,

    I am consuming data of a simple BI report (csv output) in OIC, issue is all the data is coming in one line (header+data) -> after decodebase64

    like inventory_item_id,organization_id12345,101

    instead of  inventory_item_id,organization_id

                         12345,101

    I tried with XML output, when it is coming in payload after decodebase64

    <?xml version="1.0" encoding="UTF-8"?> is coming in between tags which is corrupting the payload

     

    Please let me know how to handle either of the case to get it in correct format

  • Hemen Shah
    Not able to invoke Esswebservice from OIC175.0
    Topic posted December 10, 2018 by Hemen ShahBlue Ribbon: 750+ Points, tagged Adapters, ERP Cloud, Integration, PaaS, SOAP, Web Services in Integration > Integration public
    Title:
    Not able to invoke Esswebservice from OIC
    Summary:
    Not able to invoke Esswebservice from OIC
    Content:

    I am trying to invoke Esswebservice from OIC to submit ESS job. i created connection(invoke and Trigger) using following WSDL and able to create without any issue.

    https://xxxx-xxxx.fa.us6.oraclecloud.com/ess/esswebservice?WSDL

    now while using this connection to my integration I am getting following error.

    SOAPADAPTR-20027 : Cause - Unable to parse definition as configured wsdl is not supported, Action - Verify WSDL definition and please make sure that your schema documents are correct

    With the same above WSDL I am able to submit job successfully through SOAP UI.

    Appreciated if anyone help to resolve this issue.

    Version:
    18.4.3.0.0
  • Boyuan Zhu
    Sample Payloads for Purchase Order SOAP Web Service174.6
    Topic posted October 5, 2017 by Boyuan ZhuBronze Trophy: 5,000+ Points, tagged FAQ, Orders, Web Services in Procurement > Purchasing public
    Title:
    Sample Payloads for Purchase Order SOAP Web Service
    Content:

    The purchase order SOAP web service allows buyers to take actions, such as create, change, or cancel, on purchase orders. Sample payloads for different operations can be found in this topic. 

    More details about the purchase order SOAP web service can be found here: https://docs.oracle.com/cloud/latest/procurementcs_gs/OESWP/Purchase_Order_Service_Version_2_PurchaseOrderService_svc_3.htm