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 179 times)
Re: Template.fmb [message #605333 is a reply to message #605314] Wed, 08 January 2014 14:04 Go to previous message
Messages: 21122
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: MONTHS_BETWEEN problem in Oracle Form 6i
Next Topic: I want to show movable image on form like data loding symbol
Goto Forum:

Current Time: Sun Jun 25 14:17:21 CDT 2017

Total time taken to generate the page: 0.04142 seconds