Monthly Archives: June 2024

Import Auto Invoice – Error Message: You must enter a valid original system bill-to customer address reference. The current reference is {ORIG_SYSTEM_BILL_ADDRESS_REF.

Import Auto Invoice – Error Message: You must enter a valid original system bill-to customer address reference. The current reference is {ORIG_SYSTEM_BILL_ADDRESS_REF.   Introduction/ Issue:  We have an invoice which…

Read More

How to list all integrations in an OIC instance using REST API

Introduction: This process would overview how to use the rest API to list available integrations in an OIC instance.   Cause of the issue: As there is no option to…

Read More

Restoration job failed in Log shipping

  What is Log shipping?  SQL Server Log shipping is an automatic process that sends transaction log backups from a primary database server instance to secondary databases server on secondary server instances.…

Read More

Overview of Block Volume in Oracle Cloud Infrastructure

INTRODUCTION: In today’s world, businesses create and uses a huge amount of data, so they need storage solutions that are both efficient and able to grow as needed. Oracle Cloud…

Read More

Comparison Between File Storage and Block Volume in OCI

Introduction: In cloud computing, choosing the right storage solution is important to ensure good performance, manage costs, and handle data efficiently. Oracle Cloud Infrastructure (OCI) provides different storage options, including…

Read More

Buffer Pool Parallel Scan: SQL Server 2022’s Answer to High-Memory Optimization

Introduction In today’s data-driven world, database performance is crucial for business success. SQL Server 2022 introduces significant advancements, including the Buffer Pool Parallel Scan feature, designed to optimize performance on…

Read More

ORACLE E-BUSINESS SUITE 12.2.10 RELEASE UPDATE PACK failure : ORA-06501: PL/SQL: program error

This post talks about the issue you may encounter when applying R12.2.10 RUP patch as part of R12.2.11 Upgrade.   ERROR: sqlplus -s APPS/<passwd> @/pvebsuat_pebsuat_cls/apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql ‘/pvebsuat_nebsuat_cls/apps/fs2/EBSapps/appl/asn/12.0.0/patch/115/sql/asndelff.sql ‘ Connected. PL/SQL procedure…

Read More

TempDB full issue

TempDB Files space issue    What is the purpose of tempdb in SQL server.?  Ans: Tempdb is a temporary database which contains tables data for temporary purpose SQL Server PDW system…

Read More

New Features and Enhancements in SQL Server 2022

New Features and Enhancements in SQL Server 2022   SQL Server 2022 introduces a variety of innovative features and performance enhancements. Below is a detailed overview of these advancements: Azure…

Read More

Transitioning from Screen to tmux on Linux 8

Introduction In the demanding environment of database administration, managing multiple tasks efficiently is vital. For Oracle DBAs working on Linux systems, tmux (Terminal Multiplexer) is an essential tool. It enables…

Read More