1.Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass # --- CONFIGURATION --- $oracleHome = "D:\automation\WINDOWS.X64_193000_db_home" $patchDir = "D:\automation\p37532350_190000_MSWIN-x86-64 (2)\37532350" $opatchDir = "$oracleHome\OPatch" $opatchZip = "D:\automation\p6880880_190000_MSWIN-x86-64.zip" $logFile = "C:\Users\Administrator\Documents\oracle_patch_log.txt" # Define Oracle services $dbService…
Read MoreSQL servers’ registration in SSMS What is server registration in SSMS? It is one of the features in SQL Server Management Studio (SSMS) which is very useful to have a list of registered servers…
Read MoreIntroduction/ Issue: Organizations operating across multiple countries and currencies require accurate financial reporting in more than one currency. In Oracle Fusion Financials, finance teams often face confusion between Reporting Currency…
Read MoreIntroduction/ Issue: Modern finance teams using Oracle Fusion Financials deal with large transaction volumes, tight close timelines, compliance pressure, and growing expectations for real-time insights. Traditional rule-based processes and…
Read MoreAJAX-Dynamic Tooltips & Cascading LOVs in Oracle APEX Introduction: In Oracle APEX applications, cascading List of Values (LOVs) are commonly used to filter data based on user selections. However, users…
Read MoreIntroduction: In the current enterprise technology landscape, applications are increasingly required to integrate and exchange information across diverse systems in a secure and reliable manner. Oracle APEX, in conjunction with…
Read MoreStep-by-Step guide to installing MySQL Server Step 1: Download MySQL Installer Open your web browser and go to the official MySQL downloads page. Choose the MySQL Installer for Windows appropriate for your system. …
Read MoreCommon causes of SQL Server Timeout During a recent production run, a stored procedure timed out at peak order processing. This caused delays in processing orders and highlighted the importance of query…
Read MoreIntroduction:- To improve user experience in Oracle APEX by implementing a Recently Visited Pages dashboard. By using APEX activity logs, it demonstrates how to track user navigation and dynamically display…
Read MoreIntroduction:- This blog explains how to implement a reusable character counter for normal text fields in Oracle APEX, similar to the built-in character counter available for text areas. It demonstrates how a…
Read More