Yearly Archives: 2024

SLA Customization to Override Accounting created by Auto Accounting

SLA Customization to Override Accounting created by Auto Accounting Review the setup for replacing the accounting generated by Auto Accounting using Sub ledger Accounting (SLA) in R12. In Release 11i Auto…

Read More

Exploring the significance and utility of responsive number counters in Oracle APEX applications

Overview A responsive number counter is not only capable of displaying numeric values but also adjusts its appearance. It provides a means to present data or perform calculations based on…

Read More

Installation of Autonomous Transaction Processing (ATP) Database

OVERVIEW: Oracle Autonomous Transaction Processing (ATP) is a cloud-based, fully managed database service by Oracle. It automates administrative tasks, enabling users to focus on application development. ATP is optimized for…

Read More

MongoDB Backup and Restore

This blog post will discuss the process of backing up and restoring a MongoDB database using the built-in commands and tools provided by MongoDB. To perform a data backup in…

Read More

GridFS file system on Mongodb

Introduction to Grid FS: MongoDB has a 16 MB limit for normal document size. To store larger files, MongoDB offers Grid FS, which divides files into smaller chunks stored as…

Read More

PERFORMANCE TUNNING IN MSSQL

INTRODUCTION SQL tuning is the process of improving SQL queries to accelerate your servers performance. It’s general purpose is to reduce the amount of time it takes a user to…

Read More

Query to get Payment Reversal

Introduction Business requested to provide the Payment reversal information   Cause of the issue: Business want to cross check with Payment reversals   How do we solve: We have created…

Read More

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 More

ORA-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 More

Oracle 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 More