In this post, we will see how to create custom authentication scheme in Oracle APEX. Custom authentication enables users to log in to APEX application with username and password stored in custom database table. This will provide complete control over the authentication interface. APEX application will validate username and password against data stored in database […]
Authentication Schemes in Oracle APEX
Oracle APEX application can be authenticated using an authentication scheme. The authentication process requires that a user provides some type of credentials such as username and password. Once credentials are verified, application access is given to users. Once a user has been identified, the Oracle APEX engine keeps track of each user by setting the […]
Creating Implementation User using REST API
Creating Implementation User using REST API We can use the REST API below for creating implementation users: REST API Endpoint: /hcmRestApi/scim/Users Method: POST Content-Type: application/json Payload: { “schemas”:[ “urn:scim:schemas:core:2.0:User” ], “userName”:”TEST_DUMMY_USER” }
How to Call Oracle Fusion BIP report from Oracle APEX
In this post, we will walk through the process to call Oracle Fusion BIP report from oracle APEX. Follow below steps to call Fusion BIP report from Oracle APEX. Step1 ===> Create Sample Fusion BIP report. Create sample BIP report in oracle fusion which we will use to call from oracle APEX as shown below: […]
ORDS Part-3: Enable ORDS for Custom Schema using PLSQL
In the Last post, we have seen how to download and install ORDS with XE database. In this post, we will see how to enable ORDS for schema. Step1: Create New User/New Custom schema. Login to XE database with SYS user. Check all pluggable databases. Show pdbs; Alter session to FREEPDB1: ALTER SESSION SET CONTAINER=FREEPDB1; […]
ORDS Part-1: Introduction to ORDS
Oracle REST Data Services (ORDS) is a middleware tool provided by Oracle that enables you to easily expose Oracle Database data and logic as RESTful web services. It’s a key component for modern application development, allowing seamless integration of database functionality with web, mobile, and cloud applications. ORDS (Oracle REST Data Services) is a Java-based […]