Audit History on pa_projects_all table - View pa_projects_all_ac1
We are in process to upgrade our 11i applications to 12.1.3. After upgrade on Test, we have found that Audit histroy is not getting maintained properly. For example: in 11i, we have enabled audit on project completion date. Whenever somebody updates the completion date, 2 rows appear in view pa_projects_all_ac1, one with audit_transaction_type as 'C' (for current record) and other for 'U' (for updated record). However in R12, only record with 'C' is appearing. The last record with transaction_type 'U' shows the last updated record. Is it expected behaviour or do we need any patch to resolve this issue.