Blog / Category
Uncategorized
73 articles in this category
ORA-15064: Communication Failure with ASM Instance
Issue : Error Message: ORA-15064: communication failure with ASM instance This error occurs when an Oracle Database instance loses communication with the…
ORA-29701: Unable to Connect to Cluster Synchronization Service
Issue While starting an Oracle RAC database or an Oracle Restart database, the following error may be encountered: SQL> startup; ORA-29701: unable to connect to…
OIC – Monitoring Costs/Billing Introduction
Introduction: Controlling costs is important, knowing where your universal credits are being spent is important. Realising that overage is now charged is import…
Oracle EBS OAF vs Forms Personalization
Oracle EBS OAF Personalization vs Forms Personalization – Understanding the Difference Introduction Oracle E-Business Suite (EBS) provides multiple ways to cust…
API to create party and link to the Supplier
Introduction / Issue As part of TCA, the supplier needs to be linked to the party. This API establishes the link between the Party and the Supplier. Why We Need…
Pushing OIC Activity Stream Logs directly to OCI Log Analytics
Introduction: OCI Log Analytics is a great value add to OIC monitoring, especially in respect of OIC fleet management. Previously, we needed to send the logs vi…
Enforcing Dynamic Line Limits on APEX Interactive Grids
Introduction When building transactional forms in Oracle APEX—such as sales orders, requisition lines, or booking forms—business logic often requires capping th…
ATS Apex application with Ollama hosted in Cloud Fare
Introduction/ Issue: This is a walkthrough of the mini project that was built end to end in Oracle APEX – an ATS Resume Builder. It takes a user through…
Preventing Duplicate Form Submission in Oracle APEX
Introduction / Issue One of the common issues encountered while developing Oracle APEX applications is duplicate form submission. Users may unintentionally clic…
UI Mistakes Oracle APEX Developers Should Avoid
Introduction / Issue Many Oracle APEX applications successfully meet business requirements but often overlook one critical aspect—the User Interface (UI) and Us…
Enhanced Resource Plan with Item-Level Scheduled Quantities in Fusion SCP
Introduction/ Issue: Developing a custom solution in Oracle Fusion Supply Planning to provide visibility into scheduled production quantities at the item and re…
VBCS – Exporting Data as CSV File From Database
VBCS – Exporting Data as CSV File From Database Introduction: Oracle Visual Builder Cloud Service – Version: 26.04.2 Exporting data from the database table as a…
OIC – Retry Mechanism
OIC – Retry Mechanism Introduction: Oracle Integration Cloud – Version: 24.3.1 Implementing Retry Mechanism in an OIC Integration Why we need to do: OIC…
Managing REST Service Activities in Oracle E-Business Suite Using Ant Scripts
Introduction Oracle E-Business Suite (EBS) provides the Integrated SOA Gateway (ISG) to expose business logic as REST and SOAP web services. As organizations pr…
Bringing Linux Into the Power Automate World: OS-Level Monitoring, Ticketing & Safe Auto-Remediation
The Business Problem Most Power Automate infra automations quietly assume a Windows/M365 world — mailbox triggers, SharePoint lists, Graph calls. The moment you…
Automating New Hire NT ID Provisioning with Power Automate, SharePoint, and PowerShell
Onboarding a new employee usually involves the same repetitive IT task over and over: someone gets a list of new hires, an admin manually checks whether each pe…
Stamping a Watermark Across an Oracle APEX Page
Introduction/ Issue: In Oracle APEX, application pages and reports may contain sensitive or confidential information that should be clearly identified when view…
WIP Move Transaction
Automating Oracle EBS WIP Move Transactions with PL/SQL Moving a discrete job through its routing — queue, scrap, hold, or across plants — is another WIP activi…
Real-Time MongoDB Performance Monitoring Using jq
Learn how to build lightweight, production-ready Bash and PowerShell scripts using jq to stream database logs and monitor server metrics in real-time. In our pr…
Oracle 19c: Resolving ORA-28374 “Typed Master Key Not Found in Wallet” After Creating a New PDB
Introduction While working with Oracle Database 19c in a multitenant environment with Transparent Data Encryption (TDE) enabled, I ran into an issue while addin…
How to Create a New PDB with TDE Enabled and an Encrypted Tablespace in Oracle 19c
Introduction In modern Oracle database environments, securing sensitive data at rest is a critical requirement. Transparent Data Encryption (TDE) ensures that d…
Script to import standard purchase order
Introduction: This blog contains an plsql interface script to import standard purchase order. Script: DECLARE CURSOR PHEADER IS SELECT * FROM XX_PO_IMP_S…
Query to get Journal Entry Reserve Ledger Report
Introduction: This blog contains an SQL query that can be used to run the Journal Entry Reserve Ledger Report. Cause of the issue: The business requires a repor…
Connect Your Oracle Cloud VCNs Like a Pro: The Complete Local Peering Gateway Guide
Everything you need to know about establishing secure, private connectivity between VCNs in OCI Introduction If you’re running applications across multiple Virt…
Mastering Red Hat Satellite: A Complete Guide to Automated Patch Management
Streamline Your RHEL Infrastructure with Lifecycle Management and Content Views Managing a fleet of Red Hat Enterprise Linux servers can be challenging, especia…
Optimizing Slow Transaction Query in Banking Data Analysis
Introduction A critical financial institution was facing severe performance degradation in their daily transaction analysis reports. The primary SQL query that…
ASBN Creation Error for Multiple Purchase Orders Due to Transportation Arrangement Mismatch
Introduction/ Issue: An Advanced Shipment and Billing Notice (ASBN) in Oracle E-Business Suite is a document sent by the supplier to notify the buying organizat…
Modifying WMS Rule in Oracle EBS R12: A Safe Approach
Introduction/ Issue: In Oracle E-Business Suite R12 Warehouse Management System (WMS), Cost Group Rules are commonly used to dynamically assign cost groups duri…
Increase on-hand quantity interface using miscellaneous receipt in Oracle apps R12
Increase on-hand quantity interface using miscellaneous receipt To increase on-hand quantity via a miscellaneous receipt interface, you use an ERP/Inventory sys…
Assembly and Component Items Demand Shortage Report in Fusion SCP
Introduction/ Issue: Developing a BIP report in Fusion to identify component demand shortages for assembly items and improve supply planning decisions. Why we n…
How a Redwood Page differs from a Classic ADF page
Introduction: Redwood Pages and standard ADF pages represent two different approaches to building user interfaces within Oracle applications. While standard ADF…
A Practical Guide to Validating Oracle EBS R12.2 DMZ Node Health and Security
Introduction In an Oracle E-Business Suite (EBS) R12.2 environment, the DMZ web tier acts as the first line of defense between external users and internal appli…
Speeding Up SQL Server Operations with Instant File Initialization (IFI)
In SQL Server environments, routine administrative operations such as database restores, data file growth, and the addition of new data files can become increas…
Creating a MongoDB Database and User with Permissions
Connect to MongoDB usingmongosh To begin working with MongoDB, open your terminal and connect using the MongoDB shell (mongosh): mongosh Create a Database Mongo…
Creation of Bursting using XML Data Template
Step 1: Create XML Data Template <?xml version=”1.0″ encoding=”UTF-8″ ?> <dataTemplate name=”AP_INVOICE_DETAILS” description=”AP_INVOICE_DETAILS” version=”1.0″>…
Dynamic Printable PDF Document in Oracle APEX
Dynamic Printable PDF Document in Oracle APEX Introduction In this document, we demonstrate how to create a dynamic printable document in Oracle APEX using a Dy…
Query to get vendor master with missing GST Numbers report in fusion.
SELECT Qry_rslt.”Supplier Name” ,Qry_rslt.”Supplier Number” ,Qry_rslt.”Supplier Site Name” ,Qry_rslt.”Supplier Status” ,Qry_rslt.”Inactive Date” ,Qry_rslt.”Proc…
Resolving PRCR-1079 / CRS-5076 Due to DB_UNIQUE_NAME Mismatch in Oracle RAC
Error While starting an Oracle RAC database using srvctl, the startup failed with: PRCR-1079: Failed to start resource ora.RACDB.db CRS-5076: Startup of databas…
Replication snapshot agent permission issue and Troubleshooting
Replication snapshot agent permission issue and Troubleshooting 1. What is the replication for the SQL server? SQL Server replication is one of the HADR technol…
SQL servers’ registration in SSMS
SQL 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…
AJAX-Dynamic Tooltips & Cascading LOVs in Oracle APEX
AJAX-Dynamic Tooltips & Cascading LOVs in Oracle APEX Introduction: In Oracle APEX applications, cascading List of Values (LOVs) are commonly used to filter dat…
Build and Consume Secure REST APIs in Oracle APEX using ORDS and OAuth2
Introduction: In the current enterprise technology landscape, applications are increasingly required to integrate and exchange information across diverse system…
Complete WIP Job via External Application (APEX Integration)
Introduction/ Issue: Completing a WIP job in EBS usually involves multiple manual steps. Integrating with external systems like APEX requires an automated and r…
Enhancing Oracle APEX Pie Charts with Custom Colors and 3D Effects
INTRODUCTION: In Oracle APEX 19.2, Pie charts are widely used to visualize proportional data. However, the default 2D Pie chart sometimes lacks visual depth, es…
Video Recording in Oracle APEX
Video Recording in Oracle APEX Introduction:- Oracle APEX allows seamless integration of modern web technologies to enhance application capabilities. Thi…
API to create Quality samples and the results
Introduction/ Issue: This blog contains an API and that can be used in Oracle EBS to create Quality samples and the corresponding results. Why we need to do / C…
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 issu…
High_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,…
End-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 fac…
Configuring a Reverse Proxy on a Linux VM Using NGINX
Introduction In many Linux-based environments, applications are deployed on separate virtual machines or run on different ports of the same VM. While this appro…
Hybrid DNS Patterns for Private Endpoints in Multi‑Site Setups
Introduction / Issue: In multi‑site and hybrid environments, clients sometimes resolve Azure PaaS FQDNs to public endpoints instead of the Private Endpoint (PE)…
Red Hat Insights – Proactive Monitoring & Predictive Analytics
Introduction/ Issue Operating large fleets of Red Hat Enterprise Linux (RHEL) systems across hybrid cloud and on‑premises environments introduces hidden risks—u…
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…
Performance Tuning of Slow Running Queries in SQL
Performance Tuning of Slow Running Queries in SQL
Building Secure Cloud Environments in OCI Without Networking Complexity
Introduction As organizations move critical workloads to the cloud, traditional perimeter-based security models are no longer sufficient. Modern cloud environme…
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…
Quality Test Sample Throughput Report
Introduction: This blog has the SQL query that retrieves all Quality test samples along with their corresponding results. Cause of the issue: Business wants a r…
Reducing AWS Costs by Right-Sizing Kubernetes Workloads
Introduction/Issue:Running Kubernetes on AWS gave us flexibility, but we noticed our monthly bills were climbing fast. On closer inspection, we found workloads…
Fixing CrashLoopBackOff in Kubernetes Pods
Introduction/Issue:During one of our deployments, we noticed several pods stuck in a CrashLoopBackOff state. This immediately raised alarms since critical servi…
Keeping Your Power BI Model Clean by Hiding Fields
Introduction/ Issue: When building Power BI reports, a cluttered fields pane can confuse report developers and slow down the design process. Duplicate-looking c…
Mastering DAX: Avoiding Common Mistakes in Power BI
Introduction/ Issue: DAX is powerful, but its behavior is tied to context—row, filter, and context transition. Misunderstanding these can lead to wrong results,…
Automating Oracle 23ai DB Deployment with Ansible Playbooks across Hosts
Prerequisites Install Python 3 and Ansible on the source (control) host. Install Python 3 on the destination (target) host (Ansible requires Python on the targe…
Exporting Plan Data in Oracle Fusion Supply Chain Planning
Introduction/ Issue: In Oracle Fusion Supply Chain Planning, planners often need to extract plan measure data from demand or supply plan layouts for reporting a…
UPDATE PO SHIPMENT LINE USING API
UPDATE PO SHIPMENT LINE USING API Objective: The intent of this document is to understand how we can update or split the PO Shipment line using API Scenario: Cu…
Creating_Auditing_in_Oracle_Database_23ai
How to Check and Create Auditing Policies in Oracle Database 23ai Auditing in Oracle Database 23ai is not just about compliance — it’s about knowing exactly who…
Oracle Forms Personalization – Validating a Record Input
Introduction: The waybill number is a key reference for tracking shipments. To avoid errors and maintain consistency, the field will now be restricted to accept…
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,…
AR Transaction Type Mapping from Sales Orders
Issue: The AR transaction types are being wrongly picked up from the Sales order. Case 1: Sales order type “SAMPLE-TOYS” should generate AR transactions with In…
Power BI Deployment Pipelines: A Complete Guide for Daily Reporting Projects
🚀 Introduction In today’s fast-paced business environment, creating reports is not enough — managing, testing, and securely deploying them is just as important…
Power BI Data Modelling: A Complete Guide to Performance Optimization
🚀 Introduction Power BI is one of the most powerful analytics tools available, but as datasets grow, performance challenges can emerge. Slow dashboard loading…
Item Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based…