Unable To Encrypt And Then Decrypt The Bank No Field In The /payinfo/cc (Doc ID 2083660.1)

Last updated on AUGUST 17, 2023

Applies to:

Goal

The user needs to encrypt the Bank No and Debit Num field in the /payinfo/cc for data security purpose. The user is able to encrypt the Debit Num field but not the Bank No.

Steps followed are as below:

• Updated the table dd_objects_fields_t:
  set field encryptable to 1 for field_name: PIN_FLD_BANK_NO, PIN_FLD_DEBIT_NUM 
  modify the length of Bank No. from 30 to 255
• Restarted CM and DM
• Created account and error occurs when executing pin_deploy replace for the payinfo/dd object

Error thrown is as below:

The requirement is to encrypt values for the field (DEBIT_NUM , BANK_NO) in the database by setting ENCRYPTED flag as 1. But the values need to be decrypted for sending to the 3rd party/Bank.

The current implementation exports the card details (which also has DEBIT_NUM , BANK_NO) to the 3rd party/BANK using a report, which queries the database directly using SQL, and the report is fetching encrypted values.

Can DBMS_CRYPTO be used to decrypt these fields?
 

Solution

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