Funds Capture Instruction: Query from view iby_xml_batch_fci_1_0_v when encryption is enabled (Doc ID 1314509.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.
Checked for currency on 31-DEC-2013.

Goal

On many occasions we require to pull the funds capture xml extract from an anonymous sql session for debugging. However, this isn’t possible in R12 when the environment contains encrypted data.

 

The following query is being executed:

 

SELECT XMLType.getClobVal(instruction)
FROM iby_xml_batch_fci_1_0_v
WHERE mbatchid=<enter affected mbatchid>

 

This returns the following error:

 

ERROR
ORA-20000: IBY_10008#INSTRID=15000
ORA-06512: at "APPS.IBY_CREDITCARD_PKG", line 1265

 

Is there any Recommended/Supported way to avoid this error ?

 

Workaround:
Disable encryption from Funds Capture Setup Admin responsibility --> System Security Page.

Solution

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