Generation Of Loan Billing Statement Error After Upgrading LNS_BILLING_B.pls to 120.74.12020000.15
(Doc ID 2462550.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Loans - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
In Loans Manager > Servicing -> Payments. In the current amortization schedule for certain scenarios we get the error 'Generation of Loan Billing Statment failed' when customer clicks Bill and apply Next Installment.
After upgrading LNS_BILLING_B.pls to 120.74.12020000.15, 4 loans started failing with the following:
Click click Bill and apply Next Installment, then Submit and you get error -
'Generation of Loan Billing Statement failed'
These same loans worked fine with LNS_BILLING_B.pls to 120.74.12020000.12
In the debug, you may find the following:
----- PL/SQL Call Stack object line object
handle number name
0x20b3d8f08 73 package body APPS.FND_LOG
0x20b3d8f08 216 package body APPS.FND_LOG
0x181b3eb70 88 package body APPS.LNS_BILLING_BATCH_PUB
0x181b3eb70 3138 package body APPS.LNS_BILLING_BATCH_PUB
0x181b3eb70 4402 package body APPS.LNS_BILLING_BATCH_PUB
0x181b3eb70 5110 package body APPS.LNS_BILLING_BATCH_PUB
0x181b3eb70 9220 package body APPS.LNS_BILLING_BATCH_PUB
0x171d8cc00 1192 package body APPS.LNS_BILLING_BATCH_PUB_W
0x1cd92ca78 1 anonymous block
" "ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at ""APPS.LNS_BILLING_BATCH_PUB"", line 3737
ORA-06502: PL/SQL: numeric or value error
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 |
Cause |
Solution |
1. Bug Summary |
2. Fixed Files |
3. Recommended Patches |
4. Solution Steps |
References |