Data Quality Execution ORA-00907: missing right parenthesis Error After Applying 188.8.131.52 ML Release
Last updated on OCTOBER 29, 2015
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 184.108.40.206.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 220.127.116.11.0, after applying the OFSAA maintenance level (ML) Release v18.104.22.168, 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
Million Knowledge Articles and hundreds of Community platforms