My Oracle Support Banner

Variable Rate Contract - Back-dated Termination Error -The Date You Entered Is Not In An Open Period (Doc ID 2465764.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Lease and Finance Management - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Asset Management

When attempting to perform a backdated termination on a Variable Rate contract,
the following errors occur in the Termination Transaction Messages:

Error while retrieving common accrual information.
Program Error: An unexpected error was encountered.

Error code - -1086
Error message - ORA-01086: savepoint 'adjust_var_int_accruals_PVT' never established in this session or is invalid
ORA-06512: at ""APPS.OKL_API"", line 73
ORA-06512: at ""APPS.OKL_AM_LEASE_TRMNT_PVT"", line 8561
ORA-06510: PL/SQL: unhandled user-defined exception

Action: Contact your system administrator.

The issue can be reproduced at will with the following steps:
1. Book, Bill and Accrue a Variable Rate Contract.
  The Product used on this contract must be a Multi-GAAP Product
  and the Primary Financial Product should list more streams to be
  accrued than the Reporting Product.
2. After billing and accruing for some months those periods should be
  closed as would occur naturally over the life of the contract.
4. Attempt to process a termination quote using an effective date
  that is a couple periods prior to the last accrued period, and within
  one of the closed periods.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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