Integration

Get Involved. Join the Conversation.

Posts

  • Avinash Jayaprakash
    ImportBulkData operation of ERPIntegration service without...15.0
    Topic posted Yesterday by Avinash Jayaprakash, tagged Cloud, ERP Cloud, Integration, Mapping, SOAP, Web Services, xml 
    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

     

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

  • Nick Cox
    Where are the OIC Pre-Built Integrations for CDM Merge...3
    Topic posted December 2, 2019 by Nick Cox, tagged Cloud, Integration, Sales Cloud 
    Title:
    Where are the OIC Pre-Built Integrations for CDM Merge please?
    Summary:
    Customer is asking for prebuilt integrations for CDM Merge to OSvC
    Content:

    The documentation for CDM refers to "predefined integrations" which support of merging / de-duplication activities.

    Please can someone point to where these are held?

    I already looked on the Oracle Market place and only see an Oracle Sales Cloud to Oracle Service Cloud - which  only syncs basic contact and account information 

    This requirement is specifically regarding merge / data dedupe functionality.

    Documentation Reference:

    https://docs.oracle.com/en/cloud/saas/sales-and-b2b-service/19d/oacdm/customer-data-management-integration-with-other-cloud-services.html#OACDM2857402

    Customer Data Management Integration Using the Integration Cloud Service

    You can use the Integration Cloud Service to leverage predefined integrations between Customer Data Management, other cloud services, and on premise applications. For example, you can integrate Oracle Service Cloud with Customer Data Management to provide the duplicate resolution capability. Using this capability, you can merge an Oracle Engagement Cloud account (organization) or contact (person) with an Oracle Service Cloud account (organization) or contact (person).

    Version:
    OIC 19.4.2.191110.1400-32380
    Code Snippet:
  • Nagesh Manda
    Identify Deprecated Services used in OIC Integration2
    Topic posted November 30, 2019 by Nagesh MandaGold Medal: 3,500+ Points, tagged Adapters, API, Cloud, ERP Cloud, Integration, PaaS, REST 
    Title:
    Identify Deprecated Services used in OIC Integration
    Content:

    Hi All,

    I would like to know if there is anyway to identify the list of the OIC Integrations which are potentially impacted by the use deprecated REST API's from the ERP Cloud. I know that even when oracle marks them as deprecated on the documentation they will still be available for a limited period of time (Not exactly sure about the time limit). If these services are used across on a large scale across different integrations is there anyway to identify the services without manually going and looking for the deprecated service in each integration?

    Thanks,

    Nagesh.

  • Karthick R
    OIC - Read CSV - Write CSV - Record written at Row 32
    Topic posted November 27, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, Cloud, ERP Cloud, Orchestration 
    Title:
    OIC - Read CSV - Write CSV - Record written at Row 3
    Summary:
    OIC - Read CSV - Write CSV - Record written at Row 3
    Content:

    Hi Everyone,

    I have a Source csv file in FTP location.
    I need a Target CSV file with static values along with source csv file information.
    File Written as expected but written at Row # 3 and column 'A' is skipped. This column A is empty.

    Regards,
    Karthick.R

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

  • Roman Schuster
    Map html to REST including tags2
    Topic posted November 25, 2019 by Roman SchusterGreen Ribbon: 100+ Points, tagged Adapters, Cloud, Integration, Mapping, PaaS, REST, RightNow, xml 
    Title:
    Map html to REST including tags
    Summary:
    When trying to map attributes containing html formating the tags are just removed by OIC.
    Content:

    We are trying to implement an integration between DB-AQ and a Oracle Service Cloud (REST). 

    The incoming payload that has html tags for Service Cloud formatting (e.g. <p>Dear Customer</p> <p>this is a welcome e-mail</p>) but when mapping this attribute to the REST-Endpoint OIC just removes all tags and passes only the text to the endpoint. 

    What are we doing wrong here? Is there a way to map the whole content without losing the html tags? 

    Thanks in advance, dear forum smiley

    Roman