Upgrade to Oracle LSH 3.4.2

You must upgrade to Oracle LSH 3.4.2 as a patch to Oracle Applications. The patch 37117489 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 p37117489_R12_GENERIC.zip in the staging area.
  2. Unzip p37117489_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. As an APPS user, run the following script:

    Note:

    While executing, pass the value as APPLSYS when it asks for parameter :1.

    $CDR_TOP/patch/115/sql/dme342ddlscript.sql

  5. Log in to the database as APPS and execute the following script:

    Note:

    Execute the following script only if you are upgrading from release 3.3.x, 3.4.0, or 3.4.0.1 to release 3.4.2.

    $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.

  6. Set up the cleanup job. For information on how to set up the cleanup job, see document ID 2925664.1 on My Oracle Support.

Parent topic: Upgrade to Oracle LSH 3.4.2