ORA-06512

When upgrading from 11i to 12.1.3 (via 12.1.1 version), ORA-06512: at "APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG`occurs on package FACPUPG.SQL [ID 1454636.1]

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
FACPUPG.SQL
APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG
ORA-06512

Symptoms

Upgrading from 11.5.10.2 to 12.1.3 (via 12.1.1 first), the following SQL errors out /opt/vision/app/finhr12/apps/apps_st/appl/fa/12.0.0/patch/115/sql/facpupg.sql with:
===============================
declare
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG", line 1651
ORA-06512: at line 103
===============================

Cause

On the lower version of FAPUPGB.pls (120.23.12010000.4.1201010.3), it was missing additional parameters in the FAXEXP and FA_BOOKS_PKG.UPDATE_ROW functions and more specifically, the parameters
FA_BOOKS_PKG.UPDATE_ROW
=========================
X_mrc_sob_type_code => l_mrc_sob_type_code,              <--- the additional parameter


FA_EXP_PVT.faxexp
================
x_impairment_exp      => l_impairment_exp,                            <--- the additional parameter:
Outlined in unpublished BUG 12537420 - QRE1220.3:FA.SQL:SKIPPED JOB: FACPUPG.SQL ON APPSFA_SLA_CURRENT_PERIOD_UPG_

Solution

1. Apply Patch 12537420 and pre-requisites
    If password is requried, please log an SR to obtain.

2. Confirm the following file versions:
       FACPUPGB.pls     120.23.12010000.7