My Oracle Support Banner

Review Until Date Causes Errors In Billing Setup T&C "You have encountered an unexpected error" (Doc ID 2885397.1)

Last updated on JULY 25, 2022

Applies to:

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


On : 12.2.10 version, Lease Authoring

Find that there are 2 issues with the Review Until Date in Billing Setup T&C:

1. The review until date is not being passed in the correct format from the quote interface. The date is created as YYYY/MM/DD without the time stamp in rule information2 on okc_rules_b. This causes the Billing Setup T&C to error with the following until the date on okc_rules_b is updated.

You have encountered an unexpected error. Please contact your system admin for assistance.

2. When updated the Review Until Date through the html page, it is not displayed correctly in the Leasing T&C's

For eg: updated the date to 1-Jul-2022 but the UI displayed 1-Jan-2022.

Expect the correct date to be displayed.

The issue can be reproduced at will with the following steps:
1. Using SQL developer, populate the columns in OKL_HEADER_INTERFACE table and include Review Until Date.
2. Using lease administrator responsibility, run the contract import process.
3. Once contract is created, navigate to Lease and check the Billing Setup T&C and observe the Review Until Date.




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.