My Oracle Support Banner

Exempt Flag In Currency_trxn Table Is Not Getting Updated (Doc ID 2868846.1)

Last updated on APRIL 24, 2023

Applies to:

Currency Transaction Reporting - Version 8.0.0 to 8.0.0 [Release 8.0]
Information in this document applies to any platform.



We are using “CurrencyTransaction_ExemptFlagUpd” data map in CTR batch for updating the currency transaction exempt flag.  based on “EXEMPT_EXP_DT” (Exempt Expiry Date).

In KDD_INSTALL_PARAM table, we have a configuration parameter (Param_id=103) to specify the list of Exempt category where recertification is not required. For these categories, “EXEMPT_EXP_DT” is going as null as per the logic in pkg_workflow.

Hence, during batch run, transactions are not getting updated with exempt flag as ‘Y’ for these categories and generating normal CTR instead of Audit CTR.



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.