Integration

Get Involved. Join the Conversation.

Posts

  • Ven
    For each repeatable node issue1
    Topic posted 10:05 AM by VenGreen Ribbon: 100+ Points, tagged Integration 
    Title:
    For each repeatable node issue
    Summary:
    For each generating duplicate set of null values
    Content:

    I have mapped my source Repeatable element

    Items ---> Target Collection ( for each 1-2) and Items / leaf 1 values to Target fields

    Items ----> Target Collection (for each 2-2) and Items /Leaf 2 values to Targetfields is generating one duplicate set of items wit null values.

    How do i fix this duplication without null values.

     

  • Ven
    Date and time conversion1
    Topic posted 9:55 AM by VenGreen Ribbon: 100+ Points, tagged Integration 
    Title:
    Date and time conversion
    Summary:
    issue by String to Date and Time
    Content:

    I have a scinario of getting String type Date and Time values from Source need to populate into DB as a timestamp fields.

    I am facing issue for conversion of string to (datetime,date, time ) as DB timestamp format (YYYY-MM-DD HH-MM-SS) using ICS conversion functions which i tried date(),datetime() and time() are not working.

    String input 2019-12-09 09:06:24 --Expected Output  as datetime type : 2019-12-09 09:06:24

    String Input Date : 2019-12-09 ---Expected output as date type: 2019-12-09

    String Input Time : 05:00 --Expected Output  as pure Time type: 05:00:00

     

     

  • Tomotaka Hirai
    FTP adapter to FTPS site with IIS can't work(timeout...
    Topic posted 3:47 AM by Tomotaka Hirai, tagged Integration 
    Title:
    FTP adapter to FTPS site with IIS can't work(timeout by OIC)
    Summary:
    FTP adapter to FTPS site with IIS can't work(timeout by OIC)
    Content:

    I made a FTP adapter for FTPS site with Windows IIS. I tested the adapter and suceeded.

    But When I use it in Integraton, the Integration request is always timeout.

    Here is log in IIS side.

    IT keeps executing same FTP command.And after 600 seconds passed, OIC quited this request.

    Can't we use the FTP Adapter for IIS FTPS site? 

     

    ****log OIC side****

    Timeout has occurred after 600 seconds.oracle.fabric.common.FabricInvocationException: oracle.soa.api.invocation.InvocationException: com.bea.wli.sb.transports.client.SBTimeoutException: Timeout has occurred after 600 seconds.

    ********

     

    ****log IIS side****


    2019-12-12 08:57:28 ***.***.***.*** - YYY.YYY.YYY.YYY ControlChannelOpened - - 0 0 67a49bde-e640-4888-9523-1c767765878d -
    2019-12-12 08:57:28 ***.***.***.*** - YYY.YYY.YYY.YYY AUTH TLS 234 0 0 67a49bde-e640-4888-9523-1c767765878d -
    2019-12-12 08:57:29 ***.***.***.*** - YYY.YYY.YYY.YYY PBSZ 0 200 0 0 67a49bde-e640-4888-9523-1c767765878d -
    2019-12-12 08:57:29 ***.***.***.*** - YYY.YYY.YYY.YYY PROT P 200 0 0 67a49bde-e640-4888-9523-1c767765878d -
    2019-12-12 08:57:29 ***.***.***.*** - YYY.YYY.YYY.YYY USER testhira 331 0 0 67a49bde-e640-4888-9523-1c767765878d -
    2019-12-12 08:57:29 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASS *** 230 0 0 67a49bde-e640-4888-9523-1c767765878d /
    2019-12-12 08:57:29 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 67a49bde-e640-4888-9523-1c767765878d -
    2019-12-12 08:57:30 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY CWD - 250 0 0 67a49bde-e640-4888-9523-1c767765878d /
    2019-12-12 08:57:30 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY SIZE testhirain.csv 213 0 0 67a49bde-e640-4888-9523-1c767765878d /testhirain.csv
    2019-12-12 08:57:30 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY QUIT - 221 0 0 67a49bde-e640-4888-9523-1c767765878d -
    2019-12-12 08:57:30 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY ControlChannelClosed - - 0 0 67a49bde-e640-4888-9523-1c767765878d -
    2019-12-12 08:57:30 ***.***.***.*** - YYY.YYY.YYY.YYY ControlChannelOpened - - 0 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:57:31 ***.***.***.*** - YYY.YYY.YYY.YYY AUTH TLS 234 0 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:57:31 ***.***.***.*** - YYY.YYY.YYY.YYY PBSZ 0 200 0 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:57:32 ***.***.***.*** - YYY.YYY.YYY.YYY PROT P 200 0 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:57:32 ***.***.***.*** - YYY.YYY.YYY.YYY USER testhira 331 0 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:57:32 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASS *** 230 0 0 a337bd83-8405-46a9-a286-8e21aafda775 /
    2019-12-12 08:57:32 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:57:32 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:57:32 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY CWD / 250 0 0 a337bd83-8405-46a9-a286-8e21aafda775 /
    2019-12-12 08:57:33 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASV - 227 0 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:58:12 - HIRAIT-WIN2016\testhira 10.0.0.9 50975 DataChannelClosed - - 258 15 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:59:42 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY ControlChannelClosed - - 258 0 a337bd83-8405-46a9-a286-8e21aafda775 -
    2019-12-12 08:59:46 ***.***.***.*** - YYY.YYY.YYY.YYY ControlChannelOpened - - 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a -
    2019-12-12 08:59:47 ***.***.***.*** - YYY.YYY.YYY.YYY AUTH TLS 234 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a -
    2019-12-12 08:59:47 ***.***.***.*** - YYY.YYY.YYY.YYY PBSZ 0 200 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a -
    2019-12-12 08:59:48 ***.***.***.*** - YYY.YYY.YYY.YYY PROT P 200 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a -
    2019-12-12 08:59:48 ***.***.***.*** - YYY.YYY.YYY.YYY USER testhira 331 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a -
    2019-12-12 08:59:48 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASS *** 230 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a /
    2019-12-12 08:59:48 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a -
    2019-12-12 08:59:48 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY CWD - 250 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a /
    2019-12-12 08:59:48 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY SIZE testhirain.csv 213 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a /testhirain.csv
    2019-12-12 08:59:49 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY QUIT - 221 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a -
    2019-12-12 08:59:49 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY ControlChannelClosed - - 0 0 b60273c7-f44e-427f-ab3a-50f9115eff1a -
    2019-12-12 08:59:49 ***.***.***.*** - YYY.YYY.YYY.YYY ControlChannelOpened - - 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 08:59:49 ***.***.***.*** - YYY.YYY.YYY.YYY AUTH TLS 234 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 08:59:50 ***.***.***.*** - YYY.YYY.YYY.YYY PBSZ 0 200 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 08:59:50 ***.***.***.*** - YYY.YYY.YYY.YYY PROT P 200 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 08:59:50 ***.***.***.*** - YYY.YYY.YYY.YYY USER testhira 331 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 08:59:51 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASS *** 230 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 /
    2019-12-12 08:59:51 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 08:59:51 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 08:59:51 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY CWD / 250 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 /
    2019-12-12 08:59:51 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASV - 227 0 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 09:00:27 - HIRAIT-WIN2016\testhira 10.0.0.9 50991 DataChannelClosed - - 258 15 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 09:01:57 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY ControlChannelClosed - - 258 0 7e603f43-c7ce-43d8-a133-5d85988b16d1 -
    2019-12-12 09:02:03 ***.***.***.*** - YYY.YYY.YYY.YYY ControlChannelOpened - - 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 -
    2019-12-12 09:02:03 ***.***.***.*** - YYY.YYY.YYY.YYY AUTH TLS 234 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 -
    2019-12-12 09:02:04 ***.***.***.*** - YYY.YYY.YYY.YYY PBSZ 0 200 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 -
    2019-12-12 09:02:04 ***.***.***.*** - YYY.YYY.YYY.YYY PROT P 200 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 -
    2019-12-12 09:02:04 ***.***.***.*** - YYY.YYY.YYY.YYY USER testhira 331 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 -
    2019-12-12 09:02:05 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASS *** 230 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 /
    2019-12-12 09:02:05 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 -
    2019-12-12 09:02:05 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY CWD - 250 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 /
    2019-12-12 09:02:05 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY SIZE testhirain.csv 213 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 /testhirain.csv
    2019-12-12 09:02:05 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY QUIT - 221 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 -
    2019-12-12 09:02:05 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY ControlChannelClosed - - 0 0 5bb022af-0ef4-41a4-b6ce-6a7dae9652a6 -
    2019-12-12 09:02:06 ***.***.***.*** - YYY.YYY.YYY.YYY ControlChannelOpened - - 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:02:06 ***.***.***.*** - YYY.YYY.YYY.YYY AUTH TLS 234 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:02:07 ***.***.***.*** - YYY.YYY.YYY.YYY PBSZ 0 200 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:02:07 ***.***.***.*** - YYY.YYY.YYY.YYY PROT P 200 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:02:07 ***.***.***.*** - YYY.YYY.YYY.YYY USER testhira 331 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:02:07 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASS *** 230 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e /
    2019-12-12 09:02:07 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:02:08 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PWD - 257 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:02:08 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY CWD / 250 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e /
    2019-12-12 09:02:08 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY PASV - 227 0 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:02:47 - HIRAIT-WIN2016\testhira 10.0.0.9 51006 DataChannelClosed - - 258 15 5c432e0c-b367-44f0-81ae-0dee8a413b1e -
    2019-12-12 09:04:17 ***.***.***.*** HIRAIT-WIN2016\testhira YYY.YYY.YYY.YYY ControlChannelClosed - - 258 0 5c432e0c-b367-44f0-81ae-0dee8a413b1e -

    ********

    Image:
  • Visvanath prasanth
    Details and Implementation Doc on...Answered1
    Topic posted Yesterday by Visvanath prasanth, tagged Adapters, Cloud, Integration, PaaS 
    Title:
    Details and Implementation Doc on "oic.ics.stagefile.pgp.key.support" feature flag
    Summary:
    Details and Implementation Doc on "oic.ics.stagefile.pgp.key.support" feature flag
    Content:

    Hi,

    I need document or URL, explaining on "oic.ics.stagefile.pgp.key.support" feature flag which
    Support encryption/decryption in stage file read/write operation. Could you please help us with details of how it works once enabled and how to encrypt and decrypt using stage file.

    Thanks,

    Prasanth
     

  • Khalid Abdul Salam
    REST Adapter With Attachment Cannot have JSON ResponseAnswered6
    Topic posted Yesterday by Khalid Abdul SalamRed Ribbon: 250+ Points 
    Title:
    REST Adapter With Attachment Cannot have JSON Response
    Content:

    We have REST adapter integration where we configured the response to have attachments.

    Also, the response includes json response as summary of the attachment file contents.

    Everything works fine and as expected, we're able to receive the attachment file successfully at the response. But the response is not json, it's multipart/mixed.

    For example:

    <data contentType="multipart/mixed; charset=UTF-8" contentLength="390"><![CDATA[{  "status" : "1"}]]></data>

    At the REST adapter wizard, at Response tab, once we choose "Accept attachments from response", the only available media types are only "multipart/mixed" and "multipart/form-data". And this explains why we receive the response like that.

    I tried to add response header, but "Content-Type" is dimmed, cannot be chosen.

    So, my question, is there a way have a response of json along with attachments.

    Thanks.

     

    Image:
  • Pooja I
    Overwrite record in Mapper2
    Topic posted Yesterday by Pooja IBronze Medal: 1,250+ Points, tagged Integration, Mapping, Orchestration 
    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
  • Khalid Abdul Salam
    WriteStage Reference of CSV File Doesn't Exist Out of...Answered2
    Topic posted Yesterday by Khalid Abdul SalamRed Ribbon: 250+ Points 
    Title:
    WriteStage Reference of CSV File Doesn't Exist Out of Loop
    Content:

    I've an orchestration integration. Our target to post several transactions at ERP system one by one through loop and accumulate all responses into csv file then attach the file to the response.

    For this, we did the following:

    1. Get records from database

    2. Construct for-loop to go through these records.

    3. Within the for-loop, we consume REST API to create some transactions at Oracle Fusion.

    4. The response from the REST API is appended to StageWrite activity of csv.

    5. Out of the loop, we need to send the generated csv file at the response of the integration.

     The issue that when we try at the mapper of the integration response to map WriteStage Reference to Attachment of the response, WriteStage Reference doesn't exist. It exists only within the loop.

    The only workaround I can think of to to append a dummy record at the csv out of the loop to have the file reference.

    Is there a better solution rather than adding extra none needed record at the csv.

    Thanks.

    Version:
    19.4.2.0.0 (191120.0200.32560)
  • Avinash Jayaprakash
    OIC Callback OnjobCompletion vs Event based1
    Topic posted Yesterday 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.

  • Sridhar Yerram
    How to Publish an ICS Integration to APICS1
    Topic posted Yesterday by Sridhar YerramRed Ribbon: 250+ Points, tagged API, Integration 
    Title:
    How to Publish an ICS Integration to APICS
    Content:

    Team,

    Can you please guide me on the configuration required to publish an ICS Integration to APICS ?

    I did try to enter some info for publishing - as it does not have the expected info, its failing, want to get hold on what all details we have to mention for publishing to APICS, so it can be consumed.

    -Sridhar

     

    Image:
  • Marcelo Cavalcante
    OTM 19C integration callback issueAnswered3
    Topic posted December 10, 2019 by Marcelo CavalcanteGreen Ribbon: 100+ Points, tagged Adapters, Cloud, Connection, Integration, Orchestration, PaaS 
    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