My Oracle Support Banner

R12: CE: Cash Manager Loader Program "Run SQL*Loader- SWIFT940" Performance Degrades After Upgrade to Applications Release 12.2.10 On RDBMS 19c (Doc ID 2894362.1)

Last updated on MAY 09, 2024

Applies to:

Oracle Cash Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

Cash Manager Loader Program "Run SQL*Loader- SWIFT940" is taking Time to complete.

Concurrent program "Run SQL*Loader- SWIFT940" performance degraded after upgrade to Applications Release 12.2.10 on 19c (19.11.0.0.0) database.

On the pre-upgrade environment (Applications Release 12.1.3 on 12C RDBMS) the concurrent program finished in 2/3 seconds.  Now, on the post-upgrade environment (Applications Release 12.2.10 on 19C RDBMS) the same concurrent program finishes in 3/5 minutes.  The performance degraded, from seconds to minutes.  The similar order of execution time (seconds) is expected in on Applications Release 12.2.10 on 19c database.

Steps to reproduce:

  1. Log into Oracle Applications using Cash Management responsibility.
  2. Open the Standard Request Submission (SRS) screen.
  3. Select to run the Cash Manager Loader Program "Run SQL*Loader- SWIFT940"

  

Changes

Upgraded from Oracle Applications Release 12.1.3 on RDBMS 12c, to Oracle Applications Release 12.2.10 on RDBMS 19c (19.11.0.0.0).
RDBMS 19.11.0.0.0 includes the fix for Bug 29252510 - Performance issue using sql*loader when querying sys.all_synonyms 

Cause

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
Symptoms
Changes
Cause
Solution
References


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