PCM_OP_SEARCH Is Not Returning All The Results From Second Level ARRAY When Using DM_TT
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.5.0]
Information in this document applies to any platform.
We are using a custom sub-class of /config that is called /config/hp_config that has 2 levels of nested arrays.
We have tried to run PCM_OP_SEARCH (with the same query, parameters, input FLIST and flags) in order to retrieve complete results from the 2nd level of nested array using 2 different setups:
1 - OBRM 7.5.PS8 -> IMDB Cache Manager (DM_TT) -> Oracle DB
2 - OBRM 7.5.PS8 -> DM_ORACLE -> Oracle DB
When using 1st setup, the output FLIST of PCM_OP_SEARCH does NOT contain complete results (only first level of nested array values are returned)
When using 2nd setup, the output FLIST of PCM_OP_SEARCH contains complete results (both levels of nested array values are returned)
By searching on the Knowledge Base, we found out a similar issue:
reporting there is a BUG (BUG ID 16444176) that has been fixed with< Patch 16525411> (for BRM 7.5 PS3), but it contains fixes for DM_ORACLE only.
We suspect that there's the same issue in DM_TT.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms