My Oracle Support Banner

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 MARCH 21, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.


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):

0 PIN_FLD_POID POID [0] /search -1 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /service where F1 = V1 or F2 = V2 "
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 2
1   PIN_FLD_POID POID [0] NULL poid pointer
1   PIN_FLD_ACCOUNT_OBJ POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1   PIN_FLD_LOGIN STR [0] "040-20140314"
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1   PIN_FLD_ALIAS_LIST ARRAY [*] allocated 20, used 1
2     PIN_FLD_NAME STR [0] "040-20140314"

    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.

Question :
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

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