People and Culture Blog

Oracle EBS – Query to get PO details

oracle-ebs-query-to-get-po-details Select * from ( SELECT TO_CHAR (SYSDATE, ‘DD-MON-YYYY HH:MI:SS’) rp_run_date, po.*   FROM (SELECT   ou, supplier_number, supplier_name, po_number,                  po_creation_date, po_approved_date,  …

Read More

Google Cloud Infrastructure Using Terraform

Introduction to Google Cloud and Terraform Google Cloud Platform provides a comprehensive suite of cloud services, including computing, storage, databases, machine learning, and more. With its global network infrastructure and…

Read More

WebADI Create Document Redirects From HTTP To HTTPS

  WebADI Create Document Redirects From HTTP To HTTPS   Error :=  Causing Error ERR_SSL_PROTOCOL_ERROR On Oracle EBS R12.2.5 the default URL is HTTP:// but when you navigate to Desktop…

Read More

Inventory load failed in Oracle APPS R12

Inventory load failed in Oracle APPS R12   Inventory load failed… OPatch cannot load inventory for the given Oracle Home in Oracle APPS R12.   Possible causes are:   oradev@oracle…

Read More

Terraform Orchestration: Scaling Infrastructure Deployment with Modules and Workspaces

The Challenge:As infrastructures grow in complexity, maintaining and deploying resources across multiple environments can become a daunting task. Code duplication, consistency challenges, and scaling bottlenecks are common hurdles. The Terraform…

Read More

CREATING MAINTENANCE PLAN FOR BACKUP

A maintenance plan is a set of measures (workflows) taken to ensure that a database is properly maintained and routine backups are scheduled and handled.  Login to the server Go…

Read More

Identify and remove unused indexes in SQL Server

Identify and remove unused indexes in SQL                         Server   Introduction: Indexes means order information about data, with indexes we can retrieve data from the database more quickly than otherwise. Index…

Read More

Database Migration from Non-ASM to ASM

We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands  Check the ASM instance is up and running If not…

Read More

Cloning Tables Between Databases in SQL Server Using Export and Import Functions

Overview: Cloning tables between databases in SQL Server can be efficiently achieved through the use of the built-in export and import functions. This process involves exporting data from the source…

Read More

INSTALLATION OF OEM 13.5 USING SILENT METHOD IN ORACLE DATABASE 19.3 ON LINUX.

OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used for integrated solution for managing your heterogeneous environment. It Includes, Graphical console, Agents, Common Services and Tools to provide…

Read More