Monthly Archives: January 2024

SETUPAWS CERTIFICATE TO SEND E-MAIL

SETUPAWS CERTIFICATE TO SEND E-MAIL    Download the certificates from the link provided by Amazon. Click on PEM Copy the text. Create five certificate file using notepad with extension .crt. Move…

Read More

Enabling Database management and Operation insights in OCI console

Enabling Database management and Operation insights in OCI console   Enabling Database Management: Navigate to the Observability & Management. In the Observability & Management, under Database Management section select the…

Read More

Create and Assigning the Bank Account to the Supplier in Oracle Apps 11i

This Document will explain the steps to create Supplier Bank account and assign the supplier to the Bank account in Oracle Apps 11i. In Payables, you can define external banks…

Read More

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