Identifier Columns Are Sorted in Wrong Order When Creating a Data Quality (DQ) Rule
(Doc ID 2615332.1)
Last updated on NOVEMBER 29, 2019
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
In OFSAAI 8.0.6.x, when creating a new Data Quality (DQ) Rule, after selecting the "Table", the default Identifier Columns are in the wrong order.
You expect the default Identifier Columns to match the order existing in the unique index but instead they are listed in alphabetical order.
For example, for Stage Term Deposit Contracts, the unique index is as follows:
select * from all_ind_columns where table_name = 'STG_TD_CONTRACTS'
order by column_position;
The order is:
When you create a new Data Quality rule, the columns are listed incorrectly as follows:
As a result, you have to re-order the columns manually.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document