My Oracle Support Banner

Querying on Encrypted Field for example Credit Card Number (Doc ID 515753.1)

Last updated on NOVEMBER 01, 2018

Applies to:

Siebel Tools - Version 7.5.3.1 SIA [16161] to 7.8.2.13 SIA[19250] [Release V7]
Siebel Tools, SPE - Version 8.1.1.4 SIA [21225] to 8.1.1.11 SIA [23030] [Release V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.1 [16161] Com/Med
Database: Oracle 9.2.0.2
Application Server OS: Microsoft Windows 2000 Advanced Server SP 4
Database Server OS: HP-UX 11.0

This document was previously published as Siebel SR 38-1147633511.

Checked for Relevance on 26-11-2009

""CHECKED FOR RELEVANCE ON 04-FEB-2015""
""CHECKED FOR RELEVANCE ON 21-Sep-2016""

Goal

Is it possible to query on encrypted field? We enabled RC2 encryption on credit card number field and its working fine.

We have a business requirement to identify a fraud transaction. We need to search payment (hold transactions) records using a credit number for past 90 day transactions.

I tried writing eScript to search payment records using actual credit card number. But the query operation (search spec) is not working.

Is there any way to search encrypted field using eScript?

Solution

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
Goal
Solution
 For the benefit of other readers,

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