Yearly Archives: 2024

Updating bulk records pending under Inventory Transactions using Oracle Visual Builder Add-in

Introduction: The Oracle Visual Builder Add-in for Excel connects Excel spreadsheets with REST services, enabling you to retrieve, analyze, and edit business data directly from the service. You can download…

Read More

SQL to get the details of Cloud Users who logged within the last 30 days

Introduction:  The purpose of this document is to provide detailed SQL query overview of the cloud users who logged within the last 30 days. Cause of the issue: We didn’t…

Read More

SQL to get the details of Cloud Fusion Projects (PPM)

Objectives :  The purpose of this document is to provide comprehensive information on project headers and its line-level details. This document aims to offer a detailed SQL query overview of…

Read More

Supplier Unmasked bank details Report Query

Supplier Unmasked bank details Report Query Introduction:   This SQL query is used to fetching the data of supplier unmasked bank details to identify if there were any setup was…

Read More

Customer collector name at site level query

Customer collector name at site level query Introduction:   This SQL query is used to fetching the data of customer and collector name at site level.   Cause of the…

Read More

SQL Always on Configuration

Description:  SQL Server Always On is a feature that keeps your databases available even if something goes wrong with the server. It copies your data to other servers so that…

Read More

Error while changing Apps _NE Password

Unable to alter user APPS_NE to change password while changing APPS password using FNDCPASS  Issue:  Changing apps password using FNDCPASS fails with below error APP-FND-02704: Unable to alter user APPS_NE…

Read More

Manually Upgrade APEX for 19c upgrade:

Introduction: This document is intended for APEX upgrade from 23.1 to 24.1 Why we need to do: Upgrade older version to newer version. Steps to upgrade: a. Check the current…

Read More

OAM and OID Issue

OAM is configured with EBS and you see errors like below while opening SSO Url (although EBS non-SSO link is working fine). Error 500–Internal Server Error Failure of server APACHE…

Read More

The listener supports no services.

The listener supports no services Introduction: This document is intended for DBA’s who need to know the listener supports no services. Why we need to do: Listener is not support…

Read More