How to Unlock Locked SQL Server Logins
How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the SQL Server instance even…
Read MoreSQL Server Audit File Enabled for Both Failed and Successful Logins
SQL Server Audit File Enabled for Both Failed and Successful Logins Introduction During a routine SQL Server security review, it was observed that SQL Server Audit was configured to capture both FAILED_LOGIN_GROUP and SUCCESSFUL_LOGIN_GROUP events. While…
Read MoreUpgrading to PostgreSQL 16 Using pg_dump and pg_tresore
One of the safest and most reliable upgrade methods is to use pg_dump and pg_restore. This guide walks through the process of migrating your databases from an older PostgreSQL version to PostgreSQL 16.…
Read MoreKafka Administration Commands
Kafka Administration Commands Introduction Apache Kafka is a distributed event-streaming platform used to build real-time data pipelines and streaming applications. In a production environment, 1. List Topics Displays all topics…
Read MoreApplying the October 2025 Critical Patch Update (CPU) in EBS R12.2
Oracle E-Business Suite Release 12.2 – Applying the October 2025 Critical Patch Update (CPU) Overview This article outlines the high-level procedure for applying the Oracle E-Business Suite (EBS) Release 12.2…
Read MoreOracle E-Business Suite R12.2 AD/TXK Delta 16 Upgrade – Practical Implementation Guide
Introduction Oracle E-Business Suite (EBS) Release 12.2 requires periodic updates to its Application DBA (AD) and Technology Stack (TXK) components to maintain security, stability, and Oracle support compliance. AD and…
Read MoreFixing Stuck Trips When Delivery Is Closed but Trip Stop Interface Isn’t Triggered (Oracle WMS)
Introduction / Issue In Oracle Shipping Execution (WSH), it’s common to run into a situation where a delivery has been closed, but the associated trip remains open because the trip…
Read MoreExtracting Bank Detail Reports in Oracle Apps R12
Introduction In Oracle Applications R12, supplier bank account details are not stored in a single, easily queryable table. They’re spread across the Oracle Payments (IBY) schema and Accounts Payable (AP)…
Read MoreHow to Populate a Placeholder Column Using the Before Report Trigger in Oracle Reports
Blog Structure Introduction Oracle Reports provides Placeholder Columns to store values that are not directly retrieved from the SQL query. These values can be assigned dynamically using report triggers…
Read MoreCalling Concurrent Program for Reference Document from APEX to EBS Application
Objective The objective of this document is to explain the process of invoking an Oracle EBS Concurrent Program from the Oracle APEX application using a PL/SQL procedure for report generation.…
Read More