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!

FRM-10247 : No active item set for root menu + Multi-instance

741795Jan 15 2010 — edited Jan 15 2010
Hi everybody ;

I get an issue when I try to do multi-instance Forms 6i application (Oracle 9i R2).

I explain. I have two instance A & B, I have a table in A instance which contains an environnement schema ENV.
In this schema there is a table ENV, in this table there is a column named "instance" (values = "A" or "B")

But when i launch the application on the first initial instance "A" with user granted all is alright but when i want to change for a B's user schema. I get this error FRM-10247.

What are the grants to check, with which users ? What informations do you need to fix this issue ?

Thank you for reading, help me please :(

PS2: I have run the frm60sec.sql as system on the "B" instance.
PS: I created "datalinked synonyms" from "B" to "A" with user ENV connection. I can update,select etc. on the ENV's tables in instance "A". (Sweet :))
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 12 2010
Added on Jan 15 2010
1 comment
1,776 views