ELA: Post Data Conversion AE - PODC31724260.Step20 (SQL) - RC = 1407 (108,524) Fails During Upgrade to PI 39 (Doc ID 2784769.1)

Last updated on SEPTEMBER 01, 2021

Applies to:

Symptoms

Error in Change Assistant - Post Data App Engine Conversion

PODC31724260 is failing with the following error:

Execute the below SQL in the upgrade environment -- if SQL returns results this indicates a data issue.

SELECT
    *
FROM
    ps_re_ls_am_src s
WHERE
    s.ls_key NOT IN (
        SELECT
            p.ls_key
        FROM
            ps_re_ls_ppty p
        WHERE
            p.ls_key = s.ls_key
            AND p.business_unit_am = s.business_unit
            AND p.asset_id = s.asset_id);

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.