My Oracle Support Banner

Unable To Decrypt Field Value In BIP Excel Report (Doc ID 2128685.1)

Last updated on MARCH 06, 2019

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 "Non-Standard SQL" Data Template field as the second returned result (ie. just before "from":
bipext.infcryptkeys() as cryptkeys
For example: "select passwd as PASSWORD, bipext.infcryptkeys() as cryptkeys from service_t;"
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.

If the following error is encountered:
"oracle.xdo.XDOException: oracle.xdo.XDOException: XSLT10gR1: Failed Secure Java Extensions check."
please set the "Disable external references" to false in both BIP and the report.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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