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.


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

'java.sql.SQLException: ORA-01417: a table may be outer joined to at most one other table'

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


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.