Both Planning Classic and EPMA have a delete application feature that deletes the application and its related database tables. For Classic Planning: Use the Classic Application Wizard in Planning to delete Classic Planning applications. See "Deleting Applications" in the Oracle Hyperion Planning Administrator's Guide. The Delete Application button deletes all Planning created HSP_xxx tables in the Planning relational database and all the records pertaining to that application in the Planning System database. The data source used to connect to this application remains in the Planning System database and gets a -1 in the app_id field used to point to the application record in another table before the application was deleted. The Delete Application button also deletes the application and all associated cubes/plan types from Essbase. No additional steps should be required to delete a Core Planning application. For EPMA: Use the Application Library in EPMA to delete applications. See "Deleting Applications" in the Oracle Hyperion Enterprise Performance Management Management Architect Administrator's Guide. An EPMA application will not show up in the list in Classic Planning Administration where the Delete Application button is displayed. A Planning application that has been upgraded to EPMA has to be deleted from the EPMA Application Library. Deleting the “application view” from the EPMA Application library deletes everything deleted by the Delete Application button and in addition deletes some records pertaining to this app from EPMA relational tables
|