Procedure to create Quality Spec WIP Validity Rule in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Spec WIP Validity Rule using oracle seeded API. Cause of the issue: Business…
Read MoreProcedure to create Quality Spec INV Validity Rule in OPM through API
Introduction: This blog has PLSQL query that can be used to create Quality Spec INV Validity Rule using oracle seeded API. Cause of the issue: Business will…
Read MoreProcedure to create Quality Spec & Quality Spec Values in OPM through API
Introduction: This blog has the PLSQL query that can be used to create Quality Spec & Quality Spec Values using oracle seeded API. Cause of the issue:…
Read MoreAPEX & ORDS UPGRADE
Description: This document explains how we upgraded Oracle APEX, ORDS, and Java on the DBNAME database. It covers the checks and backups done before starting, the steps for installation and configuration, and how we fixed common issues during the process. The aim was to move from older versions to APEX 24.1, ORDS 24.1, and Java 11 smoothly, without affecting service availability. Componets Current versions Upgrade version Apex 22.2 24.1 Ords 21.2 24.1 Java Jdk-1.8 11.1 Pre checks and backups. Apex Workspace backups. Steps: Login to admin responsibility and take the workspace level backup. Using APEX port utility to take workspace and application backups in backend. Tomcat and Ords backup Taking current tomcat and ords backup using tar. Validate workspace schema backup should be taken in DBA team. Installation of apex in DB level.…
Read MoreEnhancing Jasper Reports with Dynamic PDF Titles
Introduction: In many web applications that use JasperReports, the same JSP export logic serves multiple report templates (.jrxml files). Each report may represent different business documents such as share certificates,…
Read MoreDATAGAURD BROKER CONFIGURATION
DATAGAURD BROKER CONFIGURATION Introduction: Oracle Data Guard Broker is a management framework that automates and simplifies the configuration, monitoring, and administration of Oracle Data Guard environments. It provides a centralized…
Read MoreChanging Interactive Grid Headings Dynamically in APEX
Introduction: In Oracle APEX, Interactive Grids often display fixed column headings, which may not suit scenarios where data is time-bound or varies with user input. When working with reports spanning…
Read MoreAPEX 21.2 Installation in Oracle Linux 19C Database
Introduction:This document provides a step-by-step guide to installing Oracle APEX 21.2 on an Oracle 19c database running on Oracle Linux.It covers prerequisites, setup, and configuration for APEX, ORDS, Java, and…
Read MoreFailover issues in Always-on AG
Failover issues in Always-on AG What is failover in always-on AG in SQL server.? In SQL Server Always On Availability Groups (AG), failover is the process of switching the…
Read MoreSA account is locked in sql server
SA account is locked in SQL server What is SA account in SQL server.? The “SA” (system administrator) account in SQL Server is a highly privileged, built-in account with…
Read More