Home » Developer & Programmer » Forms » Template.fmb (Oracle Database 10g Express Edition Release 10.2.0.1.0 , windows 7)
Template.fmb [message #605314] Wed, 08 January 2014 12:07 Go to next message
thelearner
Messages: 122
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 73 times)
Re: Template.fmb [message #605333 is a reply to message #605314] Wed, 08 January 2014 14:04 Go to previous message
Littlefoot
Messages: 19694
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: Thu Oct 23 12:19:43 CDT 2014

Total time taken to generate the page: 0.13496 seconds