My Oracle Support Banner

Error : java.sql.SQLException: ORA-01417: a table may be outer joined to at most one other table While Entering Claim Lines (Doc ID 2509812.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Trade Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

While adding lines to claims, unable to enter invoice number in name field as the LOV throws error 

ERROR
-----------------------
'java.sql.SQLException: ORA-01417: 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) Navigate to Trade Management responsibility
2) Go to claims screen
3) Search for claim which has more than 10 lines
4) Go to Claims update page with line details
5) Open a claim and try to add lines
6) While clicking on the LOV for Name at line level, below error pops up

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