Skip to Main Content
Forums

APEX

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!

Can't get Tree to work as a dynamic menu (even on apex.oracle.com)

phillips_chrisSep 25 2008 — edited Sep 26 2008
Hello,

I'm using a Tree for the first time and have followed the process given in the new 'Pro Oracle Application Express' book.
What I have is a Menus table structured as:

menu_id,
parent_menu_id,
description,
url

a typical entry is: menu_id = 2, parent_menu_id = 1, description = Link Number One, URL = f?&APP_ID.:2:&SESSION.

I've created a form and report on the menus table and I've created the Tree, based on a SQL query and it looks OK. When I created the Tree's Link Options, I chose the Form page, URL column.

The problem is that when I click on a Tree leaf it opens the 'Form on Menu' and sets the URL value to that of the menu_id for that record. Looking at the code below from the Tree component, which is created automatically, that is exactly what it would do! I would have expected it to follow the URL.

select "MENU_ID" id,
"PARENT_MENU_ID" pid,
"DESCRIPTION" name,
'f?p=&APP_ID.:10:&SESSION.::NO::P10_URL:'||"MENU_ID" link,
null a1,
null a2
from "#OWNER#"."MENUS"


Am I missing something, misunderstanding something or is this a bug?

I have recreated the situation on apex.oracle.com
You can log in with the following details:

Workspace: sarasa
Username: phillips_chris@hotmail.com
Password: apex_demo

Thanks,
Chris

Comments

SH_INT
Answer

Why won't your finance team accept the approach of logic accounts? This is the obvious solution to your problem. In FDM or FDMEE you can only load on piece of data to one target intersection. If you want to load the same piece of data to multiple target intersections then you need to have that piece of data repeated in the source data nad then you will still need something in the source that could uniquely identify each of those copies so you could map appropriately. As mentioned that is one of the primary functions of logic accounts, other approaches are likely to be messy, more prone to error and a lot more difficult to audit.

Marked as Answer by MarkSmithHFM · Sep 27 2020
1 person found this helpful
MarkSmithHFM

Hi SH,

Thanks for your reply.

I agree with you 100% that logic accounts are the way to go here.  I was just trying to find out if there were any other approaches that would be relatively straightforward and easy to implement.

Other approaches would definitely not be elegant and would involve scripting and probably rewriting file or copying data records via scripts which to me are non-starters.

You reinforced my opinion.   I'll develop my solution using logic accounts.

Thanks,
Mark

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 24 2008
Added on Sep 25 2008
#apex, #apex-discussions, #tree
6 comments
815 views