DBA in the Trenches

Set the following to get a tracefile: SRW.DO_SQL ('alter session set events=''10046 trace name context forever, level 4'' tracefile_identifier=''REPORT'' '); Need to run this on the Database Tier select p.value from v$parameter p where 1=1 and p.name like 'user_dump_dest'; tkprof input.trc output.prf EXPLAIN=apps/apps SYS=NO You can know use this in a before report trigger srw.user_exit('FND SRWINIT');   srw.message(200,'XX_DEBUG_PRINT:'||fnd_profile.value('XX_DEBUG_REP'));  if (nvl(fnd_profile.value('XX_DEBUG_PRINT'),'N') = 'Y') then      SRW.DO_SQL ('alter session set events=''10046 trace name context forever, level 4'' tracefile_identifier=''REPORT'' '); end if;

When opening a form the Java Security pop shows but then freezes and you can't continue. The only way to close the form is via Task Manager. Solution Control panel > Java > Advanced > Java Plugin > [Disable] Enable the Next Generation Java Plug-in. Reference: ORACLE FORMS – THE APPLICATION’S DIGITAL SIGNATURE HAS AN ERROR – YOUR FORMS APPLICATION IS FOZEN

In accessing R12 applications, it throws the security warning message "The application's digital signature cannot be verified" In some of the client machine once this warning message pops-up, their IE session is getting hanged. Only option is to kill the session from task manager. This is creating problems with application users and hence provide us a solution to get rid of this warning message.  Solution Control panel > Java > Advanced > Security > Disable verification Reference:  Bug 11847386 : NEED TO SUPRESS R12 HANGING WARNING MESSAGE

During upgrade a user ran into this issue on a cloned instance lp: Forbidden Pasta: Error: Print failed. Command=lp -c -dwms_104  /u03/APPLYES/YES/fs_ne/inst/YES_erpapyes/logs/appl/conc/out/MLM_WMS_LABEL_48805775_1.PDF Pasta: Error: Check printCommand/ntPrintCommand in pasta.cfg Pasta: Error: Preprocess or Print command failed!!! APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN. Program exited with status 1 Check the CUPS configuration file to see what the group is for running [root@oraaptest ~]# vi /etc/cups/cupsd.conf # Administrator user group... SystemGroup lp Check the users in the group for lp and add the user to the group [root@oraaptest ~]# vi /etc/group lp:x:15:daemonm,appltest Restart cups and retest the issue [root@oraaptest ~]# service cups restart Stopping cups:                                             [...

First create a decruption function that will decrypt the password. create or replace function xx_decrypt(key in varchar2, value in varchar2) return varchar2 as language java name 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; Create a view used the decryption function: create or replace view xx_user_pass as SELECT user_name,       (SELECT xx_decrypt(UPPER(                               (SELECT (SELECT xx_decrypt(UPPER((SELECT upper(fnd_profile.value('GUEST_USER_PWD')) FROM dual)),usertable.encrypted_foundation_password) FROM dual) AS apps_password                               FROM fnd_user usertable                               WHERE usertable.user_name LIKE   ...

Mount old file system in new server so that you can copy the files over. Replace $[OLD_APPLCSF] ,$[NEW_APPLCSF] and [PROD] with your local settings rsync -a $[OLD_APPLCSF]/log/ $[NEW_APPLCSF]/log/ rsync -a $[OLD_APPLCSF]/out/ $[NEW_APPLCSF]/out/ Need to update the concurrent request table that stores the log file and out file locations update APPLSYS.FND_CONCURRENT_REQUESTS fcr set fcr.LOGFILE_NAME = replace  (FILE_NAME,'$[OLD_APPLCSF]','$[NEW_APPLCSF]') ,fcr.LOGFILE_NODE_NAME= '[PROD]' ,fcr.OUTFILE_NAME = replace  (OUTFILE_NAME,'$[OLD_APPLCSF]','$[NEW_APPLCSF]') ,fcr.outFILE_NODE_NAME= '[PROD]'; For Bi Publisher there is also the additional file that is created and this needs to be updated in FND_CONC_REQ_OUTPUTS. Sneaky one that I later found. update APPLSYS.FND_CONC_REQ_OUTPUTS set FILE_NAME = replace  (FILE_NAME,'$[OLD_APPLCSF]','$[NEW_APPLCSF]') ,FILE_NODE_NAME = '[PROD]';

How do you integrate the UPK directly from the EBS Menu's? A feature is built into the UPK and just need to follow the steps that Oracle suppliers in the document, I have copied them here with some notes of my own: Modify an Existing Custom Library (Custom.pll) Back up your existing CUSTOM.pll to CUSTOM.pll.orig. Copy the CUSTOM.pll from the $AU_TOP/resource folder on the Oracle Applications server to a client machine that has Oracle Forms Builder installed. Copy the APPCORE2.pll from $AU_TOP/resource folder on the Oracle Applications server to a client machine that has Oracle Forms Builder installed. This should be the same folder you used for the previous step. This may not be needed if you already are using FORMS60_PATH setup in the registry. We have created a network folder to the Development $AU_TOP folder that is visible to the developers and the registry key points to it. Locate the ODPNCustomPLL.zip file in the ORACLE folder where the Developer is installed and extrac...

When trying to setup the Workflow Mailer you might get this above error. It basically means that you are connecting to the mail server but not necessarily to the IMAP server. You need to ask your Mail Admin to give you the IMAP server and not the normal mail server. Also make sure that the account has IMAP access as this may be turned off by default

On the Application Tier cd $COMMON_TOP/admin/scripts/CONTEXT_NAME ./adstpall.sh apps/APPS_PWD ###############GOTCHA ############### The Concurrent manager takes quite a while to shutdown. To work around this first shutdown the Concurrent manager with the abort command. ./adcmctl.sh abort apps/APPS_PWD ./adstpall.sh apps/APPS_PWD ####################################### On the Database Tier cd $ORACLE_HOME/appsutil/scripts/ ./addlnctl.sh stop ./addbctl.sh stop immediate Resource: Oracle-Base (Great Resource in General)

So you want to create a Concurrent Program that will run some code on the environment your application is installed on? OK but you also want to use the environment variables that are setup. Seems reasonable. Well I ran into a problem when trying to build a string and then run it. The Story I have a table that I store various commands related to an object. For this example say I want to use FNDLOAD to upload or download a concurrent program I would use something like this: FNDLOAD apps/$APPLPWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct ./MY_CONC.ldt PROGRAM APPLICATION_SHORT_NAME=XXX CONCURRENT_PROGRAM_NAME=MY_CONC So far makes sense but if I want to automate this and seeing as FNDLOAD is pretty standard with its layout i placed the data into the table and made some fields that I change using replace. Not that important but when running the program using a HOST concurrent I was running into trouble. All the fields can be setup using replace except for the apps password...