Home » Developer & Programmer » Forms » FRM-30047
FRM-30047 [message #336714] Mon, 28 July 2008 14:37 Go to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Hi,

I have Form and I change the name of one of text item on that. I try to change the old name to new name in everywhere that needs. But I still get this error:

FRM-30047: Cannot resolve item reference CTRL_DB.ZIP_X2.
LOV CODE_LOV

Please advise.

Thanks in advance
Re: FRM-30047 [message #336724 is a reply to message #336714] Mon, 28 July 2008 15:39 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So did you check what items are referenced in the "code_lov" list of values? One of them must still be wrong.

How to do that? Open LoV's Property Palette, go to "Column Mapping Properties" and see what's in there.
Re: FRM-30047 [message #337034 is a reply to message #336724] Tue, 29 July 2008 13:28 Go to previous messageGo to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Thanks for your reply. I checked that but still I have same error.
Re: FRM-30047 [message #337050 is a reply to message #337034] Tue, 29 July 2008 14:20 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, if Oracle says that it "Cannot resolve item reference CTRL_DB.ZIP_X2", I'd say that it is not lying. So - did you check VERY carefully?

By the way, try to recompile the form (Ctrl + Shift + K); it will probably not help, but won't cost much to do it.

Also, you may attach the FMB file to your next message so that we could take a look.
Re: FRM-30047 [message #338662 is a reply to message #337050] Tue, 05 August 2008 10:29 Go to previous messageGo to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Hi,

I found out that I am getting this error because of one of the field of Record Group Query. The field is:

to_char(NVL(min_t,0), '$9,999,999.99') c

However I could not find anything wrong with this field. Please advice.

Thanks
Re: FRM-30047 [message #338690 is a reply to message #338662] Tue, 05 August 2008 11:49 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How did you find that out? As it looks, it has nothing to do with an error you have reported in the first message.
Re: FRM-30047 [message #338691 is a reply to message #336714] Tue, 05 August 2008 11:53 Go to previous messageGo to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
I just take out TO_Char function from that column and then recompile the form again and error not comes up any more. Please advice.
Re: FRM-30047 [message #338692 is a reply to message #338691] Tue, 05 August 2008 12:04 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Was it the "invalid number format model" error? Such as in this example (note use of decimal point and thousands separator):
SQL> select to_char(123, '$9,999.99') c from dual;

C
----------
   $123.00

SQL> select to_char(123, '$9.999,99') c from dual;
select to_char(123, '$9.999,99') c from dual
                    *
ERROR at line 1:
ORA-01481: invalid number format model


SQL>

If so, try to restore the previous form of this column in the Record Group's query, but use G (as thousands) and D (as decimal point) separators, such as
SQL> select to_char(123, '$9G999D99') c from dual;

C
----------
   $123.00

SQL>

If that's the point, then the answer might be in wrong use of current NLS settings.
Re: FRM-30047 [message #338699 is a reply to message #336714] Tue, 05 August 2008 13:06 Go to previous messageGo to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
No, it does not have any Error about To_Char conversion. I have just error FRM-30047 and I do not know why To_Char make this error. Please advice.
Thanks
Re: FRM-30047 [message #338727 is a reply to message #338699] Tue, 05 August 2008 18:35 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Using that lov and record group, does lov return that value into your block's item? check the item's data type and format.
Just my small idea. Razz
Re: FRM-30047 [message #339001 is a reply to message #336714] Wed, 06 August 2008 08:08 Go to previous messageGo to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Hi,

No the LOV does not return value to block. Also I found out that I can use TO_CHAR (NVL(min_c,0)) without mask and this is working fine without error but when I put '$9,999,999.99' mask in TO_CHAR function then I am getting error message. Is it anything wrong with this mask? Please advice.

Thanks
Re: FRM-30047 [message #339111 is a reply to message #339001] Wed, 06 August 2008 15:32 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just being curious: did you, at least, try to modify the format mask from
$9,999,999.99
to
$9.999.999,99
or even
$9G999G999D99
Re: FRM-30047 [message #339124 is a reply to message #336714] Wed, 06 August 2008 17:53 Go to previous message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Hi All,

I found the problem. The problem was when TO_Char call will format mask, it will return the very big Char value and RG does not like that I just change that with:
CAST (to_char(NVL(min_t,0), '$9,999,999.99') AS VARCHAR(15))

And this is working find without any error.

Thank you to all
Previous Topic: WHAT IS FRM
Next Topic: FRM-92102 Can you Help my
Goto Forum:
  


Current Time: Wed Dec 07 20:43:07 CST 2016

Total time taken to generate the page: 0.18798 seconds