Disbursement Issue for Partially Paid Upgraded Invoices

(Doc ID 2350808.1)

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,
  ar_distributions_all ad
 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