My Oracle Support Banner

Transfer and Assumption Details page fails with Oracle.jbo.SQLStmtException JBO-27122 : SQL error during statement preparation (Doc ID 2607618.1)

Last updated on NOVEMBER 05, 2019

Applies to:

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

Symptoms

On : 12.2.4 version, Lease Authoring

In Lease Management, when trying to open the T&A Details it fails with error


ERROR
-----------------------
Oracle.jbo.SQLStmtException: JBO-27122 : SQL error during statement preparation .

Detail 0 ## java.sql.SQLException: ORA-1417: a table may be outer joined to at most one other table


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Lease Center : Create Transfer and Assumption for partial assets
2. Lease Super User> Requests> Search the T&A request
3. When trying to open the T&A Details it fails with error

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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