Integration

Get Involved. Join the Conversation.

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

     

     

     

     

     

  • Christopher Maggiulli
    RightNow Adapter and Integration Cloud attachment apiAnswered215.0
    Topic posted June 14, 2018 by Christopher MaggiulliSilver Crown: 22,500+ Points, tagged Adapters, Integration, Mapping, Process, REST, RightNow, SOAP, Tip 
    Title:
    RightNow Adapter and Integration Cloud attachment api
    Summary:
    I am looking for the general workflow of using the RightNow adapter to pull files and upload them to integration cloud
    Content:

    We have a functionality called "incident pull" in our application whereby a user in Integration Cloud enters the reference ID of a Oracle RightNow Incident then attaches all the files from that incident into the CEP process. I currently have this working but in a round about way by utilitizing a custom web service instead of the right now adapter. Can someone walk me through the integra here? I have a connection to right using the standard wsdl. It tests fine. Then I build an integration. It starts with a post request that sends in the reference ID of the incident in service cloud and the process ID to attach the incident attachments to in OIC. After the starting point it then goes right to the RightNow adapter (with a mapping in between). I map the Id I get from the start rest service to the RightNow wsdl id. Then I get a Hughes result of values including attachments in base64. Then I try to map from the RightNow adapter to a restaurant service with this endpoint https://docs.oracle.com/en/cloud/paas/process-cloud/cprrb/op-processes-processid-attachments-post.html However it doesn't succeed. Either the wsdl is not returning values or I'm missing a step between the returning of the files from the wsdl and uploading them via that endpoint to OIC.

  • 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 
    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,

     

  • logu Prasanth
    How to send HTTPS 200 response Immediately to When Client...Answered18
    Topic posted August 19, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, API, Connection, Integration, Mapping, Orchestration, xml 
    Title:
    How to send HTTPS 200 response Immediately to When Client make POST call? in App driven Orchestration
    Summary:
    We are using APP DRIVEN ORCHESTRATION to Create a Purchase order
    Content:

    My Workflow

    Step 1 
    - Client post the metadata to OIC Endpoint. 
    Step 2 
    - In the same flow, OIC makes Get call using Metadata to get PO Data. 
    Step 3 
    - Now, OIC process the PO data to create the PO in Oracle EBS and send Success/Failure Acknowledgement to Client. 
    Step 4 
    - OIC will send HTTPS 200 response after all the operation completed in OIC for Clients POST call. 

    Is there any option available to send HTTPS 200 response Immediately to When Client make POST call? 

    Here I have attached the Integration flow screenshot.

    Scope having all the mentioned steps.

     

    Image:
  • 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 
    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 
    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.

  • Pooja I
    Conditional Mapping in OICAnswered16
    Topic posted July 26, 2019 by Pooja IBronze Medal: 1,250+ Points, tagged Cloud, Integration, Mapping, Orchestration, xml 
    Title:
    Conditional Mapping in OIC
    Summary:
    Issue in conditional Map
    Content:
    Hi Team,
          Below is the input XML structure which i am trying to have conditional mapping.
    <Phone_Hierarchy>
       <Phone_Details>
          <Phone_Info>
             <Phone_Primary_ID>test</Phone_Primary_ID>
             <Phone_ID>test</Phone_ID>
             <Phone_Number>978-5567</Phone_Number>
           </Phone_Info>
        </Phone_Details>
        <Phone_Details>
           <Phone_Info>
              <Phone_Primary_ID>test</Phone_Primary_ID>
              <Phone_ID>test1</Phone_ID>
              <Phone_Number>9728524522</Phone_Number>
           </Phone_Info>
         </Phone_Details>
    </Phone_Hierarchy>
     

    The CONDITION CHECK IS: 

      if Phone_Primary_ID == Phone_ID then map Phone_Number else empty element.
      
      below is the looping which i tried
      
      for each of Phone_Details
           if ( Phone_Primary_ID == Phone_ID )
          then 
                map Phone_Number
          else
                ""
       
       This was printing concatinated result of all the Phone_Number like 978-55679728524522
       
     
      
       Alternatively, what i thought of is,
       
       for each of Phone_Details   //loop through all the phone_details
        if(boolean = true)         //exit loop when the condition becomes false
            if ( Phone_Primary_ID == Phone_ID )
             then 
                map Phone_Number
                set boolean =false;    //here i am not able to reassign boolean and the xpath is throwing errors.
      else
       ""
       
       I know that this is specific case, since this is totally new to me, I need some insight on this
    Image:
  • Karen Edge
    ICS mapping to bring over XML tags15
    Topic posted September 26, 2018 by Karen EdgeRed Ribbon: 250+ Points, tagged Integration, Mapping, REST, SOAP, xml 
    Title:
    ICS mapping to bring over XML tags
    Summary:
    Is there an ICS mapping function to bring over fields as is, with the XML tags?
    Content:

    I am working on an integration between Oracle Utilities (using its ICS Adapter) (SOAP-based) and Oracle Field Service Cloud (using its Adapter) (REST based).  There are fields in my outbound message from Oracle Utilities that I want to map to OFSC intact, with the XML tags included.  (The XML tags are subsequently used in OFSC to format the display of the data.)

    For example, if my field in Oracle Utilities has "<fielda>12345</fielda>" I would like that exact string to be mapped to a Property in OFSC.

    Currently the XML tags are being stripped out, moving just "12345" to OFSC.

    I would appreciate anyone's help or pointers to other posts.

    Version:
    18.2.3.0.1
  • Songqing Gu
    How to write FTP in Stage File Read (in Segment)Answered14
    Topic posted May 20, 2019 by Songqing GuGreen Ribbon: 100+ Points, tagged Adapters, Cloud, Integration, Mapping, PaaS 
    Title:
    How to write FTP in Stage File Read (in Segment)
    Summary:
    Issue with stage read in segment and with FTP write in Stage File Read (in segment)
    Content:

    I am getting stuck with writing CSV records to FTP in a Stage File Read (in Segment).

    My case is:

    1. query DB with more than 1000 records in response;

    2. Loop over each record, apply mapping logic to current record, and then write into staging file;

    3. After the loop use Stage File Read - in segment, then write into remote file system by FTP adapter.

     

    FTP adapter complains with error as below:

    com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault} messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{ CODE={http://schemas.oracle.com/bpel/extension}remoteFault ,SUMMARY= ICS runtime execution error ,DETAIL= Translation Error. Translation Error. Error while translating message to native format. Please make sure that the payload for the outbound interaction conforms to the schema and payload size does not exceed threshold. Error occured as {1} :Application Error WriteFile } cause: {null} 

     

    Regards

    Songqing