My Oracle Support Banner

Trading Partner Form ECETPDEF Rise Error When Long EDI Location Used (Doc ID 2561399.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle EDI Gateway - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, EDI Gateway

When setting up trading partner and when long EDI location used in Assignment form when trying
to select customer site or Supplier Site with long edi location code error occurs

ORA-01403 no data found.
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502.

The issue can be reproduced at will with the following steps:
1. Trading Partner form for assignments and for RA customer Site Addresses
2. The EDI Location field shows very long EDI Location Code for the one aaddress
3. When edi location is change to shorter – just to be able to proceed with set up
  and then adjusted back on customer site to long value again – such line is not visible
  from the front end, while its in DB


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.