Home » Developer & Programmer » Forms » problem with inserting through forms in oracle apps (template.fmb)
problem with inserting through forms in oracle apps (template.fmb) [message #291080] Wed, 02 January 2008 23:27 Go to next message
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
Problem 1: I am working on oracle forms. but I was wondering how to insert data through forms.
I have designed one PO define form in purchasing which is based on couple of views out of which PO_HEADERS_V view is one.
now when I am trying to insert through form it is giving me one error " cannot modify a column which maps to a non key-preserved table". this is quite obvious since we are dealing with complex view where inserting data is difficult.
I guess apps must be using some INSTEAD OF triggers. I checked the database using

select * from ALL_triggers
where trigger_name like '%PO%'
and trigger_type like '%INSTEAD%'
But nothing is there.

So, my question is how to develope a form which will insert data in views?

Problem 2: Also which compiling my form after I add Query find feature, its not compiling, giving the error as
bad bind variable "parameter.G_query_find"
I guess its because of FORM60_PATH in registry (APPSTAND.fmb might not be getting). But it is correct. I have given the resource folder path there.
What could be the problem.
Re: problem with inserting through forms in oracle apps (template.fmb) [message #291086 is a reply to message #291080] Thu, 03 January 2008 00:01 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check this and this.
If at all the parameter is exists in your form, you can have a look at Metalink.

[Updated on: Thu, 03 January 2008 00:46]

Report message to a moderator

Previous Topic: ora-01779: can't modify a column which maps to nonkeypreserved. when i am inserting.
Next Topic: Proplem in storing data and time in the field
Goto Forum:

Current Time: Wed Mar 01 12:07:11 CST 2017

Total time taken to generate the page: 0.10900 seconds