PCM_OP_SEARCH Does Not Retrieve A Result When There is No Entry in The Service Alias List (Doc ID 1913687.1)

Last updated on APRIL 04, 2023

Applies to:

Goal

On : BRM 7.5 PS7 version, DM

Issue :
Consider searching for a service whose login or alias is equal to a given value, when there is no alias defined in the database (service_alias_list_t is empty), the search does not fetch anything.

Steps to reproduce:
1) create an account with a service with login = <LOGIN> (ensure there is no entry created in alias list )
2) search for the service with the following search FLIST (the purpose is to find the services having the login or alias equals to the given string):

    This search will retrieve nothing.

3) Insert in the service_alias_list_t table, any line (even an entry that does not match the above service poid, it doesn't matter)
4) Run the same search again: It will retrieve the service

It seems that the search query fired by the dm_oracle is not good (there should be an outer join on service_alias_list_t).

Expected:
The search in step 2 should return the service poid and account poid.

Question :
How to achieve the expected result?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.