Data Quality Execution ORA-00907: missing right parenthesis Error After Applying 22.214.171.124 ML Release
Last updated on OCTOBER 29, 2015
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Data Quality (DQ)
On OFSAAI 188.8.131.52.0, after applying the OFSAA maintenance level (ML) Release v184.108.40.206, the DQ Referential Integrity checks are failing with the error :
DQ Batch < DQ Batch Name > Failed--907-ORA-00907: missing right parenthesis -> DQ Batch Execution -Failed
These DQ checks were getting executed fine before we applied this ML Release.
The issue can be reproduced at will with the following steps:
1. Run DQ batch
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms