Querying on Encrypted Field for example Credit Card Number
Last updated on MARCH 02, 2017
Applies to:Siebel Tools, SPE - Version 126.96.36.199 SIA  to 188.8.131.52 SIA  [Release V8]
Siebel Tools - Version 184.108.40.206 SIA  to 220.127.116.11 SIA [Release V7]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 18.104.22.168  Com/Med
Database: Oracle 22.214.171.124
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""
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms