Posts

Posts

  • logu Prasanth
    How to create a post REST service in OIC25
    Topic posted March 27, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Case Management, Cloud, Connection, Database, E-Business Suite, Events, Integration, Mapping, Orchestration, PaaS, Process, REST, SOAP, Web Services, xml in Integration > Integration public
    Title:
    How to create a post REST service in OIC
    Summary:
    We have a requirement to create a REST service in OIC. And this service will be exposed to the client to POST their JSON data.
    Content:

    We have a requirement to create a REST service in OIC. And this service will be exposed to the client to POST their JSON data.

    Can you please provide any artifact /whitepaper/ procedure for creating simple REST service in OIC.

     

     

     

     

     

  • 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:
  • 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:
  • 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:
  • Ram Venkataraman
    OIC File Adapter - FileRead via Connectivity Agent3
    Topic posted November 15, 2018 by Ram VenkataramanRed Ribbon: 250+ Points, tagged Adapters, Agent in Integration > Integration public
    Title:
    OIC File Adapter - FileRead via Connectivity Agent
    Summary:
    FileRead via Connectivity Agent
    Content:

    Hello Everyone,

    I had a query about using the OIC File Adapter for FileRead from On-Premise servers. My understanding is that FileRead supports reading files from an accessible file system on the server where the OIC Connectivity Agent is installed. Is this correct? Do we have to install connectivity agents on all servers from where we want read files using File Adapter? Appreciate your insights on this.

    Thanks,

    Ram

    Version:
    OIC 18.4.1.0.0
  • Surya Satyanarayana
    OIC connectivity agent JMS issue4
    Topic posted October 26, 2018 by Surya Satyanarayana, tagged Adapters, Agent, Cloud, Connection, Integration in Integration > Integration public
    Title:
    OIC connectivity agent JMS issue
    Summary:
    JMS connectivity issue for manage server port
    Content:

    We are trying to connect to manage server port for weblogic server but are getting the below issue.

    Test connection failed. Please ensure you are providing correct Weblogic JMS Admin host and port. Error Details : While trying to lookup 'weblogic.management.mbeanservers.domainruntime' didn't find subcontext 'management'. Resolved 'weblogic'

    The same connection for admin port is working fine. We tried to place few libraries and restarted the agent but have got a different error now.

    • java.lang.NoClassDefFoundError: Could not initialize class weblogic.security.SubjectUtils

    Any idea what all libraries need to be added for the weblogic JMS connection to work for manage server port.

    Thank you.

    Surya

    Version:
    OIC Version: 18.3.5.0.0
  • John Graves
    OIC 18.3.5 - JMS Adapter 18.1.5 - Consumer - Managed Server...2
    Topic posted October 17, 2018 by John GravesSilver Trophy: 7,500+ Points, tagged Adapters, Agent, Integration in Integration > Integration public
    Title:
    OIC 18.3.5 - JMS Adapter 18.1.5 - Consumer - Managed Server issue
    Summary:
    Having issues using the JMS adapter (via connectivity agent) to connect to queues on managed servers.
    Content:

    Having issues using the JMS adapter (via connectivity agent) to connect to queues on managed servers.

    It works fine when connecting to queues on admin server.

    When connecting to queue on Admin server, I get a 'good' message in the agent log
    ----------------------------

    [2018-10-18T01:21:43.912Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** ICS jmsCmd: getJMSDestinationTargetUrl 
    [2018-10-18T01:21:43.913Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection params - 100.65.4.46 **** 7001 **** weblogic 
    [2018-10-18T01:21:44.077Z] [INFO] [ThreadID: 63] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection Url - t3://100.65.4.46:9071; 
    

    ----------------------------

    When I try to connect to a queue on a managed server I get a 'bad' or empty message in the log

    ----------------------------

    [2018-10-18T01:24:16.134Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** ICS jmsCmd: getJMSDestinationTargetUrl 
    [2018-10-18T01:24:16.135Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection params - 100.65.4.46 **** 7001 **** weblogic 
    [2018-10-18T01:24:17.156Z] [INFO] [ThreadID: 92] [Logger: oracle.soa.adapter.cloud.jms] [SRC Class: oracle.cloud.adapter.api.util.DefaultLoggerService; Method: logInfo] *** Connection Url -  
    

    ----------------------------

    -John

    Version:
    18.3.5