Upgrade to Oracle LSH 3.5

You must upgrade to Oracle LSH 3.5 as a patch to Oracle Applications. The patch 37944438 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 KB382785 and KB464238 respectively on My Oracle Support. Contact Life Sciences Support to get these documents.
  1. Locate p37944438_R12_GENERIC.zip in the staging area.
  2. Unzip p37944438_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 KB382785 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/dme35ddlscript.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.4.0.1, 3.4.1, or 3.4.2 to release 3.5.

    $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 Steps For Configuration And Monitoring CLEANUP_NON_EXIST_OBJ Jobs, Document ID KB464238 on My Oracle Support.

Parent topic: Upgrade to Oracle LSH 3.5