Query to get AR Adjustments
Introduction Business requested to provide the date for AR Adjustments for a particular period Cause of the issue: Business want to tally the data with uploaded Adjustments. How…
Read MoreORA-1555 FOR LONG RUNNING QUERIES IF “_UNDO_AUTOTUNE”=TRUE
There were interesting situation happened after recreating undo. Most of the requests which have child requests and running more than hour are getting fail with ORA-1555 . When checking the…
Read MoreOracle Internet Of Things (IoT)
Dear Readers I would like to explain more about the Oracle IoT Cloud services. Will provide continues blogs on this technology. In this block we will explore what is IOT…
Read MoreQuick Menu Navigation In APEX
1.Overview In Oracle APEX quick menu navigation is essential for creating a user-friendly and efficient application. Implement a quick search functionality to allow users to find specific pages or records quickly.…
Read MoreTransferring file from one server to another using sftp in shell script
1. Overview In this document, we will explore a shell script named sftp_file_transfer.sh that automates the process of transferring files from one server to another. 2. Technologies and…
Read MoreNested Reports in Oracle APEX
1. Overview The document will talk about nesting a report inside another report using the technologies like Oracle APEX, JavaScript, HTML. In Oracle APEX, embedding a nested report within a customized…
Read MoreSending email alert with multiple attachment using shell script
1. Overview In this document, we will explore how to create a simple yet effective shell script to send email alerts with multiple attachments. 2. Technologies and Tools…
Read MoreCreating Dynamic SQL Generator in Oracle PL/SQL
Table of Contents Introduction Technologies and Tools Used Steps Conclusion 1. Introduction The Dynamic SQL Generator in Oracle PL/SQL allows you to dynamically construct SQL statements, providing flexibility and reusability…
Read MoreOptimizing Workspace Security: Setting “Session Idle Timeout” URL in Oracle APEX
Introduction: In the realm of Oracle APEX administration, ensuring robust security measures is paramount. One crucial aspect is managing the session idle timeout for work spaces. This guide provides a…
Read MoreEnhancing Data Input Efficiency with APEX Multi Row Item Plugin
Overview The APEX-Multi Row-Item-Plugin is a free and open-source plugin for Oracle Application Express (APEX) that allows you to create multi-row input fields within your applications. This could be part…
Read More