Posts

Posts

  • Jaeyshree Kumaran
    skip record in for-each present in mapper2
    Topic posted December 4, 2019 by Jaeyshree KumaranRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, Connection, Integration, Mapping, Orchestration, SOAP, Web Services, xml in Integration > Integration public
    Title:
    skip record in for-each present in mapper
    Content:

    I have write adapter in which I have for-each loop for two levels(1. for-each of assignments, 1.a. for each of Global_Card_Components_State). The Global_Card_Components_State tag will be optional. Some assignments may contain it. I have included a choose condition (as in image). This is successful when Global_Card_Components_State tag is present but fails when input doesnt have that particular tag.

    Is there any option to skip and process next record. <otherwise> doesnt help as i dont have sny option to map as its child.

    I am getting below error when for-each encounters assignments tag without Global_Card_Components_State tag

     

    com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault} messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{ CODE=<code>{http://schemas.oracle.com/bpel/extension}remoteFault</code> ,SUMMARY=<summary>ICS runtime execution error</summary> ,DETAIL=<DETAIL><detail><ICSfaultVar/><reason>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</reason><operation>WriteFile</operation></detail></DETAIL>} cause: {null} Stage Read Failed

     

    Image:
  • Frank Brink
    a JSON to JSON integration using a local REST service result...10
    Topic posted December 4, 2019 by Frank BrinkRed Ribbon: 250+ Points, tagged Agent, Connection, Integration, REST in Integration > Integration public
    Title:
    a JSON to JSON integration using a local REST service result in Failed to translate XML to JSON
    Summary:
    a basic routing integration (JSON to JSON) leveraging a local REST service (through an agent) result in Failed to translate XML to JSON
    Content:

    Hereby my scenario that result in a faulted json response within SOAPUI - see below the error in SOAPUI on the JSON tab

    1. Create an invoke connection to a REST module that resides in the database using a generic REST API Base URL option (contain all my REST modules: http://10.0.20.6:8091/ords/hr_schema tthrough an agent since the REST services resided in my database

    2. Create a JSON to JSON integration leveraging this connection with a request and response mapping

    3. Executing this integration result in the following error on the JSON tab:

    {
       "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
       Translation Failure.\nFailed to translate XML to JSON. 
       Cannot write end element: empno\n
       The data does not conform to the NXSD schema. Please correct the problem.\n",
       "o:errorCode": "TRANSLATION-ERROR-01",
       "o:errorDetails": [   {
          "type": "NA",
          "instance": "NA",
          "title": "NA",
          "o:errorPath": "NA",
          "o:errorCode": "NA"
       }]
    }

    Odly enough there are NO failing instance(s)

    In addition if you lookup the payload within the activity stream option you can actually see the expected/correct response payload?

    So no failed instances with the expected payload but this payload is not shown in SOAPUI on the JSON tab - in stead the error as displayed above

    What could be the root cause of this inconstent behavior? 

    See also below for a substract of the diagnostic file containing the "ORABPEL-15236 Translation Failure. Failed to translate XML to JSON. Cannot write end element: empno" error
    ..

    [2019-12-04T07:28:04.169+00:00] [oiclhr3I_server_1] [ERROR] [] [oracle.tip.pc.services.translation.xlators.json.JsonTranslator] 

    [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] 
    [userId: frank.brink@darwin-it.nl] [ecid: 780150c5-74f2-4fe4-b56a-0ab2e1a0aa73-00042ae1,0] 
    [APP: Cloud Adapter Inbound Http App] [partition-name: DOMAIN] [tenant-name: GLOBAL] 
    [oracle.soa.tracking.FlowId: 7600006] [FlowId: 0000MvFnj8ZCSs95zf_AiW1TtPJT00002l] JsonTranslator.translateToNative writer Exception caught[[
    org.xml.sax.SAXException: Cannot write end element: empno
    javax.xml.stream.XMLStreamException: Cannot write end element: empno
    at oracle.tip.pc.services.translation.xlators.json.NillableSupportedJsonSaxContentHandler.endElement(NillableSupportedJsonSaxContentHandler.java:347)
     
    Caused by: org.codehaus.jackson.JsonGenerationException: Error occurred while trying to write the value: 
    at oracle.tip.pc.services.translation.xlators.json.jackson.TypeDeducingJsonGenerator.writeString(TypeDeducingJsonGenerator.java:92)
    Caused by: java.lang.NumberFormatException
    at java.math.BigDecimal.<init>(BigDecimal.java:599)
     
    [2019-12-04T07:28:04.236+00:00] [oiclhr3I_server_1] [ERROR] 
    [] [oracle.tip.pc.services.translation.xlators.json.JsonTranslator] 
    [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] 
    [userId: frank.brink@darwin-it.nl] [ecid: 780150c5-74f2-4fe4-b56a-0ab2e1a0aa73-00042ae1,0] 
    [APP: Cloud Adapter Inbound Http App] [partition-name: DOMAIN] 
    [tenant-name: GLOBAL] [oracle.soa.tracking.FlowId: 7600006] 
    [FlowId: 0000MvFnj8ZCSs95zf_AiW1TtPJT00002l] JsonTranslator.translateToNative TranslationException caught[[
    ORABPEL-15236 Translation Failure. Failed to translate XML to JSON. Cannot write end element: empno
    The data does not conform to the NXSD schema. Please correct the problem.
     
    at oracle.tip.pc.services.translation.xlators.json.JsonTranslator.translateToNative(JsonTranslator.java:331)
     
    Caused by: org.xml.sax.SAXException: Cannot write end element: empno
    javax.xml.stream.XMLStreamException: Cannot write end element: empno
    at oracle.tip.pc.services.translation.xlators.json.NillableSupportedJsonSaxContentHandler.endElement(NillableSupportedJsonSaxContentHandler.java:347)
    at

     

    Version:
    Version: 19.4.2.0.0 (191110.1400.32380)
  • Nazeer Anantha
    Wants to download or read file from File Storage in OIC2
    Topic posted December 3, 2019 by Nazeer AnanthaBlue Ribbon: 750+ Points, tagged Adapters, Agent, API, Cloud, Connection, ERP Cloud, Integration, PaaS, REST, Web Services in Integration > Integration public
    Title:
    Wants to download or read file from File Storage in OIC
    Summary:
    Wants to download or read file from File Storage in OIC
    Content:

    Hi All,

    I am trying to download or read a file from File Storage in OIC.

    is there any way to achieve this without using File Adapter?

    Thanks,

    Nazeer.

  • Frank Brink
    A based basic routing integration from REST to SOAP result...10
    Topic posted December 2, 2019 by Frank BrinkRed Ribbon: 250+ Points, tagged Connection, Integration, REST, SOAP in Integration > Integration public
    Title:
    A based basic routing integration from REST to SOAP result on runtime in javax.xml.soap.SOAPException: Not a valid SOAP Content-Type: text/html;
    Summary:
    How to define/setup a REST/SOAP based basic routing integration that runs successfully
    Content:
    Hereby my (faied) scenario
    I am able to call an external SOAP based WSDL with SOAPUI with a pre-provided un/pw and receive the expected answers
    I am able to define, test and validate a connection based on this external wsdl using TLSv1.1 and enabling security (basis authN) with the pre-provided un/pw
    I am able to define an integration using a REST based trigger connection and SOAP based invoke connection
    On runtime the execution of this integration result in javax.xml.soap.SOAPException: Not a valid SOAP Content-Type: text/html; 
    and errorCode": "OSB-380001"
     
    See full error stack below
    {
       "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   
      <Body xmlns=\"http://schemas.xmlsoap.org/soap/envelope/\">\n      
      <execute xmlns=\"http://xmlns.oracle.com/cloud/adapter/REST/IdentificeerLeerBedrijf_REQUEST/types\">\n         
      <HTTPHeaders/>\n         
      <QueryParameters>\n            
      <bedrijfsnaam xmlns=\"http://xml.oracle.com/types/REST/IdentificeerLeerBedrijf_REQUEST\">AH BUMA<\/bedrijfsnaam>\n            
      <huisnummer xmlns=\"http://xml.oracle.com/types/REST/IdentificeerLeerBedrijf_REQUEST\">1<\/huisnummer>\n            
      <postcode xmlns=\"http://xml.oracle.com/types/REST/IdentificeerLeerBedrijf_REQUEST\">3825ME<\/postcode>\n         
      <\/QueryParameters>\n      
      <\/execute>\n   
      <\/Body>\n
      <\/request_payload>\n]]>",
          "title": "javax.xml.ws.WebServiceException: 
        Error while dispatching SOAP message to the endpoint http://webservice-acc.stagemarkt.nl/WhiteLabel2NoCert.svc:javax.xml.soap.SOAPException: 
    javax.xml.soap.SOAPException: Not a valid SOAP Content-Type: text/html; 
    charset=UTF-8\n===== reqeust ========\n
    Content-Type:text/xml; charset=UTF-8\nContent-Length:1329\n
    SOAPAction:\"http://bpvinformatievoorziening.nl/service/v1_0/identificeerLeerbedrijf\"\n
    Authorization:***hidden***\n
    <env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">
    <env:Header/>
    <env:Body>
    <tns:identificeerLeerbedrijf xmlns:wsa=\"http://schemas.xmlsoap.org/ws/2004/08/addressing\" 
    xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\" 
    xmlns:wsdl=\"http://schemas.xmlsoap.org/wsdl/\" 
    xmlns:wsp=\"http://schemas.xmlsoap.org/ws/2004/09/policy\" 
    xmlns:wsu=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\" 
    xmlns:nsmpr0=\"http://xml.oracle.com/types/REST/IdentificeerLeerBedrijf_REQUEST\" 
    xmlns:wsx=\"http://schemas.xmlsoap.org/ws/2004/09/mex\" 
    xmlns:wsaw=\"http://www.w3.org/2006/05/addressing/wsdl\" 
    xmlns:wsa10=\"http://www.w3.org/2005/08/addressing\" 
    xmlns:soap12=\"http://schemas.xmlsoap.org/wsdl/soap12/\" 
    xmlns:tns=\"http://bpvinformatievoorziening.nl/service/v1_0\" 
    xmlns:msc=\"http://schemas.microsoft.com/ws/2005/12/wsdl/contract\" 
    xmlns:wsap=\"http://schemas.xmlsoap.org/ws/2004/08/addressing/policy\" 
    xmlns:nstrgmpr=\"http://xmlns.oracle.com/types/soapIdentificeerLeerBedrijf/OutboundSOAPRequestDocument\" 
    xmlns:soap=\"http::Application Error",
          "o:errorPath": "<![CDATA[<location>\n   
      <node>RouteNode1<\/node>\n   
      <path>response-pipeline<\/path>\n
      <\/location>\n]]>",
          "o:errorCode": "OSB-380001"
       }]
    }
    Version:
    Version: 19.4.2.0.0 (191110.1400.32380)
  • Frank Brink
    The usage of a local REST swagger based connection (icw...
    Topic posted December 2, 2019 by Frank BrinkRed Ribbon: 250+ Points, tagged Agent, Connection, Integration, REST in Integration > Integration public
    Title:
    The usage of a local REST swagger based connection (icw an agent) in an integration result in an "unexpected error"
    Summary:
    unexpected error in integration while calling a connection based on local REST swagger based connection icw an agent
    Content:

    Hereby my (faied) scenario
    My REST based modules leveraging ORDS are running and executing successfully
    I am able to call the various REST methods directly and receive the expected answers
    I am able to generate and lookup the swagger definition in my browser
    I am able to define and test this same local REST swagger based (Invoke) connection icw an agent - with no authorization
    Then using that same connection within an integration result in
    "The application has encountered an unexpected error. 
    Please check the applications connection details, credentials and retry your request"
    as a result I cannot leverage/use all methods with this local REST based solutions in any integration
    Any ideas to circumvent this design error within an integration?

     

    Version:
    Version: 19.4.2.0.0 (191110.1400.32380)
  • Samuel Lima
    How can an admin user retrieve the tasks from other users?35.0
    Topic posted November 29, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged API, Connection, Integration in Integration > Integration public
    Title:
    How can an admin user retrieve the tasks from other users?
    Summary:
    How can an admin user retrieve the tasks from other users?
    Content:

    Hi,

    Is it possible for an admin user to retrieve tasks from other users using the /bpm/api/4.0/tasks API?

    The doc says it returns the tasks from the current user.

    https://docs.oracle.com/en/cloud/paas/process-cloud/cprrb/op-tasks-get.htm

    If not, is there another way?

    I need to build a custom task list for my users, but to access the task list API I need a connection which, by itself, requires a specified user that is not the logged user.

    Can you help with that?

    Thanks,

    Samuel Lima

     

  • Samuel Lima
    How to set up current user credentials in a connection
    Topic posted November 29, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged API, Connection, Integration in Integration > Integration public
    Title:
    How to set up current user credentials in a connection
    Summary:
    How to set up current user credentials in a connection
    Content:

    Hi experts,

    How can I make a connection use the currently logged user credentials instead of a default credential?

    I need to call /bpm/api/4.0/tasks which returns the tasks of the current user as the doc says:

    https://docs.oracle.com/en/cloud/paas/process-cloud/cprrb/op-tasks-get.html

    Is there another way to retrieve the tasks of a specified user using a default credential in the connection security?

    Thanks,

    Samuel Lima

  • Moon Ray Lo
    ERP Adapter Callback for Non-File-Based Data Import...3
    Topic posted November 27, 2019 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, API, Cloud, Connection, ERP Cloud, Events, Integration, Orchestration, PaaS, SOAP, Web Services in Integration > Integration public
    Title:
    ERP Adapter Callback for Non-File-Based Data Import (FBDI) ERP ESS Job
    Summary:
    Callback for Non-File-Based Data Import (FBDI) ERP ESS Job in Oracle Integration Cloud (OIC)
    Content:

    Hi,

    Has anyone implemented ESS Callback for Non-File-Based Data Import (FBDI) ERP ESS Job thru OIC ERP Adapter?

    https://docs.oracle.com/en/cloud/paas/integration-cloud/erp-adapter/invoke-non-file-based-data-import-fbdi-job.html

    Example is 'Import Accounting Transaction' Job, an ESS Job which is not included in ERP's List of Supported FBDI (https://docs.oracle.com/en/cloud/saas/financials/19c/oefbf/toc.htm). Here's what I did so far in ERP Adapter:

     

    1) Used 'ErpIntegrationService' -> submitJobWithOutput operation, indicating the callback URL of the integration in #2 below.

    2) Created another integration (App-Driven, ERP Adapter as Callback endpoint) to receive the callback from #1 above - but the issue comes with the payload mismatched (ERP is sending the 'old' OnJobCompletion payload, not aligning to the ERP Adapter's OnJobCompletion payload, refer to below examples).

    Sample ERP Response Payload of submitJobWithOutput:

    <onJobCompletion>
    <requestId>33201</requestId>
    <state>SUCCEEDED</state>
    <resultMessage>Request was successful</resultMessage>
    </onJobCompletion>

    Sample OIC (ERP Adapter) Integration Callback Endpoint - Expected Input Payload:

    <onJobCompletionRequest>
    <jobs>
    <jobName>Load Interface File for Import</jobName>
    <jobPath>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</jobPath>
    <documentName>ABC_JE_101820165.zip</documentName>
    <requestId>104403</requestId>
    <status>SUCCEEDED</status>
    <child>
    <jobName>Transfer File</jobName>
    <jobPath>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</jobPath>
    <requestId>104404</requestId>
    <status>SUCCEEDED</status>
    </child>
    <child>
    <jobName>Load File to Interface</jobName>
    <jobPath>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</jobPath>
    <requestId>104405</requestId>
    <status>SUCCEEDED</status>
    </child>
    </jobs>
    <jobs>
    <jobName>Import Journals</jobName>
    <jobPath>/oracle/apps/ess/financials/generalLedger/programs/common</jobPath>
    <requestId>104406</requestId>
    <status>SUCCEEDED</status>
    </jobs>
    <jobs>
    <jobName>Upload Interface Error and Job Output File to Universal Content Management</jobName>
    <jobPath>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</jobPath>
    <requestId>104407</requestId>
    <status>SUCCEEDED</status>
    </jobs>
    <summaryStatus>SUCCEEDED</summaryStatus>
    <documentId>29395</documentId>
    <ICSFile xmlns="http://xmlns.oracle.com/cloud/ics/file/v1/types">
    <FileReference>file:/UCMFA00029847@_@FWuOVOF4UhKKvvPWIeKnwpHZg3AqNgjOdJL7GmRMald1FkKH0AU2ieloHd8JJgbKJrNTEQ72KE+UzFoElGGW8Yv4SrmyBE3SM/x0kK/i5ieZq7VPbsu1C5UaC6pGKAzD6YhPdjn1Viry8fx7NUQX3A==</FileReference>
    </ICSFile>
    </onJobCompletionRequest>
     
     
    If ERP Adapter can't cater Callback for an ESS Job, have you implemented successful ESS callback for ERP 19C through direct WebService? Please do let me know of the flow and services consumed then if it's a yes.
     
    Appreciate your inputs, thanks ahead!
     
     
    Regards,
    Moon
    Version:
    19.4.2.0.0 (191110.1400.32380)
    Code Snippet:
  • Jaeyshree Kumaran
    Cannot upload seeded extract output in UCM1
    Topic posted November 26, 2019 by Jaeyshree KumaranRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, Connection, E-Business Suite, Integration, Orchestration, PaaS, Process, REST, SOAP, Web Services, xml in Integration > Integration public
    Title:
    Cannot upload seeded extract output in UCM
    Content:

    I want my integration to (a)submit the seeded extract and (b)the output of seeded extract should be uploaded to UCM. I am able to do (a) but not able to do (b). I have set the delivery option as 'WebContentServer'.

    Also, I am able to achieve the same with custom extract.

     

    Version:
    Version: 19.4.2.0.0 (191110.1400.32380)
  • Syed Saifulla M
    Download ICS Monitoring logs using CURL commands3
    Topic posted November 26, 2019 by Syed Saifulla MGreen Ribbon: 100+ Points, tagged API, Cloud, Connection, Integration, PaaS, REST in Integration > Integration public
    Title:
    Download ICS Monitoring logs using CURL commands
    Summary:
    Download ICS Monitoring logs (flow and diagnostic logs) using CURL commands
    Content:

    Hi All,

    I am trying to download ICS Monitoring logs (flow and diagnostic logs) using CURL commands.

    I have tried the below possibilities :

    1) curl -X GET -u username:pasword -H "Accept:application/json" -o ./log2.txt https://icslearn-a436743.integration.us2.oraclecloud.com/icsapis/v2/monitoring/logs/archive

    2) curl -X GET -u username:pasword -H "Accept:application/json" -o ./log2.txt https://icslearn-a436743.integration.us2.oraclecloud.com/icsapis/v2/monitoring/logs/export

     

    ISSUE : It downloads a 0KB file.

    Could anyone please help me on this.