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 …
How to generate tkprof in EBS in 19c Read More »
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 »
The telnet client is used to connect to the MWA server in EBS. Windows has telnet installed by default but it is often disabled. If you use Start > Run > telnet and the program is not found, then telnet is disabled. In this post, we will check how we can enable it How to …
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 »
