Yearly Archives: 2024

Oracle datafiles mount filled and PDB goes to mount state

Introduction: In Oracle databases, datafiles are crucial components that store the actual data. Datafiles are physical files on disk that store the data for all database objects, such as tables…

Read More

Edition-Based Redefinition[EBR] –Granualar access in EBS R12

Introduction: Edition-Based Redefinition is an essential feature in Oracle, designed for oracle database administrators, developers who manage application upgrades. EBR allows for seamless updates with minimal or no downtime, enabling…

Read More

Conquering Primary Key Violation – SQL Server Replication

Transactional replication in SQL Server is a robust feature that allows you to replicate data from a primary database (publisher) to one or more secondary databases (subscribers). While this is…

Read More

A deep troubleshooting on oacore issues

In this blog, we will explore the common OACore issues, their potential causes, and step-by-step troubleshooting techniques to resolve them. Whether you’re an Oracle DBA, application administrator, or IT professional,…

Read More

Troubleshooting Opatch Rollback

The purpose of this blog is to assist DBAs in resolving issues encountered while applying or rolling back OPatch in an Oracle database. , we faced the issue “OPatch Unable…

Read More

Mitigating the Impact of SQL Server Corruption

Introduction Database corruption presents a substantial risk to the integrity and accessibility of critical data within SQL Server environments. Such incidents can result in significant data loss, system outages, and…

Read More

Optimal utilization of Custom SLA can eliminate delays in Month-end closings

Optimal utilization of Custom SLA can eliminate delays in Month-end closings   Introduction/ Issue:  Effective utilization of Sub ledger Accounting can help eliminate delays in month-end close processes. Sub ledger…

Read More

AR Receipt Un-apply Using SOAP Webservice – Oracle Fusion

Introduction: This blog has the SOAP Webservice details that can be used to Un-apply AR Receipts in Oracle Cloud application. Cause of the issue: Business wants to fix the number…

Read More

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