PS QUERY – Tree prompt on Business Unit impedes lookups

Hello -

I would like to take advantage of the new tree prompt feature on the field Business Unit in a query. The problem is that when I use the tree prompt, my other prompts on ledger and account do not return values.

The problem is easy to demonstrate in demo. Here are the steps:

1.       Create a new query

2.       Select the LEDGER record

3.       Select all fields

4.       Add a prompt on the field LEDGER (prompt table LED_DEFN_TBL)

5.       Add a prompt on ACCOUNT (prompt table GL_ACCOUNT_TBL

6.       Add a Tree Prompt on Business Unit (In Tree… Tree Prompt Option)

7.       Run the query