Exporting Data from Oracle E-Business Suite 12.1.x

Before upgrading Oracle E-Business Suite 12.1.x to 12.2.x, you must back up the data in the TIB_BW_EBS_LOG table in Oracle E-Business Suite 12.1.x.

Procedure

Connect to the database of Oracle E-Business Suite 12.1.x under the plug-in user.
Run the TIB_BW_EBS_LOG_BACKUP_TABLE.sql file located in the TIBCO_HOME\bw\palettes\oracleebs\version_number\config\12.2\upgrade\backupLogTable directory to create the TIB_BW_EBS_LOG_TEMP and WF_PARAMETER_T_TEMP tables.
Run the TIB_BW_EBS_LOG_BACKUP.prc file located in the TIBCO_HOME\bw\palettes\oracleebs\version_number\config\12.2\upgrade\backupLogTable directory to create a stored procedure.
Issue the stored procedure created in Step 3 to copy the data from the TIB_BW_EBS_LOG table to the TIB_BW_EBS_LOG_TEMP and WF_PARAMETER_T_TEMP tables.
Use the exp command provided by Oracle to export the TIB_BW_EBS_LOG_TEM and WF_PARAMETER_T_TEMP tables to your local machine.
The following example shows how to use the exp command. Enter the command at the command prompt.
```
exp plugin/<password>@<Net Service Name>
file=<D:\TIB_BW_EBS_LOG.dmp>
tables=(TIB_BW_EBS_LOG_TEMP,WF_PARAMETER_T_TEMP)
```
In this example, plugin stands for the plug-in user name, password stands for the password of the plug-in user, and Net Service Name stands for the name of the net service that you use. After running the command, the TIB_BW_EBS_LOG_TEM and WF_PARAMETER_T_TEMP tables are exported to the D:\TIB_BW_EBS_LOG.dmp directory of your local machine.

Note: Before using the exp command, you must install the corresponding Oracle database client. For Oracle E-Business Suite 12.1.x, you must install the Oracle 11gR1 client.
Run the post_export.sql file located in the TIBCO_HOME\bw\palettes\oracleebs\version_number\config\12.2\upgrade\backupLogTable directory to drop the TIB_BW_EBS_LOG_TEMP and WF_PARAMETER_T_TEMP tables and the stored procedure created by the TIB_BW_EBS_LOG_BACKUP.prc file from the database of Oracle E-Business Suite 12.1.x.