Blog / Category
Oracle
50 articles in this category
Inside the RMC Module: The Role Request and Approval Workflow
Inside the RMC Module: The Role Request and Approval Workflow A closer look at how access requests move from submission to review, approval, and expiry in RMC.…
How to Add or Remove a User Role Using Oracle Fusion SCIM REST API with Postman
How to Add or Remove a User Role Using Oracle Fusion SCIM REST API with Postman Introduction / Issue In Oracle Fusion Applications, every user’s access is contr…
Creating and Applying Receipts Through Lockbox Using FBDI
Step 1 – Create a Lockbox Navigate to Settings and Actions > Setup and Maintenance > Manage Lockbox, and define a new lockbox record. Step 2 – Confirm the Lockb…
Understanding Histogram Skew in Oracle – Why It Matters and How to Fix It
Understanding Histogram Skew in Oracle – Why It Matters and How to Fix It Introduction One of the most common reasons for sudden SQL performance degradation in…
Oracle Enterprise Manager – WebTier / OHS Fails to Start
Oracle Enterprise Manager – WebTier / OHS Fails to Start Introduction A common issue in Oracle Enterprise Manager Cloud Control (OEM 13c) is the sudden failure…
Fixing FRM-92101 Error After Re-Enabling a Custom Concurrent Program in Oracle EBS
Introduction During a recent Oracle E-Business Suite (EBS) maintenance activity, we needed to re-enable a custom concurrent program that had been disabled for a…
Designing an Enterprise Cloud Health Review Framework: A Proactive Approach to Cloud Operational Excellence
Introduction / Issue As cloud environments continue to grow, IT teams often focus on deploying new infrastructure while spending less time reviewing the health…
Create custom software image in OCI console
Introduction: A software image in Oracle Base Database Cloud Service serves as a preconfigured template containing a specific Oracle Database and Grid Infrastru…
ORA-14656: Cannot Drop the Parent of a Reference-Partitioned Table – Root Cause and Resolution
Introduction Partitioning is one of Oracle Database’s most powerful features for managing large tables efficiently. Among the available partitioning methods, Re…
Debug Common Errors in SFTP-Based File Transfer Integrations
Use Case: This integration debugging script and approach is used to analyze and resolve common runtime errors in SFTP-based file transfer services, especially d…
Oracle Data Guard Setup in Oracle 23ai Migrating from Non-CDB (Primary) to CDB (Standby)
Introduction This document explains how to configure a normal Oracle Data Guard physical standby in Oracle Database 23ai, where the primary database is a Non-CD…
Step by Step Guide to Oracle Data Guard Broker (DGMGRL)
Introduction High availability and predictable disaster recovery are critical in any Oracle production environment. While managing Data Guard manually via SQL*P…
Oracle Linux OS Upgrade from 7.9 to 8.1 with Oracle 19c database (On-Prem) using LEAPP utility
Prerequisites: a. Oracle Linux 7.9 b. Oracle 19c database (should be 19.3 or higher version), Check using… SELECT target_version AS RU_VERSION FROM dba_registry…
Creating a Database Link in Oracle 19c Database to connect MS SQL Server using ODBC Driver
Prerequisite: 1. MS SQL Server with a SQL Authenticated User. CREATE LOGIN Sivakumar WITH PASSWORD = ‘Doyen@123′, CHECK_POLICY = OFF; SELECT name, type_desc, is…
Strengthening OCI Access Control with IAM Deny Policies
Oracle Cloud Infrastructure’s Identity and Access Management (IAM) service now supports explicit deny policies, providing administrators with the ability to exp…
Keeping OCI Logging Costs Under Control: A Practical Guide for Cloud Users
Introduction Many OCI users are noticing sudden cost increases even though their compute or storage usage hasn’t changed. In most cases, this happens because lo…
Why Apache Iceberg Changes Everything for Enterprise Data Lakes
If you’ve been watching the data engineering space lately, you know how painful data silos and vendor lock-in have become. Oracle just rolled out something that…
How to Connect Oracle Database to Apache Iceberg?
If you’re working with Oracle Database and want to leverage the power of Apache Iceberg for your data Lakehouse. Let me walk you through the different ways you…
Cascading LOVs in Oracle VBCS
Introduction/ Issue: When building business applications, it’s common to have dropdowns (Lists of Values) where the available options in one field depend on the…
OAuth 2.0 Setup from OCI
Introduction: Step by step process of creating OAuth 2.0 instance from OCI. Why we need to do: OAuth 2.0 is essentially a secure permission-granting fram…
Personalization Migration: ADF to Redwood Page
Introduction: Migrating personalization from ADF page (Classic UI) to Redwood UI Why we need to do: Oracle is modernizing its Fusion Applications UI/UX,…
Centralized Content Management with APEX Shortcuts
Introduction: In Oracle APEX 21.2, managing label content across multiple pages can become inefficient and error-prone when updates are required. To centralize…
Creating API using ORDS Rest full services
Introduction: In modern web applications, RESTful APIs play a crucial role in enabling seamless communication between systems, applications, and services. Oracl…
TO DOWNLOAD THE SOFTWARE IN OEM CONSOLE IN OFFLINE MODE
1.Click on agent software once the connection mode set to offline. 2. Click on agent software. 3.Click on appropriate software that you need to download 4.Click…
OPW-00029 During Oracle DBCS Post-Clone
Introduction During Oracle Database Cloud Service (DBCS) post-clone steps, particularly when running the txkPostPDBCreationTasks.pl script, you might face the f…
DCS-10045 Error During DR Creation in DBCS
Introduction Setting up Disaster Recovery (DR) in Oracle Database Cloud Service (DBCS) through the Oracle Cloud Infrastructure (OCI) console is an essential par…
DATA BLOCK CORRUPTION RECOVERY USING RMAN
Data block recovery is a specialized feature within Oracle’s Recovery Manager (RMAN) designed to address instances of data corruption at the block level. Unlike…
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migrati…
How To Insert Data from One Database into Another Database Using Apache Nifi
Introduction: – In modern data management, transferring data between different databases is a common requirement. Apache NiFi, an open-source data integration t…
Creating Dynamic SQL Generator in Oracle PL/SQL
Table of Contents Introduction Technologies and Tools Used Steps Conclusion 1. Introduction The Dynamic SQL Generator in Oracle PL/SQL allows you to dynamically…
Oracle APEX Application Availability Using PL/SQL
Overview : The objective is to enhance Oracle APEX Application Availability through the implementation of PL/SQL code, ensuring uninterrupted and reliable opera…
How to Handle Client Secret Expiry in Azure Authentication for Oracle APEX
Overview : The primary objective of this content is to guide users on how to handle client secret expiry in Azure Authentication for Oracle APEX. Specifically,…
Multiple files upload in Oracle
External table Data load with Delimiter Introduction: to upload the data with the delimiter and special character. Cause of the issue: In the control fil…
How to overcome ORA-01102: cannot mount database in exclusive mode?
Introduction: While starting the Oracle database in the mount stage was failed (ORA-01102: cannot mount database in exclusive mode) with the below error Error:…
Creating Data Source in WebLogic Server
1. Overview This document talks about how to create a data source for java project using Oracle Web logic server. 2. Technologies and Tools Used The following t…
Drag and Down Using Oracle Apex
1. Overview This document explains how to create a Drag and Down the rows using Oracle APEX. 2. Technologies and Tools Used The following technologies has been…
Returning Clause in Oracle Plsql
Use RETURNING Clause to Avoid Unnecessary SQL Statements 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on col…
Use of Flashback in Oracle
Objective: With flashback feature you can recover your table or data, perform queries that return past data in Oracle 19c. The Points to be noted that,The flash…
5 different ways to find TOP N queries
Objective: Let us write five different queries to list the top 4 highest paid employees from EMP table. Methods: 1) Using ROWNUM 2) Using ROW_NUMBER () 3) Using…
Query to check whether database has any externally authenticated SSL users
Please use the below query. SELECT name FROM sys.user$ WHERE ext_username IS NOT NULL AND password = ‘GLOBAL’;
Applying Redhat patching
This is for applying redhat patches and after reboot the server login to the server sudo yum update -y sudo yum check -update | wc -l the count should be below…
Oracle Date Time Function Some Use Cases
To get the first date of the current month: select sysdate “date” from dual /*Current Date */ union all select trunc(sysdate,’MONTH’) from dual /*getting first…
Query to generate Baseline Script for a SQL_ID in Oracle Database
Please use the below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format 9…
Multiple sheet excel report template generation in Oracle BI Publisher 10g
Objective: To create template for generating multiple sheet excel in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Excel contains the bel…
Multiple sheet excel report in Oracle BI Publisher 10g using data template SQL Query
Objective: To generate multiple excel sheet report from OBIP using data template SQL queries. Scenario: Customer needs multiple sheets excel report from OBIP. W…
Data template in Oracle BI Publisher 10g
Objective: To generate reports from OBIP using data template SQL queries. Scenario: Customer has given a requirement to develop the report in OBIP. While develo…
Generate DDL source code using Oracle SQL
Objective: To generate DDL source code using Oracle SQL. Scenario: Customer asks us to generate all the DDL source code for some database objects. So I just fou…
Split by count excel report in Oracle BI Publisher 10g
Objective: To create a template to split records in excel sheet in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Open the Excel. (See bel…
Call Oracle package in Oracle BI Publisher 10g
Objective: To call Oracle package in Oracle BI Publisher 10g. Scenario: Oracle BI Publisher is just a reporting tool. From which we can download excel, csv, xml…
Calculate PO Balances
— Query to retrieve customer PO details SELECT obha.order_number, obha.sold_to_org_id, obha.cust_po_number, obha.header…