We need to use below SOAP Webservice to apply Hold on Sales Order in Oracle Fusion: WSDL URL: Operations: RequestHold Sample Payload: <?xml version=”1.0″ encoding=”UTF-8″?> <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:dood=”http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/DooDecompOrderDetailSvcComposite”> <soapenv:Header /> <soapenv:Body> <dood:RequestHoldProcessRequest> <dood:ApplyHoldRequestParams> <dood:SourceOrderSystem>OPS</dood:SourceOrderSystem> <dood:SourceHoldCode>XX_TEST_HOLD</dood:SourceHoldCode> <dood:HoldComments>XX Test Hold Comment</dood:HoldComments> <dood:SourceOrderNumber>XX_TEST_SALES_ORDER_01</dood:SourceOrderNumber> <dood:HoldName>XX Test Hold</dood:HoldName> <dood:AppliedBy>Test_user</dood:AppliedBy> </dood:ApplyHoldRequestParams> </dood:RequestHoldProcessRequest> </soapenv:Body></soapenv:Envelope> 2. Releasing Hold on Sales Order WSDL URL: […]
How to bulk import Lookup Types and Lookup Codes in Oracle Fusion
In this article, we will try to create custom lookup type and lookup values using bulk import functionality in Oracle fusion. We can create Lookup Type and respective lookup values by creating two separate files. Files should have pipe (|) as delimiter and should be of UTF-8 encoding. Part-1: – Create Lookup Type For creating […]
Using Object Triggers for Business Objects in VBCS
In this section, we will see how to use object triggers for business objects in VBCS with examples. Like we have Database triggers on database tables, we have object triggers on business objects in VBCS. Object triggers is a script which is executed in response to a specific business object event. Let us consider example- […]
How to Create Simple Search Page using REST API in VBCS
In this section, we will create Simple search page to display payment terms from fusion. Step1: Create Backend and Service Connection with Fusion. Navigate to VBCS—> Backend. As we need to call fusion REST API, select “Oracle Cloud Applications Instance”. Provide fusion instance details with URL and authentication details. Click on Create. Backend is created […]
How to Change Primary Key Column for Business Object in VBCS
When a business object is created in VBCS, it creates an ID by default as the primary key. But if we want to change the primary key to any other column which contains unique values, we can do that by following the steps below. Let us create a new Business Object in VBCS with the […]
Sorting Data in VBCS Tables
In this section, we will see how to sort Table data in VBCS. Let us consider the EmpBOData Business Object. Let us create sample VBCS page with table based on above business object. Run the application. We want to sort this table data based on some specified column name. When we use a business object, […]
How to Create Custom Events in VBCS
In the last section, we have seen events and types of events in VBCS. Also, we have seen how to invoke events in VBCS. In this section, we will see how to create custom events in VBCS. What are custom events? Custom events are like lifecycle events, but they are not limited to lifecycles. Custom […]
How to Create Business Objects using Data Manager in VBCS
In this section, we will see how to create business objects in VBCS using a data manager. Data Manager is used to manage data stored in business objects while developing VBCS applications. Let us create an excel sheet with Location data as shown below: Save this file as Location.xlsx. Now navigate to VBCS —>Business Objects—->Data […]
How to Populate List of Values with Fusion Data in VBCS
In this section, we will see how to populate a field’s list of values (LOV) with fusion data in VBCS. We will populate payable payment Terms from fusion as List of value for Payment Term field in VBCS page. Follow below steps to achieve this: Step1: Test REST API for Payment Term in Postman. For […]
Understanding Backend and Service Connection in VBCS
Backend in VBCS: A backend is representation of known resources like Integration cloud, that visual builders understand. A backend contains a list of “servers” to help connect to this backend. Each server can be thought to encapsulate the details needed to connect to this type of resource like authentication, URL, etc. Backend is basically the […]