Disbursement Issue for Partially Paid Upgraded Invoices
Last updated on JANUARY 19, 2018
Applies to:Oracle Lease and Finance Management - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Disbursements
Disbursement issue for partially paid Upgraded Invoices. Disbursement is only created for amount applied after upgrade.
Cause of the wrong disbursement is due to below function called in disbursement.
CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER,cp_customer_trx_line_id NUMBER) IS
SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) receipt_amount
FROM ar_receivable_applications_all raa,
WHERE raa.applied_customer_trx_id = cp_customer_trx_id
AND raa.application_type = 'CASH'
AND raa.status = 'APP'
AND raa.display = 'Y'
AND raa.receivable_application_id = ad.source_id
AND ad.source_table = 'RA'
AND ad.ref_customer_trx_Line_Id = cp_customer_trx_line_id;
Above cursor is looking based on customer trx line id which is not populated for pre upgraded receipt applications.
The issue can be reproduced at will with the following steps:
1) Partially Pay pass through/usage invoice before upgrade(Assume $100 invoice, partial pay $40)
2) Upgrade from 11i to R12
3) Pay remaining balance after upgrade(Remaining $60)
4) Run Disbursement Program
5) Disbursement is creating only for $60(for amount applied after upgrade)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms