My Oracle Support Banner

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

Last updated on APRIL 23, 2021

Applies to:

Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.


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:


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 ?


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


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

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