| problem with inserting through forms in oracle apps (template.fmb) [message #291080] |
Wed, 02 January 2008 23:27  |
parag_narkhede
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
