Integration

Get Involved. Join the Conversation.

Topic

    Overaj K
    Not able to connect EBS adapter in ICS facing grant issueAnswered
    Topic posted July 23, 2019 by Overaj KRed Ribbon: 250+ Points, tagged Adapters, API, Connection, E-Business Suite, Events, Integration, PaaS, REST, Web Services 
    66 Views, 7 Comments
    Title:
    Not able to connect EBS adapter in ICS facing grant issue
    Summary:
    Not able to connect EBS adapter in ICS facing grant issue
    Content:

    Experts,

    When i try to connect the EBS adapter from ICS i am facing the below error,

    • CASDK-0005 : User is not authorized to execute the service. Please check the user grants.

     I configured all the things as per the oracle doc.  

    Recently i found out that i missed the OIC username registration in ebs fnd_usr .but this is for trigger event only.For me invoke is also not working in connection creation page.

    Also i provided all the roles and i configured grants for the corresponding EBS user in Metadata provider/Integration Repository service and Event Manager APIs.

    Please note i used EBS REST service not SOAP.

    Kindly share your thoughts.

     

    Regards,

    Ove

     

    Version:
    19.3.1.0.0 (190624.1100.29532)
    Image:

    Best Comment

    Ankur Jain

    Ok, what about the POSTMAN results.

    Regards,

    Ankur

    Comment

     

    • Ankur Jain

      Hi Ove,

      Can you try to execute the Service from POSTMAN tool first and see if this is working? In meanwhile can you share the screenshot of the EBS Adapter configuration.

      Regards,

      Ankur

    • Overaj K

      Hi Ankur,

       

      Sorry for the delay.

       

      Please find the request and response for the create user in FND_USER_PKG API.

       

      Request:,

      {
        "Create_User": {
          "@xmlns": "http://xmlns.oracle.com/apps/fnd/rest/create_user/load_row",
          "RESTHeader": {
            "xmlns": "http://xmlns.oracle.com/apps/fnd/rest/Create_User/header",
            "Responsibility": "APPLICATION_DEVELOPER",
            "RespApplication": "FND",
            "SecurityGroup": "STANDARD",
            "NLSLanguage": "AMERICAN",
            "Org_Id": "201"
          },
          "InputParameters": {
            "X_USER_NAME": "TEST_USER",
            "X_ENCRYPTED_USER_PASSWORD": "Welcome123",
            "X_START_DATE": "14/09/2015",
            "X_EMAIL_ADDRESS": "test_user@test.com"
          }
        }
      }

       

      Response.,

      {

      "ISGServiceFault": {
      "Code": "ISG_SERVICE_AUTH_FAILURE"
      "Message": "User is not authorized to execute the service"
      "Resolution": "Please check whether the user has the requisite grants."
      "ServiceDetails": {
      "ServiceName": "Create_User"
      "OperationName": "load_row"
      "InstanceId": "0"
      }
       
      }
       

      }

       

      I think still i am facing the same issue in direct access REST API also right. Can you please check the above one is right? Anything wrong?

       

      Regards,

      Ove

      • Overaj K

        HI, Actually the issue is solved once i cleared the cache in Functional Administrator.

         

        Regards,

        Ove