Posts

  • Mohana Gopal Selvam
    Activation Failed - No Error Code12
    Topic posted September 10, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged Orchestration in Integration > Integration public
    Title:
    Activation Failed - No Error Code
    Content:

    Hi,

    I have tried to activate my integration, it says activation in progress. But in my integration it shows error with following message

    Deployment of artifact type osb, [/osb/AD_GET_STATUS_01.00.0000/oracleinternalicsAD_GET_STATUS_01.jar] failed. .

    What would be the root cause?

    Integration Type: Basic Routing

    Connector: Rest & Soap(Target)

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Integration ApporachAnswered85.0
    Topic posted July 31, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged Database, REST in Integration > Integration public
    Title:
    Integration Apporach
    Content:

    Hi,

    Our customer have DB Cloud, OIC (Oracle Integration Cloud), JCS (Java Cloud Service) and Fusion Cloud (SaaS). We have tried to integrate the third party system from our CRM fusion application. We have built some pages using DCS - VBCS (Digital Customer Service - Visual Builder Cloud Service), based on some event in the screen the data from DB cloud needs to push to third party system. (Data resides in multiple tables. We have to build some complex joins) 

    We have identified two approach.

    1. Create custom java program in JCS, it will fetch the data from DBCS and form the request which is requested by third party system and call the third party API. This custom program deployed as Rest API. We will invoke this API from our VBCS screen.

    2. Create API using ORDS (DBCS). Create connections of ORDS API & third party API. Create one integration to integrate ORDS API & third part API in OIC. We will invoke OIC API from our VBCS screen.

    Let me know which one is best approach. 

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Default Country & Phone CodeAnswered65.0
    Topic posted March 14, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged Configuration in Sales > Sales public
    Title:
    Default Country & Phone Code
    Content:

    Hi,

    Is there a way to set the default value while creating the Contact / Account record in Site level & User level?

    Address - Country field and Country Code in Work Phone & Mobile Phone.

    Thanks,

    Mohan

    Version:
    18C
  • Mohana Gopal Selvam
    Identify current version of OICAnswered10
    Topic posted August 5, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points in Integration > Integration public
    Title:
    Identify current version of OIC
    Content:

    Hi,

    Where we can see the current version of our OIC application in the UI?

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    DBCS - Best Approach
    Topic posted September 9, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged DBCS, REST API in Data Management > Database public
    Title:
    DBCS - Best Approach
    Content:

    Hi Team,

    We have developed custom applications using VBCS where our data are stored in DBCS. We have enabled ORDS for our DBCS. 

    Per day around 3000 customer is going to access this VBCS application where it will invoke the DBCS Rest API in backend. We are going to perform the CRUD operation on the Account, Contact & SR DBCS tables. 

    Is it best approach? or can we end up in table lock?

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    AutoRest with OAuth - Best Approach5.0
    Topic posted September 9, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged Apex, DBCS, REST API in Data Management > Database public
    Title:
    AutoRest with OAuth - Best Approach
    Content:

    Hi,

    We have DBCS enabled with ORDS. Currently we are developing Rest API using APEX UI (Creating Module, Handler). We found the below link for easily enable the Auto Rest for the tables.

    https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/ords/r30/AutoREST%20Enable/AutoREST%20Enable.html

    Is it best approach? Can we enable OAuth for the AutoRest? Please provide the documents

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Reusable Page / Template25.0
    Topic posted August 30, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged UI in Application Development > Visual Builder public
    Title:
    Reusable Page / Template
    Content:

    Hi Guru,

    As per our client requirement, we have to develop around 150 Apps which contain 4 pages. All the apps look and feel are same. We have developed breadscrumbs kind of pages.

    First Page - Contain Data Entry form (Different fields)

    Second Page - Document Upload page (Vary based on the Apps)

    Third Page - Common data capturing fields across all the Apps

    Fourth Page - Integration Page. Common fields across all the apps

    We are foreseeing one issue: If customer wants to change something in 3 & 4 th page which common for all the apps, we have to modify all the 150 pages. 

    Is there any way to define the page commonly / template, we just pass the arguments to show the page accordingly and without affecting the breadscrumb navigation and CX.

    Thanks,

    Mohan

     

  • Mohana Gopal Selvam
    Internal server errorAnswered255.0
    Topic last edited August 25, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged API, Orchestration in Integration > Integration public
    Title:
    Internal server error
    Content:

    Hi,

    I have tried to build the integration of third party using OIC. I have done the mapping successfully. When I tried to execute the OIC API, I got the below error.

    {
      "type" : "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1",
      "title" : "Internal Server Error",
      "detail" : "Internal server error. Please contact oracle support for details.",
      "o:errorCode" : "500",
      "o:errorDetails" : [ {
        "type" : "UnMappedFault:UpdateLicenses",
        "instance" : "NA",
        "title" : "javax.xml.ws.WebServiceException: Error while dispatching SOAP message to the endpoint http://xx.xx.x.x/Service.svc:javax.xml.soap.SOAPException: javax.xml.soap.SOAPException: Not a valid SOAP Content-Type: text/html; charset=UTF-8\n===== reqeust ========\nContent-Type:text/xml; charset=UTF-8\nContent-Length:1926\nSOAPAction:\"http://xx.xx.xx/UpdateLicenses\"\n<env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\"><env:Header/><env:Body><tns:AccountList xmlns:wsa=\"http://schemas.xmlsoap.org/ws/2004/08/addressing\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:wsdl=\"http://schemas.xmlsoap.org/wsdl/\" xmlns:wsp=\"http://schemas.xmlsoap.org/ws/2004/09/policy\" xmlns:xml=\"http://www.w3.org/XML/1998/namespace\" xmlns:wsu=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\" xmlns:nsmpr0=\"http://xmlns.oracle.com/cloud/adapter/REST/ORDS_DSC_REQUEST/types\" xmlns:wsx=\"http://schemas.xmlsoap.org/ws/2004/09/mex\" xmlns:wsaw=\"http://www.w3.org/2006/05/addressing/wsdl\" xmlns:wsa10=\"http://www.w3.org/2005/08/addressing\" xmlns:soap12=\"http://schemas.xmlsoap.org/wsdl/soap12/\" xmlns:tns=\"http://xx.xx.xx.xx/V01\" xmlns:msc=\"http://schemas.microsoft.com/ws/2005/12/wsdl/contract\" xmlns:wsap=\"http://schemas.xmlsoap.org/ws/2004/08/addressing/policy\" xmlns:nstrgmpr=\"http://xmlns.oracle.com/types/DPW_DSC/OutboundSOAPRequestDocument\":Application Error",
        "o:errorPath" : "NA",
        "o:errorCode" : "NA"
      } ]
    }
    

    When I check the payload, body is formed correctly. Any Idea?

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Network ErrorAnswered85.0
    Topic posted August 18, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged REST in Application Development > Visual Builder public
    Title:
    Network Error
    Content:

    Hi,

    I have tried to create one Service Connection (Rest API - without credentials) in Digital Customer Service (DCS). I have configured the connection and set the static url parameters. But when I tried to test my connection I got the network error.  

    API URL: https://xx.xx.xx.xx/apps/PortalBalance?cust_account_id=14984

    {
        "type": "HTTP://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1",
        "title": "Network Error",
        "detail": "Please check the JavaScript console to see more details."
    }

    Can we not create the API which has 'No authentication'? Anyone facing this kind of issue before?

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Network ErrorAnswered35.0
    Topic posted August 18, 2019 by Mohana Gopal SelvamBronze Crown: 15,000+ Points, tagged Configuration in B2B Service > Digital Customer Service public
    Title:
    Network Error
    Content:

    Hi,

    I have tried to create one Service Connection (Rest API - without credentials) in DCS. I have configured the connection and set the static url parameters. But when I tried to test my connection I got the network error.  

    API URL: https://xx.xx.xx.xx/apps/PortalBalance?cust_account_id=14984

    {
        "type": "HTTP://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1",
        "title": "Network Error",
        "detail": "Please check the JavaScript console to see more details."
    }

    Can we not create the API which has 'No authentication'? Anyone facing this kind of issue before?

    Thanks,

    Mohan