Oracle Fusion Security Console: The Oracle Fusion Applications Security Console is an easy-to-use administrative work area where you perform most security-management tasks. This topic introduces the Security Console and describes how to access it Navigation to access Security Console is as below: Tools—> Security Console Click on Security Console Security Console consists of different […]
How to get UCM ID from document ID using Generic SOAP WSDL
We can get Document ID once we upload the files to UCM using Erpintegrations REST API as shown below: We can get UCM id from this document ID using generic SOAP WSDL with the details below: WSDL: Method: GenericSoapOperation Request: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ucm=”http://www.oracle.com/UCM”> <soapenv:Header/> <soapenv:Body> <ucm:GenericRequest webKey=”cs”> <ucm:Service IdcService=”GET_FILE”> <ucm:Document> <ucm:Field name=”dID”>2700074</ucm:Field> </ucm:Document> </ucm:Service> </ucm:GenericRequest> […]
Uploading File to UCM using ErpIntegrations REST API
Uploading File to UCM using ErpIntegrations REST API We can use the REST API for uploading files to UCM as below: REST API Endpoint: Method: POST Content-Type: application/json Payload: { “OperationName”:”uploadFileToUCM”, “DocumentContent”:”VGhpcyBpcyB0ZXN0IEZpbGUgZm9yIFVDTQ==”, “DocumentAccount”:”fin$/payables$/import$”, “ContentType”:”txt”, “FileName”:”TEST UCM Uplaod File.txt” } The payload details are as follows: OperationName This should be constant […]
How to resolve-Unable to See Data Set Access and Ledger Name for Import Journal Program
Issue Description: While submitting Import Journal program, we face issue that we are not able to see Data access set and Ledger Name in parameter Lov as shown below: Solution: This issue is related to roles and data access required to run the Import Journal Program. Below roles and respective data access need to provide […]
SOAP Webservice To Apply/Release Hold On Sales Order in Oracle Fusion
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, […]