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:

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

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