Huge number of records in our HZ_PERSON_PROFILES table (We are running R12 - 12.1.3)
We are in Oracle release 12 (12.1.3) and just found out after 6 days working around the clock on this issue with 2 SEV1 SR with support the following:
Some how the Oracle customer interface process in our R12 (12.1.3) processed and created over 107 million rows in our HZ_PERSON_PROFILES table.
We were trying to run our Customer interface on 10/9/2012 and it was failing do to DQM Sync process. Then we start running the DQM Sync manually. it ran for 3 days nothing happened.
Then we ran the DQM Staging for 3 days it never completed.
Then we disable the DQM process via TCA Manager responsibility and Sync Method and ran the customer interface. The Customer Interface hangged while updateing HZ PERSON_PROFILES table. That is when we came to know we have 107 million rows in the HZ PERSON_PROFILES . We checked in all other R12 instance we only have 4million rows in the HZ PERSON_PROFILES .