Integration

Get Involved. Join the Conversation.

Posts

  • Marcelo Cavalcante
    OTM 19C integration callback issue1
    Topic posted Yesterday 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
  • Ritika Sharma
    Insertion of data in stage tables4
    Topic posted December 6, 2019 by Ritika Sharma, tagged Adapters, Integration, REST 
    Title:
    Insertion of data in stage tables
    Content:

    Hi, 

    I have an integration with Fusion where I need to read a file. Then within OIC, create temp table to store the contents of file and do calculations on the data in the table before sending a response to Fusion application.

    Is there a provision to create temp/stage tables in OIC interface and they get dropped when the flow completes?

    Any pointers will be of help!

    Thanks

    Ritika

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

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

  • malay pradhan
    Movement Request Create from OIC EBS adapter2
    Topic posted November 27, 2019 by malay pradhanGreen Ribbon: 100+ Points, tagged Adapters, E-Business Suite, ERP Cloud, Integration, PaaS 
    Title:
    Movement Request Create from OIC EBS adapter
    Summary:
    Is Movement Request Create possible from OIC EBS adapter?
    Content:

    I am trying to create Movement Request in EBS.

    I am aware that there is a Rest Api available for the same. However i was wondering if the same can be achieved by using the OIC EBS Adapter.

    I went through the Business Objects in the adapter but did not see any option for Movement Request.

    Is it possible to achieve this in OIC EBS adapter ??

    If yes, which is the Business Unit or service i should be using ??

     

    TIA for the help.

    Version:
    OIC 19
  • 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:
  • Priyanka Mishra
    Perform On Table - Select operation is not working as...4
    Topic posted November 27, 2019 by Priyanka MishraGreen Ribbon: 100+ Points, tagged Adapters, Database, Integration, Mapping, PaaS, xml 
    Title:
    Perform On Table - Select operation is not working as expected
    Summary:
    Perform On Table - Select operation is not working as expected
    Content:

    Hi ,

    I am trying to fetch data from two tables. I am doing it with "Perform operation on table " option with select operation. 

    Problem is it's always fetching the child table data for 1st parent table record. For other Parent table records, I am getting child table data as blank.

    Data is available in the table.

    Attaching a sample file. invBalanceTxnsLotIntCollection_2 is coming as NULL for snapshotId '60509'. Data is availble in child table.

     

    Thanks,

    Priyanka

     

    Is there any setting needs to be done while configuring t he DB adapter? Kindly provide your inputs.

     

     

    Document:
  • 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)