Search For Encrypted Value Not Possible With OZT Encryption

(Doc ID 2361684.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.0.0 and later
Information in this document applies to any platform.

Goal

On Oracle Communications Billing and Revenue Management version 12.0.0.0.0, searching for encrypted values with OZT encryption does not appear to work.

Steps to reproduce:

1. A service is created with an encrypted password

2. When calling the search opcode with this password no results are returned when the following search template is used:

0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /service/pcm_client -1 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /service/pcm_client where F1 = V1 "
0 PIN_FLD_RESULTS ARRAY [0] NULL array ptr
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_PASSWD STR [0] "<password_string>"

The search works in BRM 7.5 when using AES encryption.

For reference, the flist used to create the service is:

0 PIN_FLD_POID POID [0] 0.0.0.1 /service/pcm_client -1 0
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1 0
0 PIN_FLD_LOGIN STR [0] "steffie4"
0 PIN_FLD_PASSWD_CLEAR STR [0] "<password_string>"
0 PIN_FLD_PASSWD_STATUS ENUM [0] 0
0 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 1 0

Question 1:

Is searching against OZT encrypted values supported?

Question 2:

The same plain test string is creating different encrypted string when it is written to the database.

Can you please confirm that is accurate?

Solution

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