Home » Developer & Programmer » Forms » FRM-41334: Invalid record group for list population
FRM-41334: Invalid record group for list population [message #464027] Mon, 05 July 2010 23:03 Go to next message
jocylau
Messages: 11
Registered: July 2010
Junior Member
I created 3 radio buttons and one list item. Different options will appear according to the radio button the user has clicked on. i've created 3 recordgroups and 3 LOV. the first two for seven_eleven and mannings work fine, but not for GNC. is it because there is only one option for list item in GNC? Must it be more than one? I've tried to another option as space but it still doesnt work.

Please help me to solve the prob. Thanks!

DECLARE

it_id1 item;

V_SEVEN_ELEVEN RECORDGROUP:=NULL;
V_MANNINGS RECORDGROUP:=NULL;
V_GNC RECORDGROUP:=NULL;

BEGIN

it_id1 := find_item('B_DEV.LIST_ITEM');
V_SEVEN_ELEVEN :=FIND_GROUP ('V_SEVEN_ELEVEN');
V_MANNINGS :=FIND_GROUP ('V_MANNINGS');
V_GNC :=FIND_GROUP ('V_GNC');

IF (:B_DEV.FOR_BANNERS = 'SEVEN_ELEVEN') THEN

POPULATE_LIST('B_DEV.LIST_ITEM',V_SEVEN_ELEVEN);

end if;

IF (:B_DEV.FOR_BANNERS = 'MANNINGS') THEN

POPULATE_LIST('B_DEV.LIST_ITEM',V_MANNINGS);

end if;

IF (:B_DEV.FOR_BANNERS = 'GNC') THEN

POPULATE_LIST('B_DEV.LIST_ITEM',V_GNC);

end if;

END;
Re: FRM-41334: Invalid record group for list population [message #464032 is a reply to message #464027] Mon, 05 July 2010 23:38 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
What are the values in the record groups?
V_SEVEN_ELEVEN
V_MANNINGS
V_GNC
Have they populated by any sql statement or static?

By
Vamsi
Re: FRM-41334: Invalid record group for list population [message #464043 is a reply to message #464032] Tue, 06 July 2010 00:42 Go to previous messageGo to next message
jocylau
Messages: 11
Registered: July 2010
Junior Member
i have input static values into the record group
for V_SEVEN_ELEVEN: rmsehk, smsehk
for V_MANNINGS: vmmnhk,ommnhk,qmmnhk
for V_GNC: smghhk
Re: FRM-41334: Invalid record group for list population [message #464656 is a reply to message #464043] Thu, 08 July 2010 11:09 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
The Record Group should have two char columns. Check this.
What are all your Column Names and Column Values for those Record Groups?
V_SEVEN_ELEVEN
V_MANNINGS
V_GNC

Uploading a sample Static Record Group with two columns.
/forum/fa/7984/0/

By
Vamsi
Re: FRM-41334: Invalid record group for list population [message #464698 is a reply to message #464656] Thu, 08 July 2010 20:36 Go to previous messageGo to next message
jocylau
Messages: 11
Registered: July 2010
Junior Member
what if i only have one column as option in list item
can the other one be spacing(empty) instead?

Or are there other ways to solve this problem, please?

Thanks a lot!

Re: FRM-41334: Invalid record group for list population [message #464702 is a reply to message #464027] Thu, 08 July 2010 21:51 Go to previous messageGo to next message
jocylau
Messages: 11
Registered: July 2010
Junior Member
the attachment is the fmb file
could you please check the LOV and recordgroups please?
Thanks
  • Attachment: template.fmb
    (Size: 224.00KB, Downloaded 430 times)
Re: FRM-41334: Invalid record group for list population [message #464704 is a reply to message #464656] Thu, 08 July 2010 22:09 Go to previous messageGo to next message
jocylau
Messages: 11
Registered: July 2010
Junior Member
By the way... there should be only one option for GNC which is SMGHHK. thanks
Re: FRM-41334: Invalid record group for list population [message #464705 is a reply to message #464704] Thu, 08 July 2010 22:16 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
It is giving error while opening the fmb.
Anyway, I'm not talking about the number of values.
You need to concentrate on the number of columns for each Record Group.
Paste your Record Groups, as I did in the previous post.

By
Vamsi
Re: FRM-41334: Invalid record group for list population [message #464706 is a reply to message #464705] Thu, 08 July 2010 22:45 Go to previous messageGo to next message
jocylau
Messages: 11
Registered: July 2010
Junior Member
No Message Body
  • Attachment: untitled.JPG
    (Size: 45.34KB, Downloaded 503 times)
Re: FRM-41334: Invalid record group for list population [message #464707 is a reply to message #464706] Thu, 08 July 2010 23:07 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:
Anyway, I'm not talking about the number of values.
You need to concentrate on the number of columns for each Record Group.
Check my sample once again.
It doesn't bother about the number of values for each column name.
But you should have two column names.

In my sample I can have one value also.
NUMBER - 1
WORDS - ONE.
Here the LOV will be populated by 1 and ONE, NOT NUMBER and WORDS.
Those are just names of the columns.
So, I think your other Records Groups might also be wrongly defined. Crosscheck them once.

In a nutshell, for each of the record group, you need to have two column names, those can be anything like NAME, VALUE or whatever.
But the values vary.

For V_SEVEN_ELEVEN:
NAME - rmsehk, smsehk
VALUE - rmsehk, smsehk

For V_MANNINGS:
NAME - vmmnhk,ommnhk,qmmnhk
VALUE - vmmnhk,ommnhk,qmmnhk

For V_GNC:
NAME - smghhk
VALUE - smghhk

By
Vamsi
Re: FRM-41334: Invalid record group for list population [message #464709 is a reply to message #464707] Thu, 08 July 2010 23:32 Go to previous messageGo to next message
jocylau
Messages: 11
Registered: July 2010
Junior Member
so what did I do wrong?
from my print screen
i did put the following for V_GNC:
NAME - smghhk
VALUE - smghhk
Re: FRM-41334: Invalid record group for list population [message #464714 is a reply to message #464709] Fri, 09 July 2010 00:27 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
You got me wrong.
Check this screen.
/forum/fa/7990/0/
Try this (for all the three record groups) and let me know, whether it is working or not.

By
Vamsi
Re: FRM-41334: Invalid record group for list population [message #464719 is a reply to message #464714] Fri, 09 July 2010 01:13 Go to previous messageGo to next message
jocylau
Messages: 11
Registered: July 2010
Junior Member
it works now. Thank you so much.
Re: FRM-41334: Invalid record group for list population [message #464721 is a reply to message #464719] Fri, 09 July 2010 01:19 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Just wanted add one point.
The reason to have two sets of column "names" and "values" is: because LOV is having id and value.
Even though the set of values are same for id and value of LOV, you need to have two sets in record group.

By
Vamsi
Re: FRM-41334: Invalid record group for list population [message #677028 is a reply to message #464721] Thu, 08 August 2019 03:40 Go to previous messageGo to next message
Rehman_Mani
Messages: 1
Registered: August 2019
Junior Member
Hi my question is same related this problem i m create MAKE_LIST throug procedure in program unit butt form runtime eror is FRM 41334:

PROCEDURE MAKE_LIST IS

group_id RecordGroup;
group_name varchar2(10) := 'abc';
status number;
begin

group_id := find_group(group_name);
if not id_null(group_id) then
delete_group(group_id);
end if;
group_id := Create_Group_From_Query(group_name,'select lookup_det_name from PRL_lookup_det where lookup_id = ''116'' and active=''Y''');
status := Populate_group(group_id);
Populate_List('PRL_VEHICLE_DATA.MANUFEC_BY',group_id);
END;
Re: FRM-41334: Invalid record group for list population [message #677047 is a reply to message #677028] Mon, 12 August 2019 05:23 Go to previous message
cookiemonster
Messages: 13648
Registered: September 2008
Location: Rainy Manchester
Senior Member
As mentioned earlier in the thread record groups for list items need two columns - one for the value displayed and one for the value stored.
Your record group query only selects one column.
If you want the same value displayed and stored then select it twice.
Previous Topic: How to change Form 6i default icon to a company logo
Next Topic: Runaway sessions cpu infinite loop
Goto Forum:
  


Current Time: Sat Aug 24 14:52:25 CDT 2019