Have any question?
+2 0100 62 62 837
[email protected]
Register Login

Login with your site account

Lost your password?

Not a member yet? Register now

AppsLead | Learn Oracle From The LeadersAppsLead | Learn Oracle From The Leaders
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us

Oracle ebusiness Suite

  • Home
  • Oracle ebusiness Suite
  • How to call REST Web service from Oracle Scale System

How to call REST Web service from Oracle Scale System

  • Posted by abdelkareem mousa
  • Categories Oracle ebusiness Suite, Oracle SCM
  • Date April 11, 2017
  • Comments 0 comment
Welcome to Appslead, Today we will just call web service to delete DO from Order management super user Responsibility and we will make personalization to show error message if the result of the web service is false. If it is true it will not do anything and the process will pass normally. This web service will get IN PARAMETER P_LINE_ID. Step 1 Please make package which will contain your code:
--Specification:- 

CREATE OR REPLACE PACKAGE APPS.XX_DO_WEBSERVICE
 AS
 FUNCTION XX_DO_WB(P_LINE_ID NUMBER) return VARCHAR2;
 END XX_DO_WEBSERVICE;
 
 
 --Body:- 
CREATE OR REPLACE PACKAGE BODY APPS.XX_DO_WEBSERVICE
 AS

FUNCTION XX_DO_WB(P_LINE_ID NUMBER)
 RETURN VARCHAR2
 IS
 req UTL_HTTP.REQ;

resp UTL_HTTP.RESP;

weatherstring VARCHAR2(32767);

weatherxml XMLTYPE;

tempxml xmltype;

temp varchar2(32767);

extractstring varchar2(2000) := '//temperature/@value';

Do_number varchar2(250) := P_LINE_ID;

begin


 req := UTL_HTTP.BEGIN_REQUEST('http://<SERVER IP : PORT>/ebs-portal/rest/LongShippingScale/DeleteDOFromScale?parametersMap='

|| Do_number); --you will get this link from your DBA Adminstrator to complete your task.

resp := UTL_HTTP.GET_RESPONSE(req);

UTL_HTTP.READ_LINE(resp, weatherstring, TRUE);

UTL_HTTP.END_RESPONSE(resp);

dbms_output.put_line( upper(weatherstring));

RETURN(upper(weatherstring));

END XX_DO_WB;


 END XX_DO_WEBSERVICE;

Step 2 Condition:- Action:- Step 3 Please go to Order Management Super User > Sales Order Now you can see How to test your Web Service using the personalization. Click OK then write reason and you will see your error message if the Web service result come back with false.   Best regards… Abdelkareem Mousa  
  • Share:
Admin bar avatar
abdelkareem mousa

Previous post

How To Set a Default Sequence For Invoice Number in Oracle Payables application
April 11, 2017

You may also like

  • How To Set a Default Sequence For Invoice Number in Oracle Payables application
    8 April, 2017
  • How to use user hook on oracle applications (EBS)
    7 April, 2017
  • HRMS Employee Migration In Oracle Applications
    19 March, 2011

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Categories

  • Blog
  • Oracle ebusiness Suite
  • Oracle Financial
  • Oracle HCM
  • Oracle SCM

Latest Courses

R12.x Oracle E-Business Suite Essentials for Implementers

R12.x Oracle E-Business Suite Essentials for Implementers

Free
R12.x Oracle HRMS Work Structures Fundamentals

R12.x Oracle HRMS Work Structures Fundamentals

Free
R12.x Oracle Payroll Fundamentals

R12.x Oracle Payroll Fundamentals

Free
AppsLead | Learn Oracle From The Leaders

+2 0100 62 62 837

[email protected]

Company

  • About Us
  • Blog
  • Contact Us

Links

  • Events

Copyright © 2017 AppsLead, All rights reserved. Developed by ECDSCS Co.

  • Privacy
  • Terms
  • Sitemap