Description:
Symptoms
========
This problem can be seen when the user is upgrading from prior versions of OracleApps Adapter to v5.2.0 or v5.2.1 and deploying the common_all.sql script as part of post-installation steps. When deploying the script, error stating TIB_INT_LOG_SUB table already exist will be thrown. If this script is not deployed, and if we try to compile the PL/SQL scripts generated by the adapter as part of subscription configuration, compilation error saying variables not defined will be thrown.

Impact
======
Loss of Functionality
Deploying the scripts generated as part of the adapter configuration will throw compilation errors.

Cause
=====
The table TIB_INT_LOG_SUB is modified to include 2 new columns TIBCO_SOURCE and TIBCO_SOURCE_ID in the newer release of the adapter for the tracking functionality. So if this table is not modified, the compilation error related to the variables TIBCO_SOURCE, TIBCO_SOURCE_ID not defined will be thrown.

Workaround
==========
Please run the attached alter_common_all.sql script while upgrading to TIBCO adapter for OracleApps v5.2.0 or v5.2.1.  This script alters the TIB_INT_LOG_SUB log table without dropping it and also gives required permissions for additional tables specific to v5.2.0/v5.2.1 release.

Resolution
==========
This issue has been addressed in 5.3.0 release of the adapter.
Symptoms:

Cause:

Unable to successfully deploy the common_all.script as part of post-installation task, when upgrading to TIBCO Adapter for Oracle Applications v5.2.0 or v5.2.1.