Prerequsites and Post Install Steps Failed for Patch 33215338 (Doc ID 2828835.1)

Last updated on MARCH 27, 2023

Applies to:

Symptoms

One user has tried to apply Interim <Patch 33215338>, however there are a couple of bottlenecks as below:

1) The pre-requisite step at export is failing with "Java Heap space" error.
     - tried increasing the admin and managed server to 8 GB max as below, but still failing as the data is huge and there are 79354 discount masters to be deleted.
        "-Xms4096m -Xmx8192m --XX:CompileThreshold=8000 -XX:PermSize=1024m --XX:MaxPermSize=2048m"
     - tried tuning the parameters as per <Note 1953515.1> in WebLogic, but it is still failing.

2) Post DB task @CleanXrefDiscountMaster.sql ran for more than 2 hours and failed with below error:
    DECLARE
    *
    ERROR at line 1:
    ORA-06502: PL/SQL: numeric or value error
    ORA-06512: at line 96

Please provide the SQL statements that can be used to make the required updates directly rather than the export, update, and import pricing XMLs for the prerequisite step as it is a cumbersome process.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.