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 […]
Create BIP report with Dependent Parameters
In this section, we will see how to create BIP report with dependent parameters in fusion. Let us create sample BIP report with two parameters: Navigation—-> Tools—>Reports and Analytics Go to Browse Catalog—>New —–>Data Model. Create SQL Query to create Data Model. Go to Diagram—->SQL Query. Give Name, Data Source and Type of SQL as […]