Yearly Archives: 2021

Oracle Database Health Check – Importance, Benefits, Checklist and Metrics

A crucial component of every business, a stable health check database is important to ensure the well-being of the staff and the customers. With a periodic inspection of this application,…

Read More

Failure of Web Server bridge: No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent.

ERROR ———————– Failure of Web Server bridge: No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent. Cause —————————– We…

Read More

APP-AR-11526: ORA-00054: resource busy and acquire with NOWAIT specified or timeout

The issue  reproduced when AutoInvoice is run in parallel by 2 different users and from 2 different machines in apps R12.1.3. IMPACT: Due to this issue, users cannot run autoinvoice…

Read More

How to Recompile Invalid Schema Objects

When we are doing the operations like upgrades, patches, and DDL changes the associated schema objects will get invalid. So it is difficult to recompile all the user objects one…

Read More

Delete duplicate records in different ways

How to delete duplicate records in different ways in SQL. for example: Consider the combination of EMPNO & ENAME columns in EMP table is having duplicate records as below, SELECT…

Read More

CREATE TABLE AS STATEMENT (by copying from existing table)

Use SQL CREATE TABLE AS statement to create a table from an existing table by copying the existing table’s columns. What happens to the METADATA and DATA when creating a…

Read More

Uplift your Business with Oracle Outsourcing Services

Cloud Computing is the beginning for your business to achieve thousands of potentials. In the competitive marketing space, we have hundreds of companies offering services to gazillions of clients. As…

Read More

Getting Blank Page When Create Document via Desktop Integrator – EBS 12.2.X

Issue: On : Oracle EBS 12.2.8 version, When attempting to create document, get a blank page. The issue is not limitted to Create Document page, it could happen on any…

Read More

ASSERTION ERROR IN WEBLOGIC

Problem:-Assertion Error Cause:- We will get the Assertion Error in the console because while running managed servers some one clear the cache. So that we will get Assertion Error Solution:-…

Read More

Resolving autoconfig issue with patch file system “adgendbc.sh INSTE8_SETUP”

Problem: In the execution of autoconfig  in the patch file system. we faced the following error. [SETUP PHASE] AutoConfig could not successfully execute the following scripts: Directory: /u01/apps/fs2/inst/apps/TEST_TESTEBSSYS01/admin/install adgendbc.sh INSTE8_SETUP…

Read More