Add Multiple user/Responsibility through backend
With the following we can add multiple user name and multiple responsibilities through backend. set define off; declare res_user_name varchar2(100); res_app_sn …
Read MoreForms memory consumption
The Following query is to get the memory consuming forms sessions. #!/bin/sh ALLPROCS=`ps -ef|grep “f60webmx webfile=” | grep -v grep | tr -s ” ” | cut -f3 -d” “`…
Read MoreMandatory checklist – post clone of EBS
The following query will give the values of some important parameters to be considered post clone. SELECT e.profile_option_name Profile, e.profile_option_id, f.user_profile_option_name User_Profile_Name, c.application_short_name, decode(a.level_id,10001,’Site’,10002,’Application’,10003,’Resp’,10004,’User’) LevelSet_At, decode(a.level_id,10001,’Site’,10002,c.application_short_name, 10003,b.responsibility_name,10004,d.user_name) LValue, nvl(a.profile_option_value,’Is Null’)…
Read MoreTo display all data for a particular block while opening the EBS form.
Overview Sometimes having a requirement to display all block data whenever form is open. In order to achieve please follow below step, Open Form builder> Open your custom form >Go…
Read MoreLife At doyensys – Saravana Kumar KP
Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreHow Doyensys Migrated a Client’s E-Business Suite to Cloud
As an organisation, Doyensys believes in pushing the boundaries and setting examples for others to follow. Our team of hard-working and talented Doyens is always willing to accept new challenges.…
Read MoreQuery to find Custom objects , custom forms , custom form personalization , custom concurrent programs.
Description: Query to find Custom objects , custom forms , custom form personalization , custom concurrent programs. custom objects: ——————– select * from dba_objects where (upper(object_name) like ‘XX%’ or upper(OBJECT_NAME)…
Read MoreCheck the Details of which scheduled jobs are finished with error.
Description: Check the Details of which scheduled jobs are finished with error in database level. Query: set head on; set feed off; set pages 0; set verify off; set feedback…
Read MoreBackup oracle home and inventory
How to Backup ORACLE_HOME binaries and Oracle INVENTORY ORACLE_HOME and INVENTORY need to backup before Database / OS level patching Table of Contents ______________________________________ Backup ORACLE_HOME and INVENTORY 1. Shutdown…
Read MoreORA-29283: invalid file operation: path traverses a symlink [29433]
DB : Oracle 19.5 OS : RHEL 7 Expdp is failing due to the below error in my 19c database Export: Release 19.0.0.0.0 – Production on Thu Apr 30 06:06:42…
Read More