Posts

Posts

  • Avinash Jayaprakash
    OIC Callback OnjobCompletion vs Event based1
    Topic posted December 11, 2019 by Avinash Jayaprakash, tagged Adapters, Cloud, Connection, ERP Cloud, Integration, PaaS, SOAP, Web Services in Integration > Integration public
    Title:
    OIC Callback OnjobCompletion vs Event based
    Summary:
    OIC ERP adaptor has a new update
    Content:

    I have found the onJobComplettion operation for callback is no more generic for all the objects(Payables,Receivables,Import Journals). Oracle has made it callback as object specific. We cannot make a callback as generic for all the objects. Is it true? and is it a good approach to go with event based callback, so that callback service could be generic for all the importBulkData operation. Please let me know your input on this.

  • Sathya Rajendran
    Send mailings to contact using...6
    Topic posted December 10, 2019 by Sathya RajendranGold Medal: 3,500+ Points, tagged SOAP in B2C Service > Integrations and APIs for Service public
    Title:
    Send mailings to contact using "SendMailingToContact" with attachments
    Content:

    Hello All,

    I need to send an email to contact with attachments and it is a pdf. can we use "SendMailingToContact" to send email with attachments or only way to use Public mail API's?

     

    Thanks in Advance

     

  • Avinash Jayaprakash
    ImportBulkData operation of ERPIntegration service without...15.0
    Topic posted December 5, 2019 by Avinash Jayaprakash, tagged Cloud, ERP Cloud, Integration, Mapping, SOAP, Web Services, xml in Integration > Integration public
    Title:
    ImportBulkData operation of ERPIntegration service without properties file
    Content:

    How to load FBDI file to ERP using importBulkData operation using ERPIntegration service using parameterList parameter instead of properties file. I have tried loading zipped FBDI file, but its thowing fault as it is expecting properties file. Please find below for the sample request payload.

     

    <importBulkData xmlns:ns0=\"http://www.oracle.com/XSL/Transform/java/com.bea.wli.sb.resources.icsxpathfunctions.ICSInstanceTrackingFunctions\" xmlns:sdoXML=\"commonj.sdo/xml\" xmlns:plnk=\"http://schemas.xmlsoap.org/ws/2003/05/partner-link/\" xmlns:nsmpr6=\"http://xmlns.oracle.com/cloud/ics/fa/v1/ucm/\" xmlns:sdoJava=\"commonj.sdo/java\" xmlns:nsmpr7=\"http://www.oracle.com/XSL/Transform/java/com.bea.wli.sb.functions.dvm.DVMFunctions\" xmlns:nsmpr8=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_DownloadFBDIZipFile_REQUEST/types\" xmlns:wsdl=\"http://schemas.xmlsoap.org/wsdl/\" xmlns:nsmpr9=\"http://xmlns.oracle.com/types/InvokeImportBulkData/OutboundSOAPRequestDocument\" xmlns:nsmpr2=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_DownloadFBDIZipFiles_REQUEST/types\" xmlns:ns35=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_DownloadFBDIZipFile_REQUEST\" xmlns:nsmpr3=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_ListFBDIFiles_REQUEST/types\" xmlns:ns34=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_ListFBDIFiles_REQUEST\" xmlns:xml=\"http://www.w3.org/XML/1998/namespace\" xmlns:ns33=\"http://xmlns.oracle.com/ics/tracking/ics_tracking_context.xsd\" xmlns:ns32=\"http://xmlns.oracle.com/procmon\" xmlns:nsmpr0=\"http://xmlns.oracle.com/cloud/adapter/erp/Invoke_ImportBulkdata_REQUEST\" xmlns:ns37=\"http://xmlns.oracle.com/adf/svc/types/\" xmlns:dvm=\"http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue\" xmlns:nsmpr1=\"http://xmlns.oracle.com/cloud/list/pull\" xmlns:types=\"http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/\" xmlns:nxsd=\"http://xmlns.oracle.com/pcbpel/nxsd\" xmlns:orajs1=\"http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.JsExecutor_ENCRYPTDECRYPTSAMPLE_01_00_0000_encryptDecryptSample_encryptDecryptSample_param1\" xmlns:orajs2=\"http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.JsExecutor_GETSTARTTIME_01_00_0000_startTime_getStartDate_param1\" xmlns:orajs0=\"http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.JsExecutor_STRINGREPLACE_01_00_0000_StringReplaceJS_StringReplaceJS_inputKey_ReplaceWith\" xmlns:tns=\"http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/\" xmlns:nstrgmpr=\"http://xmlns.oracle.com/cloud/adapter/erp/Invoke_ImportBulkdata_REQUEST/types\" xmlns:orafault=\"http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0\" xmlns:errors=\"http://xmlns.oracle.com/adf/svc/errors/\" xmlns:soap=\"http://schemas.xmlsoap.org/wsdl/soap/\" xmlns:sdo=\"commonj.sdo\" xmlns=\"http://xmlns.oracle.com/cloud/adapter/erp/Invoke_ImportBulkdata_REQUEST/types\">
        <nstrgmpr:document>
            <tns:DocumentId>1909238</tns:DocumentId>
        </nstrgmpr:document>
        <nstrgmpr:jobDetails>
            <tns:JobName>/oracle/apps/ess/financials/generalLedger/programs/common/,JournalImportLauncher</tns:JobName>
            <tns:ParameterList>300000279764762,Payables,300000009274397,ALL,N,N,N</tns:ParameterList>
        </nstrgmpr:jobDetails>
        <nstrgmpr:notificationCode>30</nstrgmpr:notificationCode>
    </importBulkData>

     

    Please let me know if anyone has input on this.

     

    Thanks,

    Avinash

     

  • Jaymin kansara
    Error while creating custom fields on contact Object12
    Topic posted December 5, 2019 by Jaymin kansaraGreen Ribbon: 100+ Points, tagged SOAP in B2C Service > Integrations and APIs for Service public
    Title:
    Error while creating custom fields on contact Object
    Content:

    Hi,

    How can we create custom fields on Contact object through SOAP API XML format?  I tried creating one but getting below error.:

    Can anyone suggest please.

    Code Snippet:
  • 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 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)
  • Sylvia S
    Setting trigger in Service Cloud to OIC2
    Topic posted December 2, 2019 by Sylvia SBronze Medal: 1,250+ Points, tagged Connect PHP, Custom Process Models - CPMs, SOAP in B2C Service > Integrations and APIs for Service public
    Title:
    Setting trigger in Service Cloud to OIC
    Summary:
    Setting trigger
    Content:

    Hi Guys,

    I am trying to achieve an integration between Service Cloud and Eloqua where if a contact is updated in Service Cloud, the contact is updated in Eloqua through OIC. Based on the documentation am using, an event handler should be created to trigger the process. Can anyone share any information, ideas or documentation on how to go about this?

    Thanks,

    Sylvia

  • Jim Reynolds
    Default PageSize of SOAP APIAnswered2
    Topic posted November 28, 2019 by Jim ReynoldsRed Ribbon: 250+ Points, tagged SOAP in B2C Service > Integrations and APIs for Service public
    Title:
    Default PageSize of SOAP API
    Content:

    Hi,

    We are looking to know what the default 'PageSize'(see attached PageSize.png) is for our production instance of Oracle Service Cloud (https://students.connect.curtin.edu.au/) for the SOAP API QueryCSV request?

    Can the current default value be viewed anywhere without having to contact Oracle?

    We believe it has never been altered, but it could be affecting an important integration involving Oracle Integration Cloud and Oracle Eloqua that we are trying to launch.

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