My Oracle Support Banner

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.

Symptoms

On : 12.2.5 version, Disbursements

ACTUAL BEHAVIOR
---------------
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.

--OKL_PAY_INVOICES_DISB_PVT.RECEIPT_AMOUNT
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.

STEPS
-----------------------
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)


Changes

 

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!


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