We saw how to enable trace in Oracle in an earlier post. The trace files obtained from the method are in raw form which can be converted into a more readable format using the tkprof utility in Oracle (Transient Kernel PROFile utility) tkprof utility in Oracle The syntax is given below tkprofUsage: tkprof tracefile outputfile …
Oracle tkprof utility : How to generate and read Read More »
EBS R12 is supported in Multitenant mode for Oracle Database 19c. If you try to generate a tkprof to report explain plan generation on the Database, you will receive errors for the Invalid username /password in the trace file generated tkprof test.trc test.txt sys=no explain=apps/apps sort=prsela,exeela,fchela The reason for this is that the apps is …
Concurrent Programs can be submitted from the backend ie. database using fnd_request.submit_request.We will check in this post the various code on How to submit a concurrent program from the backend The snippet of the API FUNCTION fnd_request.submit_request ( application IN VARCHAR2 DEFAULT NULL, program IN VARCHAR2 DEFAULT NULL, description IN VARCHAR2 DEFAULT NULL, start_time IN …
How to submit a concurrent program from the backend Read More »
Sometimes it is not possible to buy the expensive HSHSM-based solution for EBS Jar signing. You can use your own private CA for signing the jar files. This post gives an overview of creating private CA using OpenSSL command. One-Time CA Initialization Create CA Directory mkdir ~/ebsJarCAcd ~/ebsJarCA Create CA Directory Structure mkdir certs db …
How to Create a Minimally Viable Private CA for Jar Signing using OpenSSL Read More »
Starting June 2023, the commercial CAs changed their policy and stopped issuing code signing certificates where your private key was kept in a disk file such as the Java KeyStore (JKS) file used by EBS JAR signing tools. In short, the private key used for code signing now needs to be kept in a Hardware …
Many times, you might need to update a profile for multiple users. Changing through the form will be a tedious job, we can change using the plsql procedure from the backend. Here is an example to set the Apps Local Login Type to LOCAL for Multiple users SET SERVEROUTPUT ON SIZE 1000000DECLARE cursor user_cur isselect …
Script to Update a profile for Multiple Users in EBS Read More »
