API to create Routing and assign resources
Introduction/ Issue: This blog contains an API and that can be used in Oracle EBS to create Routings and assign resources. Why we need to do / Cause of the…
Read MoreCopying Table Data from Source to Destination in SQL Server
Purpose and Scope This document describes the procedure to copy table data from a source server to a destination server using the SQL Server Import and Export Wizard. This method is commonly used for…
Read MoreBasic SQL Performance Tuning tips
The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server. Introduction We…
Read MoreHow to Add a Database to an Existing Always On Availability Group
Introduction : Always On Availability Groups is a high-availability and disaster-recovery feature in SQL Server that ensures database continuity with minimal downtime. In this blog, I explain the step-by-step process to…
Read MoreOracle EBS Security Under Control: Automated Audits with FND Tables
1. Security Model Overview Oracle EBS security is built on a multi-layer authorization model: FND_USER → user identity FND_RESPONSIBILITY → functional access FND_USER_RESP_GROUPS → assignment mapping Unlike database roles, EBS…
Read MoreWhy OACORE Slows Down: A JVM Health Monitoring Guide for EBS 12.2
1. Background & Architecture Context In Oracle E-Business Suite 12.2, OACORE is the primary Java container responsible for handling: OA Framework pages Forms servlet communication XML Publisher services REST and…
Read MoreCreating Zero Amount Payments in Oracle Fusion Payables
Introduction/ Issue: In Oracle Fusion Payables, there are scenarios where invoices get fully adjusted through credit memos, prepayments, or rounding adjustments. Although the invoice balance becomes zero, the invoice may…
Read MoreHigh_Severity_)Vulnerability
Oracle E-Business Suite Hit by New High-Severity Vulnerability (CVE-2025-61884) Overview Oracle has disclosed a new high-severity vulnerability, CVE-2025-61884, affecting Oracle E-Business Suite (EBS) versions 12.2.3 through 12.2.14, as documented in…
Read MoreRemove_Used_Disk_from_an_ASM_Disk_Group_in_Oracle_19c_RAC
How to Safely Remove a Used Disk from an ASM Disk Group in Oracle 19c RAC Removing or deleting a used disk from an ASM disk group in Oracle 19c…
Read MoreEnd-to-End CIP Asset Creation in Oracle Fusion: PPM to Fixed Assets
Introduction : In Oracle Fusion Financials, organizations often incur project-related costs that need to be capitalized as assets. However, users frequently face challenges in correctly creating Construction in Progress (CIP)…
Read More