Search on Custom Table Does Not Filter Results Based on Subtable Conditions (Doc ID 2367893.1)

Last updated on APRIL 03, 2023

Applies to:

Goal

Q1: On Oracle Communications Billing and Revenue Management (BRM) 7.5, when searching on custom tables, why are the results not filtered based on suitable conditions?

When performing a search with PCM_OP_SEARCH on a custom object.  The object is mapped in Oracle with a main table "PR_CONTRACT_PROFILE_T" and it has an array (PR_FLD _PACKAGES) which is mapped on the "PR_CONTRACT_PROFILE_PACKAGES_T" table.  When attempting to return results from PR_CONTRACT_PROFILE_PACKAGES_T filtered with conditions on fields in the same table, the search seems to ignore the argument and returns all the rows of the PR_CONTRACT_PROFILE_PACKAGES_T table related to the main object in the PR_CONTRACT_PROFILE_T.

Q2: When we're doing a similar search on EVENT_T and EVENT_BAL_IMPACTS_T, the result returned are correct (condition applied on EVENT_BAL_IMPACTS_T) despite the flag being set to 0 (normal search, no SRCH_EXACT).  So, are there different rules for searches on custom tables and base tables?

The first test case (custom tables) is the one we provided at the start of this thread and the second case is in the same way on the EVENT_T and EVENT_BAL_IMPACTS_T.

For the same object, the search based on conditions in the sub-table (PR_CONTRACT_PROFILE_PACKAGES_T for 1st, EVENT_BAL_IMPACTS_T for the 2nd).

The search on the custom object returns all rows while the one of the EVENT_T only the events with the amount specified.

Following the search on event_t:

Solution

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