Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hierarchical Tree Populating Issue

Muhammad RabieDec 15 2016 — edited Dec 20 2016

I am using Oracle Forms 11g (11.1.2.1.0), issue is tree is not populating when form is call from another form, but its working when call from menu or direct form calling..

populate tree procedure

PROCEDURE populate_tree IS

htree item;

var varchar2(30);

node ftree.node;

BEGIN

htree := find\_item('tre\_blk.menu\_tree');

var := populate\_group('menu\_tree\_rg');

ftree.set\_tree\_property(htree,ftree.record\_group,'menu\_tree\_rg');

ftree.populate\_tree(htree);

END;

menu_tree_rg RECORD GROUP

pastedImage_0.png

select -1,1,'Daily Transaction Confirmation' opt_desc,null,'CON' opt_id from dual

union all

select -1,1,'Client Open Position' opt_desc,null,'COP' opt_id from dual

union all

select -1,1,'Inventory Position' opt_desc,null,'CDC' opt_id from dual

union all

select -1,1,'Statement Of Account' opt_desc,null,'LED' opt_id from dual

union all

select -1,1,'Broadcast Email' opt_desc,null,'BEM' opt_id from dual

union all

select -1,1,'Email Files' opt_desc,null,'EMF' opt_id from dual

union all

select -1,1,'CGT Charges' opt_desc,null,'CGT' opt_id from dual

union all

select -1,1,'NIC Expiry Alert' opt_desc,null,'NIC' opt_id from dual

union all

select -1,1,'Customized Letters' opt_desc,null,'LET' opt_id from dual

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2017
Added on Dec 15 2016
3 comments
570 views