ARLPLB - Performance Issue With Lockbox Validation In arp_lockbox_hook_pvt.proc_after_validation
(Doc ID 799973.1)
Last updated on FEBRUARY 19, 2019
Oracle Receivables - Version 12.0.4 and later Information in this document applies to any platform.
Executable:ARLPLB - Process Lockboxes
Lockbox validation is having performance issues. It runs for almost 2 hours for 8900 records. Custom hook is enabled at the lockbox to process line level cash applications. However if the custom hook is disabled it takes less than 5 min.
Top SQL in tkprof file is:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!