Home » Developer & Programmer » Forms » Template.fmb (Oracle Database 10g Express Edition Release , windows 7)
Template.fmb [message #605314] Wed, 08 January 2014 12:07 Go to next message
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
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 183 times)
Re: Template.fmb [message #605333 is a reply to message #605314] Wed, 08 January 2014 14:04 Go to previous message
Messages: 21148
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).
Previous Topic: Getting ORA-12154: TNS error when running a form
Next Topic: How to create demo version of application using Oracle Form 6i
Goto Forum:

Current Time: Sat Aug 19 15:47:51 CDT 2017

Total time taken to generate the page: 0.09959 seconds