Integration

Get Involved. Join the Conversation.

Posts

  • Karthick R
    How to load overtime information into Oracle HCM?35.0
    Topic posted October 20, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, Database, Integration, Mapping, Orchestration, PaaS, REST, SOAP, Web Services, xml 
    Title:
    How to load overtime information into Oracle HCM?
    Summary:
    How to load overtime information into Oracle HCM?
    Content:

    Hi Everyone,

    I have a requirement to load overtime information of an employee from a 3rd party system to Oracle Fusion HCM.

    Can you point out any Oracle documentation or blog material that discusses about SOAP service or HDL or FBDI to load Overtime information into Fusion HCM?

    Regards,

    Karthick.R

  • Jaeyshree Kumaran
    How to run a integration by clicking a single url/link5
    Topic posted October 18, 2019 by Jaeyshree KumaranRed Ribbon: 250+ Points, tagged Adapters, API, Connection, Integration, Mapping, Orchestration, PaaS, REST, Web Services, xml 
    Title:
    How to run a integration by clicking a single url/link
    Content:

    Requirement: I want to send the url of integration in a mail notification. On click of that url, the integration should be triggered in OIC.

    I initially used the link (as in image) but it can be done by using rest client or postman tools only. I need a way that is independent of the tools.

    I referred the below documentation, and found it cannot be done without support of rest client or postman tools as it is a POST request

    https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/op-ic-api-integration-v1-integrations-id-schedule-start-post.html

    Also, I found starting an integration is a POST request. hitting a url from browser is GET request.

    Kindly suggest a way to trigger the integration by clicking a single url.

     

     

     

    Version:
    19.3.3.0.0 (190924.1600.31522)
    Image:
  • Pooja I
    Multiple line within a single mapping elementAnswered135.0
    Topic posted October 11, 2019 by Pooja IBlue Ribbon: 750+ Points, tagged Integration, Mapping 
    Title:
    Multiple line within a single mapping element
    Content:

    I have used the below wsdl to generate scheduled report from fusion;

    WSDL: http://<host>:<port>/xmlpserver/services/v2/ScheduleService?wsdl

    The request mapper for the above service provides me with E-mail options.

    The issue i am facing now is, in the e-mail body element i need to include the attached sample mail.

    So i formatted using the xsl-text element. but the result is not as formatted as what is expected. Is there any way to format text in an mapping element?

    I have attached the files

    ResultReceived.png - is the output I received

    emailBody.png - the mapping in oic

    sampleMail.png - the expected output.

     

    Do share your insights.

    TIA.

     

    Image:
    Document:
    Document:
  • Vitor Souza
    Array variable OIC (ICS)6
    Topic posted October 10, 2019 by Vitor SouzaGreen Ribbon: 100+ Points, tagged Cloud, Connection, Integration, Mapping, Orchestration, Process 
    Title:
    Array variable OIC (ICS)
    Summary:
    Array variable OIC (ICS)
    Content:

    Hello,

    We have a "foreach integration" and I would like to create an array variable with the result of that integration.
    After that, I'd like to go through this array and call another connection (another mapping).

    How is this done? I looked in documentation and we have no examples like that. "Assign variables" are text only.

    Thanks.

     

  • Karthick R
    Are business event available to capture customer account...
    Topic posted October 10, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, ERP Cloud, Events, Mapping, Orchestration, PaaS, REST, Sales Cloud, SOAP, Web Services, xml 
    Title:
    Are business event available to capture customer account creation/update?
    Summary:
    Are business event available to capture customer account creation/update?
    Content:

    Hi Everyone,

    I'm looking for a business event that triggers when a (Trading Community) customer account is either created/updated in Oracle Fusion.

    I referred the below supported business events documentation available for Oracle Sales cloud but it doesn't point out customer account events.

    https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icssc/oracle-sales-cloud-capabilities.html#GUID-BF281C4F-D708-4AAA-B983-33DAA8E6AB7E

    Please advise.

    Regards,

    Karthick.R

    Version:
    Oracle Fusion application 19b (11.13.19.04.0)
  • Karthick R
    OIC - How to invoke BIP ws and read output dataAnswered7
    Topic posted October 9, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, Events, Integration, Mapping, Orchestration, PaaS, REST, SOAP, Web Services, xml 
    Title:
    OIC - How to invoke BIP ws and read output data
    Summary:
    How to invoke BIP web service and parse/read the output in OIC?
    Content:

    Hi everyone,

    How to invoke BIP web service and parse/read the output and share the parsed data (column1, column2 ... column n) to another 3rd party application in OIC?

    Can anyone point out any blog/document reference material?

    Regards,

    Karthick.R

  • logu Prasanth
    I made a get call-in REST adapter. I am providing XML...6
    Topic posted September 30, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Connection, E-Business Suite, ERP Cloud, Integration, Mapping, Orchestration, PaaS, REST, SOAP, Web Services, xml 
    Title:
    I made a get call-in REST adapter. I am providing XML SCHEMA (XSD) as response payload format. but Live payload is JSON.
    Summary:
    I made a get call-in REST adapter. I am providing XML SCHEMA (XSD) as response payload format. but Live payload is JSON.
    Content:

    HI,

    I made a get call-in REST adapter. I am providing  XML SCHEMA (XSD) as response payload format. but Live payload is JSON.

    When I am logging the data I getting below Error

    Xpath expression associated with <from> in copy assign activity is invalid.There is an user error that results in missing element value(s) in the xpath query.Please review the payload and modeling to ensure that all elements defined in the <from> xpath query have valid non-null values .
     
     

    In OIC, Is it the right approach. can we able to traverse using XSD as a format but the live payload is JSON

    Thanks in advance. 

     

     

  • Mohana Gopal Selvam
    Subtraction functionAnswered125.0
    Topic posted September 29, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Mapping 
    Title:
    Subtraction function
    Content:

    Hi,

    Requirement: I want to subtract two value from various response and show in the final response.

    Problem: One value coming as string, so I tried to convert as Decimal point. Since I could not use Number (Conversion) function in Subtract, I have used assigned operation and convert as Decimal point. But I got the below error. I noticed, assigned function output also String. 

    Response 1

    {
      "avlDeposit" : "978409.25"}

    Response 2

    {
      "holdingAmt" : 409.25
    }

    How to achieve this?

    Got the below error
    {
      "type" : "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1",
      "title" : "Internal Server Error",
      "detail" : "Internal server error. Please contact oracle support for details.",
      "o:errorCode" : "500",
      "o:errorDetails" : [ {
        "type" : "UnMappedFault:execute",
        "instance" : "<![CDATA[Please inspect the logs for more details. Initiating Request: <request_payload/>\n]]>",
        "title" : "faultName: {{http://schemas.oracle.com/bpel/extension}subLanguageExecutionFault}\nmessageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}\nparts: {{\nsummary=<summary>XPath expression failed to execute.\nAn error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc('resources/processor_116/resourcegroup_119/req_388e98f6529b4d6297c27267df9e6b41.xsl', $messagecontext_15.parameters, 'ORDS_HoldingAmount', $messagecontext_84.parameters, 'holdingAmount_assignment_1', $messagecontext_141, 'FreeCom_PB_Check', $messagecontext_129.parameters, 'avl_deposit_assignment_1', $messagecontext_155)\nThe XPath expression failed to execute; the reason was: javax.xml.transform.TransformerException: oramds:/deployed-composites/oracleinternalics/PORTAL_BALANCE_DELETE_rev01.00.0000/resources/processor_116/resourcegroup_119/req_388e98f6529b4d6297c27267df9e6b41.xsl&lt;Line 55, Column 186>: XML-23002: (Error) internal xpath error\nCheck the detailed root cause described in the exception message text and verify that the XPath query is correct.\n</summary>\n,code=<code>XPathExecutionError</code>}\ncause: {javax.xml.transform.TransformerException: oramds:/deployed-composites/oracleinternalics/PORTAL_BALANCE_DELETE_rev01.00.0000/resources/processor_116/resourcegroup_119/req_388e98f6529b4d6297c27267df9e6b41.xsl<Line 55, Column 186>: XML-23002: (Error) internal xpath error}\n",
        "o:errorPath" : "NA",
        "o:errorCode" : "NA"
      } ]
    }
    

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Handling Null value in the mappingAnswered115.0
    Topic posted September 27, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Mapping 
    Title:
    Handling Null value in the mapping
    Content:

    Hi,

    In my integration, I got the Null value as response in one of my source as shown below. I used this field in my mapper to map to target.

    {
        "x_total_deposit": 1000,
        "x_avail_deposit": null,
        "x_return_status": "S"
    }
    

    I got the Translation error when I invoke the OIC API, since null value is mapped to end response field. 

    {
      "type" : "10.5.3",
      "title" : "exception occurred while translating the response into the accepted media type.",
      "detail" : "oracle.cloud.connector.api.CloudInvocationException: ORABPEL-15236\n\n",
      "o:errorCode" : "TRANSLATION-ERROR-01",
      "o:errorDetails" : [ {
        "type" : "NA",
        "instance" : "NA",
        "title" : "NA",
        "o:errorPath" : "NA",
        "o:errorCode" : "NA"
      } ]
    }
    

    How to handle the null value in the mapping in OIC?

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    LookupAnswered105.0
    Topic posted September 24, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Mapping 
    Title:
    Lookup
    Content:

    Hi,

    We have requirement like, based on the input parameter value, we have to pass different value to 5 columns. 

    If the BU = Sales then Owner = Sales Admin, Process = OSC ,...

    If the BU = Service then Owner = Service Admin, Process = OSvC, ..

    Can we implement this using Lookup?

    We need those values are configurable in the UI.

    Thanks,

    Mohan