SERVICE CONTRACT – Oracle External Table
This is the sample script to create the oracle external table to access the data from the file. prompt prompt creating TABLE XX_SC_EXT ….. CREATE TABLE “XX”.”XX_SC_EXT” (…
Read MoreApex, Tomcat, and ORDS Installation Automation using silent method
Apex, Tomcat, and ORDS Installation Automation using silent method Introduction: This document provides steps to easily install Apex, Tomcat, and ORDS on a Linux system. Step 1: Create a file apex_install_params.txt…
Read MoreElevating Security with Oracle Database 23c: Schema-Level Grants Unveiled
Introduction: In the world of database management, developers used to face a tough decision – either spend time granting specific permissions for each table or take the risky route of…
Read MoreDecoding “ORDS 404 Not Found” error in ORDS
Cloning oracle databases from production to test environments is a common practice, but it comes with its own set of challenges, particularly in handling critical APEX user passwords. Encountering an…
Read MoreResolving Concurrent Request Report Output Error in Oracle E-Business Suite
Introduction: Encountering an issue where the Concurrent Request Report Output from the Oracle Report Manager Homepage dashboard redirects to the DMZ node instead of the primary node can be frustrating.…
Read MoreResolving BBM JAR Issue in Oracle E-Business Suite R12.2
Introduction: In Oracle E-Business Suite (EBS) R12.2, encountering BBM (Business Intelligence and Business Process Management) JAR issues can disrupt normal operations. This blog post provides a step-by-step guide to address…
Read MoreRegister a printer in oracle
Introduction: This blog is done to register a printer in oracle. Cause of the issue: Printer is not setup in oracle. How do we solve: Go to…
Read MoreQuery to get the Printer Name
Introduction: This query is used to fetch the printer name .In this we will be passing concurrent program id and level value id(user id) as the parameter so that printer…
Read MoreUnveiling the Latest Seeded Programs in Oracle E-Business Suite 12.2
Introduction: Upgrading from Oracle E-Business Suite 11i to R12 or transitioning between 12.x versions is a crucial step for organizations seeking enhanced functionality and improved performance. As part of this…
Read MoreHow to merge cells in classic report using JavaScript.
Overview This document is about how to merge cells in classic report using javascript in oracle apex. Technologies and Tools Used The following technologies have been used to to merge cells in…
Read More