ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Customer posted wrong data to PPA_TRANSCONTROL and would like to remove it, what to do?

book

Article ID: 186212

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Customer posted wrong data to PPA_TRANSCONTROL and would like to remove it, what to do?

Environment

Release : All Supported Clarity releases

Component : CA PPM SAAS FINANCIAL MANAGEMENT

Resolution

Make sure the data in PPA_TRANSCONTROL and PPA_TRANSCONTROL_VALUES are only the ones to remove

Backup PPA_TRANSCONTROL and PPA_TRANSCONTROL_VALUES tables
Run the Sql query statements 

For Example:

If you want to remove records for certain dates you will need to run queries that are based on the date.

Since the TRANSDATE is only in PPA_TRANSCONTROL we recommend deleting from PPA_TRANSCONTROL_VALUES first using query similar to

1. Back up PPA_TRANSCONTROL and PPA_TRANSCONTROL_VALUES

2.  run the select queries to make sure you get the correct data

a)     select *  from ppa_transcontrol where transdate > = <enter the date for entries you want to removed>

b)    select * from ppa_transcontrol_values where transno in
       (select transno from ppa_wip where transdate > = <enter the date for entries you want to removed>  
  
     - this should be 5x the rows found in ppa_transcontrol as it holds 5 different currency types.

3.  Run the delete queries.  Delete from ppa_transcontrol_values first

     delete from ppa_transcontrol_values where transno in
     (select transno from ppa_wip where transdate > = <enter the date for entries you want to removed>

Then basically the same query for ppa_transcontrol

    delete from ppa_transcontrol where transdate > = <enter the date for entries you want to removed>