AnsweredAssumed Answered

PPA_TRANSCONTROLAPINFO - 3 million transactions

Question asked by navzjoshi00 Champion on Jul 11, 2014
Latest reply on Jul 11, 2014 by urmas

There are 3 million transactions in the PPA_TRANSCONTROLAPINFO table.

 

When we run the below query, we get 46 records -

select count(*)  from ppa_transcontrol, PPA_TRANSCONTROLAPINFO where PPA_TRANSCONTROL.PPA_TRANSCONTROLAPINFO_ID = PPA_TRANSCONTROLAPINFO.ID


When we run the below query, we get 3775336 -

Select count(*) FROM ppa_TransControlAPInfo WHERE ppa_TransControlAPInfo.ID

NOT IN (SELECT PPA_TRANSCONTROLAPINFO_ID FROM PPA_TRANSCONTROL)


Quick question - Is it ok to delete the transactions from PPA_TRANSCONTROLAPINFO table ?


Has anyone observed this issue before ?


NJ

Outcomes