My Oracle Support Banner

PCM_OP_SEARCH Fails due to dm_oracle Appending Additional Bind Variables to SQL Query for each Wildcard (Doc ID 2684789.1)

Last updated on OCTOBER 21, 2024

Applies to:

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

Symptoms

On Oracle Communications Billing and Revenue Management (BRM), calling the PCM_OP_SEARCH opcode with wildcards fails with the following error:

 Same search works ok in 7.5 version.

Changes

Upgrade BRM from 7.5 to 12 Patch Set 3.

Same issue persists on 12 Patch Set 3 plus Interim Patch 3 (IP3) (<Patch 31848465>) as well.

Cause

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
Symptoms
Changes
Cause
Solution
References


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