Error Applying Database Changes from RFM_14.1.3.2_CUMULATIVE_HF_MARCH_2020 Patch (Doc ID 2657760.1)

Last updated on DECEMBER 01, 2021

Applies to:

Symptoms

While trying to upgrade to RFM_14.1.3.2_CUMULATIVE_HF_MARCH_2020 using  patch 31008266, patching of the RMS schema fails with below errors:

3:15:13 04/06/2020 Creating synonyms in RMS14 pointing to RMS_ASYNC_USER ...
13:15:14 04/06/2020 File create_synonyms_one_user.sql successfully executed
13:15:16 04/06/2020 Invalid Compilation attempt 1
13:15:16 04/06/2020 Compiling 47 invalid objects...
13:16:32 04/06/2020 Invalid Compilation attempt 2
13:16:32 04/06/2020 Compiling 2 invalid objects...
13:16:37 04/06/2020 2 invalid objects remain:
13:16:37 04/06/2020 PACKAGE BODY - FM_T_EXT_TAXES_SQL
13:16:38 04/06/2020 PACKAGE BODY - L10N_BR_T_INT_SQL
13:16:38 04/06/2020 See logs in detail_logs/dbsql_rms/invalids for user_errors information
13:16:38 04/06/2020 2 invalid objects
13:16:38 04/06/2020 Failed to complete Post-action for action: DBSQL_RMS
13:16:38 04/06/2020 ORPatch session completed with errors

detail_logs/dbsql_rms/invalids/PACKAGE_BODY_FM_T_EXT_TAXES_SQL.err shows:

9675,166: PLS-00302: component 'REDUCTION_EFFECTIVE_BC' must be declared
9675,25: PL/SQL: Statement ignored
9676,166: PLS-00302: component 'VL_EFFECTIVE_ICMS' must be declared
9676,25: PL/SQL: Statement ignored
9677,166: PLS-00302: component 'ALIQ_EFFECTIVE_ICMS' must be declared
9677,25: PL/SQL: Statement ignored
9678,166: PLS-00302: component 'VL_EFFECTIVE_BC' must be declared
9678,25: PL/SQL: Statement ignored

Similar error is seen in detail_logs/dbsql_rms/invalids/PACKAGE_BODY_L10N_BR_T_INT_SQL.err.

Cause

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