Posts

  • Mohana Gopal Selvam
    SCM - WorkOrder API5.0
    Topic posted Yesterday by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Integration in Integration > Integration public
    Title:
    SCM - WorkOrder API
    Content:

    Hi,

    I have tried to test the SCM - Workorder creation API in Postman as per the Oracle document

    https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/19d/fasrp/op-fscmrestapi-resources-11.13.18.05-maintenanceworkorders-x-operations-0.html

    Get operation is working. But post operation is not working. It returns as 400 Bad Request error. Any Idea?

    Request:


     "WorkOrderNumber": "BA_WO_8",
     "WorkOrderTypeCode": "CORRECTIVE",
     "WorkOrderSubTypeCode": "ORA_CONDITION_BASED",
     "AssetNumber": "VA MTR TST1",
     "OrganizationCode": "M1"
    }

    Response: Unexpected 'T'


     "WorkOrderNumber": "BA_WO_8"
    }

    Response: Unexpected 'Y'

    Thanks,

    Mohan

    Version:
    19C
  • Mohana Gopal Selvam
    Routing / Dispatch not visible1100%
    Topic posted October 13, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Configuration, Dispatch Functionally, Routing / Optimization in Field Service Forum > Field Service public
    Title:
    Routing / Dispatch not visible
    Content:

    Hi,

    I have setup the Visibility in User Types screen for Routing since by default is not there. Still it is not visible and I am using admin user. Do we need to setup anything other than visibility to view the Routing? Dispatch also not visible. 

    Thanks,

    Mohan

    Version:
    19C Enterprise Edition
  • Mohana Gopal Selvam
    Maps Geocoding Issue
    Topic posted October 13, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Configuration in Field Service Forum > Field Service public
    Title:
    Maps Geocoding Issue
    Content:

    Hi,

    I have tried to change the Available Countries to UAE from US under Maps and Geocoding in Business Rules. When I tried to save, I got the below error and the country automatically changed to US. Do we need to setup anything?

    Value of the field "Default country for geocoding" must be one from the list of "Available countries"

    Our customer has Maps and Geocoding Provider: Oracle

  • Mohana Gopal Selvam
    Need constant update on the 'New Feature' topicAnswered45.0
    Topic posted October 9, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged CX Cloud Training in Oracle LaunchPad public
    Title:
    Need constant update on the 'New Feature' topic
    Content:

    Hi Team,

    There is no update on the Service Cloud New features topic. Please update the new features topic periodically. 

    Thanks,

    Mohan

    Image:
  • 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
    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
    Handling Null value in the mappingAnswered115.0
    Topic posted 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
    TRANSLATION-ERROR-01Answered25.0
    Topic posted 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:
  • Mohana Gopal Selvam
    Lookup not visibleAnswered35.0
    Topic posted September 25, 2019 by Mohana Gopal SelvamSilver Crown: 22,500+ Points, tagged Integration, Orchestration in Integration > Integration public
    Title:
    Lookup not visible
    Content:

    Hi,

    I have created lookup, but it is not visible in the mapping. Now I am manually entered the values in the mapping which is working. Do we need to enable anything to view the lookup in the mapping?

    Thanks,

    Mohan

    Image: