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:

Symptoms

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



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

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.