Oracle ETRM
The Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) is a repository of database design and dependency information for Oracle ...
Oracle EBS
Challenges and Solutions from working on Oracle E-Business Suite.
Useful TFACTL Commands
1. Check tfactl status with version: tfactl status 2. Check tfactl tool status: tfactl toolstatus 3. Get config details: tfactl print config 4. List of ...
PDB Lockdown Profiles In Oracle 12.2
ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user ...
SGA TARGET ADVISORY IN ORACLE
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET. MMON background process gather statistics about ...
The security certificate presented by this website was not issued by a trusted certificate authority
Issue : E-Business Suite 12.2 Applications Technology Stack, Secure Socket Layer Configuration issues . Users report receiving the below message when ...
Oracle ETRM
The Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) is a repository of database design and dependency information for Oracle ...
Useful TFACTL Commands
1. Check tfactl status with version: tfactl status 2. Check tfactl tool status: tfactl toolstatus 3. Get config details: tfactl print config 4. ...
PDB Lockdown Profiles In Oracle 12.2
ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user ...
SGA TARGET ADVISORY IN ORACLE
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET. MMON background process gather ...
The security certificate presented by this website was not issued by a trusted certificate authority
Issue : E-Business Suite 12.2 Applications Technology Stack, Secure Socket Layer Configuration issues . Users report receiving the below message ...
Concurrent program assigned responsibilities
SELECT frt.responsibility_name, frg.request_group_name, frg.description FROM fnd_request_groups frg ,fnd_request_group_units frgu ...
Could not initialize the Service Manager FNDSM__ Verify that has been registered for concurrent processing
Cause The issued was found to have been caused by the FND_NODES table having incorrect node entries (old node from the source instance) and that ...
SQL Profiles & Baselines
To check SQL Profile : select NAME,SIGNATURE ,STATUS,FORCE_MATCHING from dba_sql_profiles; ENABLE/DISABLE/DROP EXEC ...
Scripts to identify performance related issues.
one script to Identify all performace issue related to sql query Set echo off set trimspool on set define on column filename new_val filename ...
Undo related queries
Undo Related Queries To check retention guarantee for undo tablespace select tablespace_name,status,contents,logging,retention from ...