Integration

Get Involved. Join the Conversation.

Posts

  • Pradvin Heggar Prabhakar
    Issue using file adapter to write to a csv file
    Topic posted 11:06 AM by Pradvin Heggar PrabhakarBlue Ribbon: 750+ Points 
    Title:
    Issue using file adapter to write to a csv file
    Summary:
    Issue using file adapter to write to a csv file
    Content:

    Hi Experts,

    I'm writing few records into a file using FTP and records are written correctly but there are two issues 

    1. Header is not displayed even after "Use first row as header" option

    2. I have a field named first name and it is string and it can have (,) comma in the data, even though i have selected optionally enclosed by " my data is not enclosed by ".

    I have attached the screenshot of my configuration.

     

    Thanks,

    Pradvin

     

     

    Image:
  • Mohana Gopal Selvam
    Response not mapped95.0
    Topic posted 6:47 AM by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged Integration, Orchestration 
    Title:
    Response not mapped
    Content:

    Hi,

    My integration is not providing the result map as expected. I have checked the response in Activity stream which I got the expected result, but it is not mapped in my response. Where can I validate this?

    Response:

    Response Received Successfully from Target <getApplicationStatusResponse xmlns=""><applicationStatus xmlns="">In Process</applicationStatus></getApplicationStatusResponse>

     

    Thanks,

    Mohan

    Image:
  • Mohana Gopal Selvam
    ConnectivityProperty - Not available125.0
    Topic posted 6:01 AM by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged Adapters, Integration, SOAP 
    Title:
    ConnectivityProperty - Not available
    Content:

    Hi,

    Our OIC version is 19.3.2.0.0

    But ConnectivityProperties are not displaying as per document

    https://docs.oracle.com/en/cloud/paas/integration-cloud/soap-adapter/oracle-soap-adapter-concepts.html#GUID-108FBA5E-9509-4E68-83DE-AA6A480D6938__SUPPORTFORDYNAMICENDPOINTS-BB0A9D2D

    .Thanks,

    Mohan

    Image:
  • Sanin Thulapparumban
    Suggestion Required On - Pull BULK Data in Segments/ChunksAnswered65.0
    Topic posted 1:58 AM by Sanin ThulapparumbanRed Ribbon: 250+ Points, tagged API, Integration 
    Title:
    Suggestion Required On - Pull BULK Data in Segments/Chunks
    Summary:
    Suggestion Required On - Pull BULK Data in Segments/Chunks
    Content:

    Dear All,

    Requirement:

    We have a requirement where we have to develop Parts/ Item Outbound Integration from Oracle to SAP. This integration is for a Service Center where all types of car get serviced and painted. They have around 1 Million Parts/ Items . The Requirement is to push only net change records (i.e. only those items which get newly created/ updated) to SAP. For few items the the integration works fine. but sometime when they add new model or a new car parts details the net change record count may go above 100,000. While testing this scenario, OIC Integration flow is getting rejected because of exceeding the report data(.csv) maximum size of  >10MB.

    Suggestion Required On:

    How to pull the BULK Data from Report Data in Segments/Chunks/Batches and send to DBCS using UCM [Universal Content Management] Webservice.

    Appreciate your quick response.

     
  • BlueBell
    Special Char issue in OICAnswered61.0
    Topic posted 12:43 AM by BlueBellRed Ribbon: 250+ Points, tagged PaaS 
    Title:
    Special Char issue in OIC
    Summary:
    Special Char issue in OIC
    Content:

    Hi All,

    I am facing a issue while passing a param value containing Special char in payload.For e.g I am writing a stage file passing its conent value as España but if I check the written file España becoming Espa?a .

    ñ is becoming ? in the written file.

    Could you please suggest how to resolve this issue.

  • Fernando Paes
    Issue with Array in JSON65.0
    Topic posted Yesterday by Fernando PaesBlue Ribbon: 750+ Points, tagged Adapters, Cloud, Integration, Mapping, REST 
    Title:
    Issue with Array in JSON
    Summary:
    Arrays not being handled correctly with in Json request
    Content:

    Hello,

    I hope you can help me with the following. I have an integration where I need to push Opportunities to JDEdwars via standard REST adapter.

    The Json request have some section that are arrays, but is creating some issues: formActions, gridRowInsertEvents.

    {
        "token""***",
        "formServiceAction""U",
        "deviceName""CRM",
        "formName""***",
        "formActions": [{
                "gridAction": {
                    "gridID""1",
                    "gridRowInsertEvents": [{
                        "gridColumnEvents": [{
                                "command""SetGridCellValue",
                                "value""175516",
                                "columnID""14",
                                "columnDescription""CRM Row Id"
                            },
    .....
                        ]
                    }
                ]
                }
            },
            {
                "command""DoAction",
                "controlID""12"
            }
        ]
    }
     

     The issue comes when OIC builds the request and send it over to JDE. It ignores the [] for the formActions section and gridRowInsertEvents sections, and also the {} that enclose command and controlID are also ignored. This is how OIC is building that request:

    {
            "nsmpr6:token""***",
            "nsmpr6:formServiceAction""U",
            "nsmpr6:deviceName""CRM",
            "nsmpr6:formName""***",
            "nsmpr6:formActions": {
              "nsmpr6:gridAction": {
                "nsmpr6:gridID""1",
                "nsmpr6:gridRowInsertEvents": {
                  "nsmpr6:gridColumnEvents": {
                    "nsmpr6:command""SetGridCellValue",
                    "nsmpr6:value""***",
                    "nsmpr6:columnID""14",
                    "nsmpr6:columnDescription""CRM Row Id"
                  }
                }
              },
              "nsmpr6:command""DoAction",
              "nsmpr6:controlID""12"
            }
      }

    This payload is not accepted by JDE, leading to the record not being created.

    Does anyone know what could I do here?

    I have tried to add more repetitions within the arrays to force the [] to show up, which works, but the command and controlID section is still and issue, and is key as it is where we tell JDE to insert the record.

     

    Thanks in advance.

     

    Version:
    Version: 19.3.2.0.0 (190819.0200.30840)
  • Harish Gundre
    Maximum number of transactions / records in FBDI file25.0
    Topic posted Yesterday by Harish Gundre, tagged ERP Cloud, Integration 
    Title:
    Maximum number of transactions / records in FBDI file
    Content:

    Hi,

    We are using FBDI to process large volume of transactions into ERP Cloud.

    Maximum how many transaction we can process using single FBDI file.

     

    Thanks

    Harish

  • Pradvin Heggar Prabhakar
    Unable to access /hcmRestApi/resources/11.13.18.05/emps REST...5
    Topic posted September 14, 2019 by Pradvin Heggar PrabhakarBlue Ribbon: 750+ Points 
    Title:
    Unable to access /hcmRestApi/resources/11.13.18.05/emps REST API from POSTMAN
    Summary:
    Unable to access /hcmRestApi/resources/11.13.18.05/emps REST API from POSTMAN
    Content:

    Hi Experts,

       I'm trying to connect to rest api /hcmRestApi/resources/11.13.18.05/emps to get all the employee details but getting below error.

    403 Forbidden,The request was a legal request, but server is refusing to respond.

    I have below roles

    1. Integration Specialist Role
    2. “Human Capital Management Integration Specialist” role
    3. Employee

    Any roles are missing and also do i need to provide data access to any roles mentioned above?

    Thanks,

    Pradvin

  • VR
    External Service BIP WS17
    Topic posted September 13, 2019 by VRBlue Ribbon: 750+ Points, tagged Cloud, ERP Cloud, Integration, Orchestration, PaaS, SOAP, xml 
    Title:
    External Service BIP WS
    Content:

    External webservice for BIP report fetches only part of the report but entire response is fetched from soap UI.

    <COUN  ******* Payload Truncated ******* is received in the response for part of the report.

    The data size is around 3MB from SOAP UI with around 8000 records. Kindly let me know why the data fetch is partial in OIC. I have provided datachunk size as -1.

  • Digvijay Chauhan
    Invoke OIC integration from ERP Financials65.0
    Topic posted September 13, 2019 by Digvijay ChauhanBlue Ribbon: 750+ Points, tagged Cloud, Integration, Web Services 
    Title:
    Invoke OIC integration from ERP Financials
    Summary:
    Invoking OIC integration from ERP SaaS ESS or BIP
    Content:

    Hi All,

    Is there a way to invoke an OIC integration from SaaS ESS job. We have few integration that needs to be run on ad-hoc basis by business users.

    What other alternatives we have to allow ERP SaaS application business users to trigger an integration?

    Thanks

    Dvi