" java.lang.StringIndexOutOfBoundsException:String index out of range: -1" Exception Encountered on Advanced Layouts Error When Linking Screens Via Saved Query (Doc ID 1909200.1)

Last updated on JUNE 02, 2017

Applies to:

Oracle Transportation Management - Version 6.2.0 and later
Information in this document applies to any platform.

Symptoms

An Advanced Layout is created that links two screensets together via a Saved Query. When using this Advanced Layout and selecting a row from parent screenset, the following error is encountered:


ERROR
-----------------------
java.lang.StringIndexOutOfBoundsException:String index out of range: -1
Server Exception during PPR. For more information please check the log files

 

EXAMPLE:The following illustrates an example configuration:

Created an Advanced Layout that includes Buy Shipments and their related Order Releases using the following Saved Query on the Order Release table that links back to the Shipment table:

Query Type: Order Release
Check One SQL: select order_release_gid from view_shipment_order_release where shpiment_gid=?
Find All SQL: select order_release_gid from view_shipment_order_release where shpiment_gid=?




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms