Posts

Posts

  • Pooja I
    Overwrite record in Mapper2
    Topic posted 8:01 AM by Pooja IBronze Medal: 1,250+ Points, tagged Integration, Mapping, Orchestration in Integration > Integration public
    Title:
    Overwrite record in Mapper
    Content:

    Hi Team,

       I have been trying to figure out a way for the below logic:

     

    I have a file, which has records like below:

    000PAM222604659MOWBRAY, SWATHY               101456      050 20191208   005
    000PAM222604659MOWBRAY, SWATHY               101456      050 20191208   006

    (005 and 006 is ID field)

    from the above file, I want to write only the record which has the latest ID i.e 006 from the above two records.

    I tried using

    1. javascript, but we cannot wirte the output array to OIC.

    2. Two for loops, looping through each record and writing the record. But overwriting the latest record is the issue.

    Please provide your suggestions!!

     

     

    Version:
    19
  • Marcelo Cavalcante
    OTM 19C integration callback issue2
    Topic posted Yesterday by Marcelo CavalcanteGreen Ribbon: 100+ Points, tagged Adapters, Cloud, Connection, Integration, Orchestration, PaaS in Integration > Integration public
    Title:
    OTM 19C integration callback issue
    Summary:
    TransmissionResponse is null and no order release has been created
    Content:

    Hello, community.

    I'm trying to create order releases into OTM through OIC.

    In Logistics adapter, I informed our Logistics integration WSDL: https://<our instance domain>/GC3Services/TransmissionService/call?wsdl.

    In the first attempts, I got database constraint errors. For that, I know I'm hitting OTM service.

    But, after correcting them, no order release has been created and the response has been as follows:

    <executeResponse xmlns="http://xmlns.oracle.com/apps/otm/TransmissionService">null</executeResponse>

    I found out the following article that states the same issue, but it is related to OTM 6.4.x versions and we are using OTM 19C.

    An issue was encountered after activation of OM-OTM pre-built integration. This pre-built integration integrates between Order Management- OM (from Oracle SCM Cloud) and OTM using Integration Cloud.

    Pre-built flow information

    Application Type Application Connector
    Source Application OM SCM Adapter
    Target Application OTM Logistics Adapter

     

    We wont go into the details of the integration itself. Refer to this Support note for details on the OM-OTM pre-built integration Sample Integration with OTM/GTM using ICS (Doc ID 2209248.1)

    Issue

    During testing of the flow it was seen that OIC monitoring shows successful transmission from OM to OTM and also a successful callback but a transaction was not created on OTM. However, the callback response from OTM shows "Null TransmissionBody" in the message as shown below

     Null TransmissionBody
    

    Resolution

    For OTM 6.4x, Transmission Service does not work when the OTM WSDL url is used in the logistics adapter connection. An offline TransmissionService wsdl has been made available which addresses this issue for 6.4x. It can be accessed from the below support note Transmission Service WSDL with Inline Schemas (Doc ID 2294108.1)

    Use the wsdl file provided in the support note when configuring the logistics adapter connection instead of the online wsdl url.

    Source: https://www.ateam-oracle.com/oic-integration-with-logistics-cloud/comment-submitted?cid=53e9f45e-36bd-479e-beb9-ecf851c6e887

    Does anyone knows if that is also the case for OTM 19C? WSDL URL for OTM 19C is also broken? If so, is that a place where I can download a working version? I could not find it.

    Version:
    OIC 19.4.2.0.0 (191120.0200.32560), OTM 19C
  • Samuel Lima
    How do I throw a business exception on ICS?Answered4
    Topic posted December 5, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration, Process in Integration > Integration public
    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 December 5, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration in Integration > Integration public
    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 December 5, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration in Integration > Integration public
    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 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:
  • Samuel Lima
    Pintinng imageAnswered3
    Topic posted December 3, 2019 by Samuel LimaBronze Medal: 1,250+ Points, tagged Integration, Orchestration in Integration > Integration public
    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 in Integration > Integration public
    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 in Integration > Integration public
    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 in Integration > Integration public
    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: