Posts

Posts

  • Cesar Tepetla Corte
    Pull specific File from Agent server leveraging File Adapter3
    Topic posted April 3, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, Agent, Connection, Database, Integration, Mapping, Orchestration, Process, xml in Integration > Integration public
    Title:
    Pull specific File from Agent server leveraging File Adapter
    Summary:
    Pull specific File from Agent server leveraging File Adapter
    Content:

    I am working on two integrations the first one writes a file on a server using the file adapter and also inserts in a database table the name of the file that you just created.

    In the integration two using the file adapter as trigger performs the operation 'File polling' here is where the interesting thing begins because I just want to get the file created in the first integration
    That's why in the second integration after placing the trigger I invoke the database where I save the file name and add a switch object to make the comparison where I establish that if the name obtained from the file adapter is equal to the field of the database table then write your content in another FTP directory (filename and content file).

    I do not get any errors when making this comparison however the comparison is only done once but according to my understanding the comparison should be made for each file that the file adapter is reading.

    I tried adding a for-each to perform the comparison for each read file however it marks me an error (The select node (InboundFileHeaderType) is not repeating.)

     

    Image:
  • Nirmal Kumar
    HDL File upload to UCM not working through OIC11
    Topic posted March 23, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged Adapters, Agent, Cloud, Connection, Database, E-Business Suite, Integration, Mapping, Orchestration, SOAP, Web Services, xml in Integration > Integration public
    Title:
    HDL File upload to UCM not working through OIC
    Summary:
    HDL File upload to UCM not working through OIC
    Content:

    Hi All,

    I am trying to upload worker.dat HDL file to UCM server through OIC integration.

    But it is failing with the below error -

    Content item 'UCMFA00012909' was not successfully checked in. The content type 'dat' is not defined in the system. :Application Error

    I also tried uploading Worker.zip file. But getting similar error saying - Content type 'zip' is not defined in the system.

    Can you please help resolve it.

    Attached is the screenshot of mapping. Please let me know if setup is correct.

     

    Thanks,

    Nirmal

    Version:
    Version: 19.1.5.0.0
    Document:
  • logu Prasanth
    Unable to get a Response from EBS using rest API In SOAP UI.2
    Topic posted March 25, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Cloud, Connection, Database, E-Business Suite, ERP Cloud, Integration, Mapping, Orchestration, REST, SOAP, Web Services, xml in Integration > Integration public
    Title:
    Unable to get a Response from EBS using rest API In SOAP UI.
    Summary:
    Unable to get REST URI Response thorough SOAP UI.
    Content:

    We are deployed PLSQL record type code in EBS as REST API. 

    we are unable to get a response through SOAP UI. we are getting below Error

    <data contentType="text/plain" contentLength="303"><![CDATA[{
     "ISGServiceFault" : {
       "Code" : "ISG_SERVICE_EXECUTION_ERROR",
       "Message" : "Error while executing service",
       "Resolution" : "Please check Server logs.",
       "ServiceDetails" : {
         "ServiceName" : "XXDH_NEW_BUD_CHK",
         "OperationName" : "create_temp_tbl",
         "InstanceId" : "0"
       }
     }
    }]]></data>

    I attached xsd file for your reference. kindly tell me the input(json type) for REST URI

    Document:
  • Cesar Tepetla Corte
    How to read file using ICS file adapter63.0
    Topic posted March 11, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, Agent, API, Integration, Orchestration, REST, Web Services in Integration > Integration public
    Title:
    How to read file using ICS file adapter
    Summary:
    Read a file from an FTP server using file adapter.
    Content:

    Hi everyone,

    I am working on an integration to read an FTP file I was previously working with the FTP adapter and this worked without problem but we have changed the server and due to security the only option they gave us was to use the file adapter.
    I created a small exercise to read a file but without success when I activate the integration it shows me a WSDL that when opening it tells me the error: "Error 503 - Service Unavailable
    From RFC 2068 Hypertext Transfer Protocol - HTTP / 1.1:
    503 Service Unavailable "

    Any opinions and comments are grateful.

    Regards,

    Bartholomew

     

  • Rohit Mopuri
    Connectivity Agent in OIC - Recommendation115.0
    Topic last edited March 11, 2019 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Agent, Cloud, Integration in Integration > Integration public
    Title:
    Connectivity Agent in OIC - Recommendation
    Summary:
    Connectivity Agent in OIC - Recommendation
    Content:

    Hello experts,

     

    When we install a connectivity agent on windows system. Is it recommended to have a seperate VM for the agent or is it ok to have an existing VM where other windows services are also installed.

    What are the pros and cons for having a separate VM.

    Regards,

    Rohit,

  • Moon Ray Lo
    OIC Exception/Error Handling & Recoverable InstanceAnswered65.0
    Topic last edited March 11, 2019 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Adapters, Agent, API, Case Management, Cloud, Connection, Database, E-Business Suite, Eloqua, ERP Cloud, Events, Integration, Mapping, NetSuite, Orchestration, PaaS, Primavera, Process, REST, RightNow, Sales Cloud, Salesforce, SAP, Siebel, SOACS, SOAP, Taleo, Tip, Web Services, Workday in Integration > Integration public
    Title:
    OIC Exception/Error Handling & Recoverable Instance
    Summary:
    Oracle Integration Cloud's Exception/Error Handling & Recoverable Instance
    Content:

    Hi Team,

     

    I have noticed that NOT ALL instances that faulted can be recovered or resubmitted for reprocessing - based from y experience, I have resubmitted/recovered some (scheduled integration) and unable for others (app-driven integration)

     

    I'd like to know as to which specific conditions would an instance considered as recoverable when fault encountered.

     

    Thanks ahead,

    Moon

    Version:
    19.1.3.0.0 (190129.1200.23460)
  • Nirmal Kumar
    Outbound from EBS to OIC6
    Topic posted January 8, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged Adapters, Agent, Cloud, Connection, E-Business Suite, ERP Cloud, Events, Integration, REST, SOAP, Web Services in Integration > Integration public
    Title:
    Outbound from EBS to OIC
    Summary:
    Outbound from EBS to OIC
    Content:

    Hi All,

    When outbound interface happens from EBS to OIC, does/should the traffic from EBS go directly to OIC through proxy server without involving OIC agent?

    Or both inbound and outbound traffics must go via OIC agent only?

    Please provide clarification.

     

    Thanks,,

    Nirmal 

    Version:
    OIC version 18.4.5.0.0
  • Nirmal Kumar
    E-business suite business event is not reaching ICS3
    Topic posted January 3, 2019 by Nirmal KumarRed Ribbon: 250+ Points, tagged Adapters, Agent, Cloud, Connection, E-Business Suite, Events, Integration, REST in Integration > Integration public
    Title:
    E-business suite business event is not reaching ICS
    Summary:
    E-business suite business event is not reaching ICS
    Content:

    Dear All,

    I am creating a HRMS Job in E-business suite and the same must be interfaced to HCM via ICS.

    I have enabled the business event in EBS related to Create Job and I have built integration in ICS using EBS adapter to receive business events. 

    But when I create new jobs in EBS, nothing comes into ICS. The logs are showing 0 messages.

    Not sure if I am using EBS event subscriptions correctly. Please Let me know subscription creation steps.

    Request you all to provide suggestions. Looking forward to your help. 

     

    Thanks,

    Nirmal

  • Robert Cruickshank
    ERP and SCM Cloud Data Extracts to on-premise data warehouse
    Topic posted December 29, 2018 by Robert CruickshankGreen Ribbon: 100+ Points, tagged Adapters, Agent, Cloud, Connection, Database, E-Business Suite, ERP Cloud, Integration, Mapping, SOAP, xml in Integration > Integration public
    Title:
    ERP and SCM Cloud Data Extracts to on-premise data warehouse
    Summary:
    Need advice on best option for extract data from ERP/SCM Cloud to on-premise wartehouse. Looked at BI Cloud Connect, but believe that requires a UCM Server on-premise.
    Content:

    Need advice on best option for extract data from ERP/SCM Cloud to on-premise data warehouse.

    Looked at BI Cloud Connect, but believe that requires a UCM Server on-premise. Which would mean a new license as well ?

    Reviewed the Financials Data Extract (Oracle Support 2303683.1). This sounds like a possibility as it also mentions the possibility of using custom BIP reports through the ERP Integration Services.

    We plan to have Oracle Autonomous Integration Service and would prefer to put extracts through that for visibility. However, I am keen to find a solution, relatively 'out of the box', rather than developing multiple extracts from scratch (probably unavoidable).

    Would Data Integration Platform Cloud (DIPC)  also be a good fit? I think so, but think it is probably overkill for the simplicity of incremental data extracts.

    Note HCM Extracts is another option for HCM Data, is their the same for SCM and Financials data?

    rgds

    Rob

     

     

     

  • Moon Ray Lo
    Integration with HCM Extract Run & Retrieve Flow2
    Topic posted December 15, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Cloud, Connection, Database, Integration, Mapping, Orchestration, PaaS, SAP, SOAP, Web Services in Integration > Integration public
    Title:
    Integration with HCM Extract Run & Retrieve Flow
    Summary:
    This is to take note the best practices to observe when integrating OIC with HCM's Extract Run-Retrieve Flow
    Content:

    Hi Team,

     

    I'd like to ask for inputs from the group with regards to integrating HCM's Run-Retrieve Extract Flow with Oracle Integration Cloud. I have attached the sample OIC flow (initial design) we've come up with. Here are the requirements:

    1) Integrating HCM Core HR Data through Extract with SAP Payroll

    2) Sending data every 10minutes (OIC's limit for scheduled integration) from HCM to SAP for data synchronization.

    3) Extract Data sent are 'Changes Only' data, we are only sending changes in HCM to SAP within the 10-minute period (not master data).

     

    The attached initial design works fine for above requirements, as far as we've tested it (unfortunately we only have few test data available as of this writing). But there are still concerns though and I'd appreciate any inputs from the group to enhance the design:

    1) What if we process a full, master data extract run and takes longer time than the current delta-only run? (Will it raise timeout issue on OIC side? What's the runtime limit on OIC for every integration run?)

    2) Anyone have tried the callback option for SOAP WS? How does it work for Extract RunRetrieve Process?

     

    We want to consider a design that can handle both master and delta-only extract data in OIC. Appreciate all your inputs.

     

    Thanks ahead,

    Moon

    Image: