Funds Capture Instruction: Query from view iby_xml_batch_fci_1_0_v when encryption is enabled
(Doc ID 1314509.1)
Last updated on SEPTEMBER 26, 2018
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:
WHERE mbatchid=<enter affected mbatchid>
This returns the following error:
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