Rebook Fails With "No Matching Record Found" After The Contract Is Added To Investor Agreement With Rent And Financed Tax (Doc ID 2733949.1)

Last updated on DECEMBER 29, 2023

Applies to:

Symptoms

On : 12.2.7 version

When attempting to rebook a contract associated to an Investor Agreement,
      where the Principal Payment and Interest Payment streams for Financed Upfront Tax have been added to the Pool,
the following error occurs when clicking Submit to process the rebook

ERROR
-----------------------
1.OKL_UNIQUE_KEY_VALIDATION_FAIL
2.Program Error: No Matching Record Found Lease Contract id and contract Line id


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From Lease Super User responsibility, Book a Contract with Financed Upfront Tax.
2. View the streams for the Financed Fee that is billing for Upfront Tax
  to get the Stream Types used for the Principal and Interest Payments.
3. Move to the Stream Type setup and update the Principal and Interest Payment
  Streams to set Stream Type Subclass to Rent for both.
  
  Steps 2 and 3 can be performed before Booking if the Stream Types are known.

4. Add all Streams for the Contract to the Pool.
5. Add the Pool to an Investor Agreement and Activate the Agreement.
6. Bill the contract for at least one period so that Investor Disbursements can get created.
7. Run these programs to generate the Investor Disbursement invoices:

  Create Investor Invoice Disbursements (for the Agreement)
  Investor Payables Consolidation (for the Agreement)
  Pay Invoices Transfer to AP Invoice interface
  Payables Open Interface Import

8. Rebook the Contract and try to process the rebook.
  No changes required during the rebook.
 

Changes

Cause

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