Integration

Get Involved. Join the Conversation.

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

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

  • 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)
  • Mahesh Kumar
    Change Default encoding format to download zip file from UCM8
    Topic posted November 15, 2019 by Mahesh KumarGreen Ribbon: 100+ Points, tagged Cloud, E-Business Suite, ERP Cloud, Integration, REST, SOAP, Web Services 
    Title:
    Change Default encoding format to download zip file from UCM
    Summary:
    SOAP Response from Web Service should always receive Base64 encoding instead of Binary encoding
    Content:

    Is there any setup in the Cloud instance that can be changed to get a default response from Web Service in the Base64 format for the attachments?

    I am trying to download a zip file using SOAP Web Service on the EBS system. I get the response from web service but in binary format. Can the default web service be changed to the Base64 format in the cloud using some setup change?

    To upload a file in ucm we have to convert the file into base64 encoding and send the SOAP request to the cloud and the file gets uploaded. So similarly can we make default setup change to get files from ucm directory in base64 format only?

     

     

    Document:
  • Karthick R
    FTP Adapter - Master Detail CSV File - Unable to IDENTIFY...6
    Topic posted November 10, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, Integration, Mapping, Orchestration, SOAP, Web Services 
    Title:
    FTP Adapter - Master Detail CSV File - Unable to IDENTIFY master detail information
    Summary:
    FTP Adapter - Master Detail CSV File - Unable to IDENTIFY master detail information
    Content:

    Hi Everyone,

    Scenario- CSV placed in FTP location in the below format. This CSV is supposed to be a Master Detail file.
    Now, How can we infer whether it's a header or line information from CSV file?
    I was looking for options in the OIC read file schema section. But found nothing.
    There weren't sub elements available.

    Reason for Identification - After processing the file I have to invoke Fusion AR - Invoice creation web service which expects header and line information.

    Header fields:
    1. Business Unit
    2. Transaction Source
    3. Transaction Type
    4. Transaction Number
    5. Transaction Date

    Line Fields:
    1. Line Number
    2. Description
    3. Quantity
    4. Unit Price

    Sample CSV Data File Format:
    BUSINESS UNIT,TRANSACTION SOURCE,TRANSACTION TYPE,TRANSACTION NUMBER,TRANSACTION DATE,LINE NUMBER,DESCRIPTION,QUANTITY,UNIT PRICE
    BU1, INVOICE, CREDIT_INVOICE,12345, 2019-11-10,1, Line1,10,5
    , , , , 2019-11-10,2, Line2,20,10
    , , , , 2019-11-10,3, Line3,30,15
    BU2, INVOICE, CREDIT_INVOICE,67890, 2019-11-10,1, Line1a,40,20
    , , , , 2019-11-10,2, Line2a,50,25
    , , , , 2019-11-10,3, Line3a,60,30

    Regards,
    Karthick.R

  • Subarna Karmakar
    Rundatamodel for report service2
    Topic posted November 7, 2019 by Subarna Karmakar, tagged Cloud, Integration, SOAP, Web Services, Workday 
    Title:
    Rundatamodel for report service
    Summary:
    Rundatamodel for report service
    Content:

    Hi,

     

    I am trying to invoke a report service for HCM through ICS where providing the person number in the report will fetch the output of the worker . But whilei nvoking the report service I am receiving below error . The report is present in the location correctly

    {http://schemas.oracle.com/bpel/extension}remoteFault - oracle.xdo.webservice.exception.OperationFailedException: PublicReportServiceImpl::generateReportXMLData Failure due to unable to Access and oracle.xdo.servlet.CreateException: Data Model definition not found:/Custom/Human Capital Management/AMT Active Assignment Integration Report.xdo

    Please help.

  • gabriel kinovisques
    Web Services Avaliable for ERP Cloud2
    Topic posted November 5, 2019 by gabriel kinovisquesRed Ribbon: 250+ Points, tagged Cloud, Connection, Web Services 
    Title:
    Web Services Avaliable for ERP Cloud
    Summary:
    Web Services Avaliable for ERP Cloud
    Content:

    Hello :

    I was wondering if you can share with me the Web Services Avaliable for ERP Cloud, I have inquiry the OER but I was not able to find them.

    Please Advise

    https://docs.oracle.com/en/cloud/get-started/subscriptions-cloud/connect-using-oracle-network-cloud-service-fastconnect.html