Template.fmb [message #605314] |
Wed, 08 January 2014 12:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/177954.jpg) |
thelearner
Messages: 133 Registered: April 2013 Location: INDIA
|
Senior Member |
|
|
Hi i am trying to develop a new form using Template.fmb
I given resource path in Registry...
I given all properties to items,blocks and canvases..
While compiling I am getting below errors...
FRM-30064: Unable to parse statement select timezone_code,name
,to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') offset
,decode(daylight_savings_flag,'Y','*',null) dst_flag
from fnd_timezones_vl
where enabled_flag = 'Y'
order by gmt_offset.
ORA-00942: table or view does not exist
Record Group TIMEZONES
Form: DEPT_EMP
FRM-30085: Unable to adjust form for output.
while trying to delete it was showing FRM-15110:Can't delete...
please tell me how to resolve this issue.
Thanks in Advance.
-
Attachment: error.jpg
(Size: 26.95KB, Downloaded 1000 times)
|
|
|
Re: Template.fmb [message #605333 is a reply to message #605314] |
Wed, 08 January 2014 14:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
User you connected to when starting Forms Builder doesn't contain / see FND_TIMEZONES_VL table (or view).
Who owns it? Ask the person (who provided TEMPLATE.FMB) to explain who is supposed to own that table. If "you", then he should provide CREATE TABLE as well as INSERT INTO statements. If it is "someone else", you have to acquire (at least) SELECT privilege from the owner; furthermore, you need to create a synonym for that object (a better option), or the owner should create a public synonym (a worse option).
|
|
|