Integration

Get Involved. Join the Conversation.

Posts

  • Samuel Lima
    How do I throw a business exception on ICS?2
    Topic posted Yesterday by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration, Process 
    Title:
    How do I throw a business exception on ICS?
    Content:

    Hi experts,

    I created an integration in ICS that calls a search API. When I pass a filter that returns no records, the API returns an exception but ICS integration is returning this exception as a system exception when I would like it to return a business exception. I dealt with my process built in PCS to catch and handle business exceptions but this integration is only returning system exceptions. I would like to handle this exception that is returned from the search API through Global Failure and throw a business exception so that it is properly caught in the process.

    How do I throw a business exception on ICS?

    Thanks,

    Samuel Lima

  • Samuel Lima
    Mappings in a sequenceAnswered1
    Topic posted Yesterday by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration 
    Title:
    Mappings in a sequence
    Content:

    Hi experts,

    Is it possible to have two ou tree mappings in a sequence instead of one very complex mapping?

    That is, each one does part of the whole mapping instead of just one?

    Do the following ones erases all the mappings done by the precedent ones?

    Thanks,

    Samuel Lima.

    Image:
  • Samuel Lima
    Break ForEachAnswered6
    Topic posted Yesterday by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration 
    Title:
    Break ForEach
    Summary:
    Is there a way to break a foreach?
    Content:

    Hi experts,

    Is there a way to break a ForEach for a certain condition?

    Sometimes foreach inside foreach executes unnecessary iterations as in the image attached.

    Thanks, 

    Samuel Lima

    Image:
  • 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:
  • Samuel Lima
    Pintinng image2
    Topic posted December 3, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration 
    Title:
    Pintinng image
    Summary:
    Is there a way to print the integration orchestration as a jpg/png image?
    Content:

    Hi experts,

    Is there a way to print the integration orchestration as a jpg/png image?

    Thanks,

    Samuel Lima

    Version:
    19.4.2.0.0 (191110.1400.32380)
    Image:
  • Samuel Lima
    Move elements into an ifAnswered1
    Topic posted December 2, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration 
    Title:
    Move elements into an if
    Summary:
    Is it possible to move elements into an if ?
    Content:

    Hi, experts,

    Could you tell me whether it is possible to move elements inside an if or do I have to delete and recreated them again?

    Thanks,

    Samuel Lima

    Image:
  • Karthick R
    How to remove trailing Z from currentDate Function.Answered2
    Topic posted December 2, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Integration, Orchestration 
    Title:
    How to remove trailing Z from currentDate Function.
    Summary:
    How to remove trailing Z from currentDate Function.
    Content:
    Hi Everyone,

    How to remove trailing 'Z' added to currentDate function?
    Example - 2019-11-27Z

    Regards,
    Karthick.R
  • 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)