PCM_OP_SEARCH Is Not Returning All The Results From Second Level ARRAY When Using DM_TT (Doc ID 1944101.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

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

Symptoms

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:

PCM_OP_SEARCH Is Not Returning All The Results For Two Levels of ARRAY In a Class <Note 1541404.1>

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.

Cause

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