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 DECEMBER 09, 2020
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.5.0]
Information in this document applies to any platform.
On : BRM 7.5 PS7 version, DM
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).
The search in step 2 should return the service poid and account poid.
How to achieve the expected result?
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