Upgrade to Oracle LSH 3.4.1

You must upgrade Oracle LSH 3.4.1 as a patch to Oracle Applications. The patch 36272413 is on the media pack.

Note:

The information on how to install the patch and set up the cleanup job are covered under document IDs 3019034.1 and 2925664.1 respectively on My Oracle Support. Contact Life Sciences Support to get these documents.

1. Locate p36272413_R12_GENERIC.zip in the staging area.
2. Unzip p36272413_R12_GENERIC.zip to $NE_BASE/EBSapps/patch.
3. Apply the patch. For information on how to apply the patch, see How To Apply Patches for LSH/DMW in Downtime Mode (Document ID 3019034.1) on My Oracle Support.
4. Set up the cleanup job. For information on how to set up the cleanup job, see document ID 2925664.1 My Oracle Support.
5. Log in to the database as APPS and execute the following script:

   $CDR_TOP/patch/115/sql/dmeErrLogChanges.txt

   The script alters the name of the internal table “dme_err_log” and creates a public view on the table. The script creates a trigger on the view to prevent the unauthorized users from inserting or updating records from the script.