Unable To Decrypt Field Value In BIP Excel Report

(Doc ID 2128685.1)

Last updated on AUGUST 24, 2017

Applies to:

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

Symptoms

On : 7.5.0.0.0 version, Portal Reports

While trying to decrypt the field value Bank NO and Debit Number in BIP report (Excel report) following the steps provided in BRM documentation.

http://docs.oracle.com/cd/E16754_01/doc.75/e16718/rpt_seagate_customize_si75.htm#BRMRT166


Following error occurs.

ERROR
-----------------------



The issue can be reproduced at will with the following steps:
Decrypting and Displaying AES and MD5-encrypted data
If your data is encrypted with the AES encryption scheme, a report must call all the AES and MD5 keys used in BRM database.

To retrieve the values, create a new data template as follows:
 
1. Log on to BI Publisher.
2. Select the report in which you want to display decrypted data.
3. Click Edit.
4. Select Data Model, and click the Report_name.
5. Enter the following text at the end of the SELECT statement in the Data Template field:
bipext.infcryptkeys() as cryptkeys
6. Click Save.
7. Click Layouts.
8. In the Manage Template Files section, click the Report_name.rtf, to download the report.where Report_name is the name of the report you have opened.
9. Create a namespace by adding the following text anywhere in the of the report:
<?namespace:cryptext=http://www.oracle.com/XSL/Transform/java/com.portal.pcm.Crypt?>
10. Enter the following text at the beginning of the report page:
<?cryptext:cryptInit(CRYPTKEYS, ‘Abracadabra dabracaabrA’)?>

11. Add the following text in the required location, to decrypt data.
<?cryptext:decryptData(decrypt_parameter)?>
where decrypt_parameter is the parameter.
For example, for the Debit_num field add the following text:

<?if:$PARAM_
MASKCCNO=0?><?bipext:infReplicateString(cryptext:decryptData(DEBIT_NUM),'*', 4)?>
<?end if?>
<?if:$PARAM_MASKCCNO=1?><?cryptext:decryptData(DEBIT_NUM)?>
<?end if?>
12. Choose File - Save.
13. Follow the instructions in Uploading the template, to display both the AES and MD5 decrypted data.

 

Cause

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