Deinstall 19c Grid Home
The following steps to Deinstall 19c Grid Home, 1. Stop all the database which are related to ASM instance. 2. Stop all the listeners which are related to ASM instance.…
Read MoreDeinstall 19c Oracle Home
The following steps to Deinstall 19c Oracle Home, 1. Stop all the database which are running under this oracle home. 2. Stop all the listeners which are running under this…
Read MoreSQL Query to retrieve User Roles – Fusion Applications
Query: SELECT pu.username,prdt.role_id, prdt.role_name, prd.role_common_name FROM per_user_roles pur, per_users pu, per_roles_dn_tl prdt, per_roles_dn prd WHERE pu.user_id = pur.user_id AND pu.username = <:P_USERNAME> AND prdt.role_id = pur.role_id AND prdt.role_id = prd.role_id…
Read MoreQuery to get Organization detail in Fusion
Overview : Below query to give the organization information in Fusion Query: SELECT hra.organization_id as bu_id ,hro.name organization_name ,hra.business_group_id, hro.* FROM HR_ALL_ORGANIZATION_UNITS_F hra, HR_ORGANIZATION_UNITS_F_TL hro WHERE 1=1 hra.ORGANIZATION_ID =…
Read MoreOracle APEX: The Secret Sauce Delivering Business Value
The webinar started with a welcome note by Pritam Jaipuriar, Head of Sales, Doyensys, depicting the objective of the whole webinar session. The webinar is about how businesses can leverage…
Read MoreFind the Invalid Email Address using Oracle SQL and PL/SQL
Objective: To find the validity of the email address using Oracle Pl/sql and to find the invalid email address from a object like table using Oracle Sql. Using Pl/Sql: DECLARE…
Read MoreRecover a dropped table
Recover a dropped table in Oracle 11g Steps to recover a dropped table in Oracle 11g when flashback mode is off After dropping table and before restoring it from the…
Read MoreSupplier Contact Details
Supplier Contact Details Introduction: This report will provide active supplier contact details. Cause of the issue: To apply TDS tax deduction against open invoice. How do we solve: So, extract…
Read Moreoracle compound trigger to avoid mutating trigger
— Trigger to check if the sal greater than 100000, if yes, log the error message, else update sucessfully create or replace trigger trig_validate_sal before update of sal on emp_t…
Read MoreHow To Resolve Agent Stuck Issue
How To Resolve Agent Stuck Issue: ================================= Workout 1. emctl stop agent 2. ps -ef | grep emagent kill all the process 3. emctl start agent Oracle Enterprise Manager 11g…
Read More