Funds Capture Instruction: Query from view iby_xml_batch_fci_1_0_v when encryption is enabled
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.
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.
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