OraFAQ Forum: Forms » Unable to resolve reference

Home » Developer & Programmer » Forms » Unable to resolve reference - checkbox issue (Oracle Forms : 12c (12.2.1.4.0);Fusion Middleware: fmw_12.2.1.4.0 and O/S: Windows 10 pro 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to resolve reference - checkbox issue [message #680105]

Tue, 21 April 2020 16:29

buggleboy007
Messages: 282
Registered: November 2010
Location: Canada

Senior Member

I am facing a peculiar issue wherein on a form, there is a check box. I need to delete this check box and replace it with a new one.

So here's what I did:

a) commented the checkbox code where ever it is referenced in the form and it's underlying library.
b) compiled the library and then attached it to the form. Compiled the form and implemented it. No issues.Was able to open the form with no issues.
c) now deleted the check box (this check box is a database item) and then compiled it. Compiled the form and implemented it. No issues.
d)The minute I open the form I see a message that says:

Code: [Select all] [Show/ hide]

FRM-40105: UNABLE to resolve reference to item SGNR.store_from_warehouse_ind.

I have searched for this field umpteen times in the form and it's underlying library. I see that they have all been commented by me. I am unable to fix this issue.

I googled too and all roads lead to Rome - most of the links suggest that I need to see if there is any reference to this field/checkbox and as I said it's commented.

What could be the issue?

Report message to a moderator

Re: Unable to resolve reference - checkbox issue [message #680109 is a reply to message #680105]

Wed, 22 April 2020 02:58

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

From memory search only looks in PL/SQL code in triggers and libraries.
It doesn't search property pallets.
So I assume it'll be in one of those somewhere.
I think you're just going to have to hunt it down the hard way.

Report message to a moderator

Re: Unable to resolve reference - checkbox issue [message #680111 is a reply to message #680109]

Wed, 22 April 2020 06:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Open the .FMB file in a text editor (yes, it'll look ugly) and search for "store_from_warehouse_ind" (or whatever you're searching for). If it is part of some SQL statement, it'll be readable. If not, you'll - at least - know that it is somewhere in the form itself.

Report message to a moderator

Re: Unable to resolve reference - checkbox issue [message #680112 is a reply to message #680111]

Wed, 22 April 2020 06:04

buggleboy007
Messages: 282
Registered: November 2010
Location: Canada

Senior Member

Littlefoot wrote on Wed, 22 April 2020 06:00

Open the .FMB file in a text editor (yes, it'll look ugly) and search for "store_from_warehouse_ind" (or whatever you're searching for). If it is part of some SQL statement, it'll be readable. If not, you'll - at least - know that it is somewhere in the form itself.

You mean to say open the .fmb file and when opened it should not be in binary format, after which run a search for the 'interested' string? If so, yes, this one and also what CookieMonster suggested to me are two things that will be done today. I will update this post once I have some results.

Report message to a moderator

Re: Unable to resolve reference - checkbox issue [message #680126 is a reply to message #680112]

Wed, 22 April 2020 13:22

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It will be in binary format, but text editor can search through it anyway (at least, my "Notepad++" can), as all queries are kind of "readable".

Report message to a moderator

Re: Unable to resolve reference - checkbox issue [message #680127 is a reply to message #680126]

Wed, 22 April 2020 15:10

buggleboy007
Messages: 282
Registered: November 2010
Location: Canada

Senior Member

Thanks Littlefoot and CookieMonster. This morning the problem resolved itself magically, in that the requirements were not clear. I once again clarified that with BA and she told me that all I have to do is just replace the name. I went through the requirements document and it was not worded this way (neither was the mock up). It always said 2 new check boxes. Wasted my 8 hours and a few minutes of both of you.

Regardless, both of your suggestion will be valuable should this happen in the future.

Thanks a lot.

Report message to a moderator

Previous Topic:	Navigate to next record of tabluar
Next Topic:	How to get distinct record values after query in form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 12:29:18 CDT 2025