How to Create Database Links in Oracle 12C
A database link allows you to reference objects in a remote database. Typically, the remote database will be another Oracle database, but it can be…
Read MoreTechnical Solutions For Customized Datepicker Validation’s using Jquery
Overview This document explains how to give a customized Datepicker validation’s using Jquery in Oracle APEX. Technologies and Tools Used The following technologies has been used to achieve the fancy…
Read MoreTechnical Solutions For Customized Error Message using PL/SQL
Overview This document explains how to give a customized Error Message using minimal PL/SQL code in Oracle APEX. Technologies and Tools Used The following technologies has been used to achieve…
Read MoreThe All-New Oracle Cloud Infrastructure Flexible Network Load Balancer
Without load balancing, the cloud experience of end-users can crumble. It acts as the gateway between the users and the cloud infrastructure and is responsible for fulfilling the needs of…
Read MoreUseful 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 user having access to tfactl:…
Read MorePDB 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 operations in pluggable databases (PDBs). Create a…
Read MoreSGA 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 sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is…
Read MoreThe system has encountered an error while processing the request in R12.2
Error : The system has encountered an error while processing the request. Changes made: Single node environment and Cloning was done. Cause : Login to E-business suite weblogic console Click…
Read MoreThe 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 accessing the SSL URL for E-Business Suite via a…
Read MoreScript to delete concurrent program and the xml templates and data definitions
Begin fnd_program.delete_program(‘program short name’,’applicaton shot name’); fnd_program.delete_executable(‘program short name’,’applicaton shot name’); commit; End; Example: If you have a concurrent Progam called “Employee Details Report” with the short name EMPDTLSREP and…
Read More