Home » Developer & Programmer » Forms » FRM-30015: Ambiguous item name using LOV (Forms 4.5, Oracle, XP)
FRM-30015: Ambiguous item name using LOV [message #354142] Thu, 16 October 2008 09:45 Go to next message
Messages: 1
Registered: October 2008
Junior Member
I have two different blocks: member and dup_member with the same items and both are based on the same table. The lov prop_lodge_loc is attached to member.prop_no. I have qualified
all references to prop_no in the dup_member block. Below is error message:

FRM-30015: Ambiguous item name PROP_NO.
FRM-30085: Unable to adjust form for output.

Please help suggest what I should do about the LOV. I don't want to use it in the dup_member and have not referenced it there..at least I can't find where it could be referenced there! Thanks in advance..

[Updated on: Thu, 16 October 2008 09:46]

Report message to a moderator

Re: FRM-30015: Ambiguous item name using LOV [message #354215 is a reply to message #354142] Fri, 17 October 2008 01:15 Go to previous messageGo to next message
Messages: 20850
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you had created column mapping properly (I believe that Wizard might help doing that), Forms would be able to distinguish between two items having the same name (but belonging to different blocks).

So, instead of looking for an error, perhaps you'd solve it faster by creating a new list of values - this time don't type anything by your own, but rather select values suggested in Wizard's lists of values.
Re: FRM-30015: Ambiguous item name using LOV [message #354252 is a reply to message #354142] Fri, 17 October 2008 03:33 Go to previous message
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
If your two datablocks have the same items, these items may have the same names. And if you are referncing prop_no as it is (which means without specifying the the datablock name), this error may occur.
Try to reference your item with the name of the data block.

Previous Topic: create database trigger
Next Topic: image save in blob column with oracle form6i in oracle10g
Goto Forum:

Current Time: Sun Oct 23 03:41:42 CDT 2016

Total time taken to generate the page: 0.14183 seconds