| Template.fmb [message #605314] |
Wed, 08 January 2014 12:07  |
 |
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 1053 times)
|
|
|
|
| Re: Template.fmb [message #605333 is a reply to message #605314] |
Wed, 08 January 2014 14:04  |
 |
Littlefoot
Messages: 21823
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
