How to Connect ATP Database with VBCS using Tenant Setting and Database Wallet In this post, we will see how to connect ATP database with VBCS using Tenant setting and database wallet. Step1: Provision ATP Database in OCI. Login to OCI Console and click on navigator. Navigate to Oracle AI Database —>Autonomous AI Database Select […]
How to Navigate to Page Flow from Fragments
In this post, we will see how to navigate to Flow (Page) from Fragments. When we create fragments and want to navigate to flow, there is no action available for navigation. We need to follow the steps below to navigate to Page/Flow from fragments. Step1: Create Sample VBCS Application. Navigate to Web Application. Click on […]
ORDS Part-4: How to create Restful ORDS API for ATP database
ORDS Part-4: How to create Restful ORDS API for ATP database. In earlier posts, we have seen how to provision ATP database in OCI and how to connect ATP database from SQL developer using Wallet key. In this post, we will see how to enable ORDS for ATP database. ORDS stands for Oracle Rest Data […]
ORDS Part-5-How to Enable OAUTH2.0 for ORDS REST API
In this blog post, we will see how to enable OAUTH2.0 for ORDS REST API. Login with ORDS_TEST_USER. Navigate to Development —>REST. Click on Open. Step1: Create Role for OAUTH2.0 Navigate to Security —>Roles. Click on Create Role. Provide Role Name and Click on Create. Step2: Create Privileges Navigate to Security —> Privileges Click on […]
How to Call OIC Integration from VBCS
How to Call OIC Integration from VBCS In this post, we will see how to call OIC integration from VBCS. Note: We are considering OIC and VBCS available on same OCI tenancy and domain. Let us consider below Sample OIC Integration (App Driven). The integration is having Name as input Payload, and it is giving […]
How to Integrate OPA (Oracle Process Automation) with Oracle VBCS
How to Integrate OPA (Oracle Process Automation) with Oracle VBCS In this section, we will see how to Integrate process defined in OPA with Oracle VBCS. Note: VBCS and OPA should have same identity domain to work on the steps below. Let us consider below sample Oracle Process Automation structured process created: Navigate to Processes. […]
How to Download PO PDF attachement using REST API
How to download PO-PDF Attachment for Purchase Order using REST API. In this section, we will see how to get PO-PDF attachment for Purchase order using REST API. Let us consider below PO with PO Number as 100099. Click on View PDF button to download PO PDF file. Now to get this PDF document using […]
How to Call BIP Report Output in chunks using SOAP WSDL
Whenever we want to fetch huge amounts of data from BIP report (More than 10MB) in OIC, we usually get payload limitations error. To avoid this error, we have below two options: (A) Schedule BIP report and send File to FTP server and then read data from FTP in segment in OIC. (B) Retrieve BIP […]
Service Limits for File Adapter in OIC
The File Adapter lets you read from or write to files on an on-premises system (e.g., local file server or shared folder) via a Connectivity Agent. There are two main operations: Each has different size limits, depending on whether a schema/structure is used. For Read File operations: Polling with a connectivity agent: Download File operations:
BIP Roles in Oracle Fusion
Oracle Business intelligence roles apply to both Oracle Business Intelligence publisher and Oracle Fusion Transactional Business Intelligence (OTBI). They grant access to business intelligence functionality such as ability to run or authors reports. Role Name Description BI Consumer Role Runs Business Intelligence reports. BI Author Role Creates and edits reports. BI Administrator Role Performs administrative […]