Posts

  • Mohana Gopal Selvam
    AutoRest with OAuth - Best Approach15.0
    Topic posted September 9, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ 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
    ICS Instance CreationAnswered4
    Topic posted February 12, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged PaaS in Integration > Integration public
    Title:
    ICS Instance Creation
    Content:

    Hi,

    Our customer purchased ICS (ICS for SaaS edition). Where we see, how many ICS instances we can create for the subscription? Can we create one for Test and one for Prod? 

    If we know the details, then it will help us to provide the proper name for our instance.

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Fusion Integration (CRM & Finance)75.0
    Topic posted February 26, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Core SFA, Groovy, Integration in Sales > Sales public
    Title:
    Fusion Integration (CRM & Finance)
    Content:

    Hi,

    We have GSI environment where our customer have the license of OEC, SCM and Finance (All are in same accessible through same URL) and we have ICS.

    We have to integrate Customer (Account & Contact) and Finance data where it is in Custom object in CRM module. What is the best approach for integrating OEC & Finance module? 

    I heard from my colleague, we have to execute the Generate Id and Address sync webservice for the Account record which is created in CRM, in order to capture the finance detail in Finance module. 

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    DBCS - Best Approach1
    Topic posted September 9, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ 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
    OIC - VBCS API Best approach25.0
    Topic posted September 29, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points in Integration > Integration public
    Title:
    OIC - VBCS API Best approach
    Content:

    Hi,

    We have developed some APIs in ICS which we need to consume in VBCS (Visual Builder). What is the best approach to use the ICS api in VBCS?

    Currently we have created service connection using ICS API and using it.

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    PaaSAnswered25.0
    Topic posted October 2, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points in Oracle LaunchPad public
    Title:
    PaaS
    Content:

    When will we get the launch pad training for PaaS products (ICS, VBCS)

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Subtraction functionAnswered125.0
    Topic posted September 29, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Mapping in Integration > Integration public
    Title:
    Subtraction function
    Content:

    Hi,

    Requirement: I want to subtract two value from various response and show in the final response.

    Problem: One value coming as string, so I tried to convert as Decimal point. Since I could not use Number (Conversion) function in Subtract, I have used assigned operation and convert as Decimal point. But I got the below error. I noticed, assigned function output also String. 

    Response 1

    {
      "avlDeposit" : "978409.25"}

    Response 2

    {
      "holdingAmt" : 409.25
    }

    How to achieve this?

    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:execute",
        "instance" : "<![CDATA[Please inspect the logs for more details. Initiating Request: <request_payload/>\n]]>",
        "title" : "faultName: {{http://schemas.oracle.com/bpel/extension}subLanguageExecutionFault}\nmessageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}\nparts: {{\nsummary=<summary>XPath expression failed to execute.\nAn error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc('resources/processor_116/resourcegroup_119/req_388e98f6529b4d6297c27267df9e6b41.xsl', $messagecontext_15.parameters, 'ORDS_HoldingAmount', $messagecontext_84.parameters, 'holdingAmount_assignment_1', $messagecontext_141, 'FreeCom_PB_Check', $messagecontext_129.parameters, 'avl_deposit_assignment_1', $messagecontext_155)\nThe XPath expression failed to execute; the reason was: javax.xml.transform.TransformerException: oramds:/deployed-composites/oracleinternalics/PORTAL_BALANCE_DELETE_rev01.00.0000/resources/processor_116/resourcegroup_119/req_388e98f6529b4d6297c27267df9e6b41.xsl&lt;Line 55, Column 186>: XML-23002: (Error) internal xpath error\nCheck the detailed root cause described in the exception message text and verify that the XPath query is correct.\n</summary>\n,code=<code>XPathExecutionError</code>}\ncause: {javax.xml.transform.TransformerException: oramds:/deployed-composites/oracleinternalics/PORTAL_BALANCE_DELETE_rev01.00.0000/resources/processor_116/resourcegroup_119/req_388e98f6529b4d6297c27267df9e6b41.xsl<Line 55, Column 186>: XML-23002: (Error) internal xpath error}\n",
        "o:errorPath" : "NA",
        "o:errorCode" : "NA"
      } ]
    }
    

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Handling Null value in the mappingAnswered115.0
    Topic last edited September 27, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Mapping in Integration > Integration public
    Title:
    Handling Null value in the mapping
    Content:

    Hi,

    In my integration, I got the Null value as response in one of my source as shown below. I used this field in my mapper to map to target.

    {
        "x_total_deposit": 1000,
        "x_avail_deposit": null,
        "x_return_status": "S"
    }
    

    I got the Translation error when I invoke the OIC API, since null value is mapped to end response field. 

    {
      "type" : "10.5.3",
      "title" : "exception occurred while translating the response into the accepted media type.",
      "detail" : "oracle.cloud.connector.api.CloudInvocationException: ORABPEL-15236\n\n",
      "o:errorCode" : "TRANSLATION-ERROR-01",
      "o:errorDetails" : [ {
        "type" : "NA",
        "instance" : "NA",
        "title" : "NA",
        "o:errorPath" : "NA",
        "o:errorCode" : "NA"
      } ]
    }
    

    How to handle the null value in the mapping in OIC?

    Thanks,

    Mohan

  • Mohana Gopal Selvam
    Escalation Process55.0
    Topic posted March 25, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Configuration in Sales > Sales public
    Title:
    Escalation Process
    Content:

    Hi,

    We have to implement the Escalation process in Activity object. Send an escalation mail based on the Activity Due Date. I hope we can achieve this through Schedule Report.

    1.Is there any other best approach?

    Additional Requirements:

    2. We need to send an escalation mail to the resource which we have captured in Activity object's custom field based on Resource object?

    3. Can we use the email template for the escalation?

    4. We have to capture the reminder frequency - week/month/day in Activity object. We have to send a reminder mail after the first reminder date which we captured. Is it possible?

    Thanks,

    Mohan

     

     

    Version:
    18C
  • Mohana Gopal Selvam
    TRANSLATION-ERROR-01Answered25.0
    Topic last edited September 25, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Orchestration, REST in Integration > Integration public
    Title:
    TRANSLATION-ERROR-01
    Content:

    Hi,

    I have requirement like, I have to invoke two services and the outcome of the services need to combine and send as one response.

    For Ex: Service 1 returns A & B. Service 2 returns X & Y. Expected result is A, B, X & Y

    For that I have done

    1. Define Trigger API and defined the combined response

    2. Invoke Service 1 (Rest)

    3. Invoke Service 2 (Rest)

    4. Map the response of Service 1 & Service 2 in single mapping.

    Now I got the below error:

    {
      "type" : "10.5.3",
      "title" : "exception occurred while translating the response into the accepted media type.",
      "detail" : "oracle.cloud.connector.api.CloudInvocationException: ORABPEL-15236\n\n",
      "o:errorCode" : "TRANSLATION-ERROR-01",
      "o:errorDetails" : [ {
        "type" : "NA",
        "instance" : "NA",
        "title" : "NA",
        "o:errorPath" : "NA",
        "o:errorCode" : "NA"
      } ]
    }
    

     

    1. The above approach is correct?

    2. If the approach is correct, then how to fix the issue?

    Thanks,

    Mohan

     

    Image: