DETAIL BLOCK SHOWS TOO MANY RECORDS FOR THE MASTER BECAUSE OF UNDERSCORE (Doc ID 1018370.6)

Last updated on FEBRUARY 27, 2019

Applies to:

Symptoms

If you create a master/detail relationship in which the master block contains
records that have similar values except for a differentiating "-" and "_"
when you query the record with the "_" it will show the detail records for
both master records.

See Example:

In sqlplus:
create table my_dept
( name varchar2(10),
version number);

create table my_dept_detail
( name varchar2(10),
version number,
seq number);

commit;

In Forms:
Create a form bbb.fmb
master block my_dept which is multi record
detail block my_dept_detail which is multi record
joined by name and version

In the master block create
one record with name bbb_1 and version 1
in the detail block I created 3 records with seq 9, 10, 11

Then create another master record with name bbb-1 and version 1
and 3 detail records with seq 1,2,3

When queried the master record with name bbb_1, will show detail records with
seq 1,2,3,9,10,11.

Cause