Generate Late Charges Process has Performance Issues and nNever Ends
(Doc ID 2264832.1)
Last updated on FEBRUARY 07, 2018
Applies to:Oracle Receivables - Version 12.2.5 and later
Information in this document applies to any platform.
When running Late Charges Generate process, it hangs and never ends
Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Control > Requests
- Run Late Charges Generate
Below is part of the SQL statement causing the issue:
INSERT INTO AR_LATE_CHARGE_TRX_T (LATE_CHARGE_TRX_ID, CUSTOMER_ID,
CUSTOMER_SITE_USE_ID, CURRENCY_CODE, CUSTOMER_TRX_ID, LEGAL_ENTITY_ID,
PAYMENT_SCHEDULE_ID, CLASS, AMOUNT_DUE_ORIGINAL, AMOUNT_DUE_REMAINING,
FIN_CHARGE_CHARGED, TRX_DATE, CUST_TRX_TYPE_ID, LAST_CHARGE_DATE,
HDRS.INTEREST_BATCH_ID = BAT.INTEREST_BATCH_ID AND BAT.BATCH_STATUS = 'F'
AND BAT.TRANSFERRED_STATUS <> 'S'))
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
|1. Bug Summary|
|2. Fixed Files|
|3. Recommended Patches|
|4. Solution Steps|
|Still Have Questions?|