Oracle Form (Unable to update data)
Let me explain what is happening.
I have developed a form using DEV6i . Is a simple insert, update and delete form.
Database Properties set as follow:
Database Data Block = Yes
Query Allowed = Yes
Query data Source Type = Table
Query DataSource Name = APLAPPS.GL7E_MAPACCOUNTS (customized table).
where Clause = WHERE SET_OF_BOOKS_ID = Fnd_Profile.VALUE('GL_SET_OF_BKS_ID')
Insert Allowed = Yes
Update Allowed = Yes
Locking Mode=Automatic
Delete Allowed= Yes
Database Advance properties set as follow:
DML dataTarget Type = TABLE
After uploaded and compiled it in a TEST instance, form works perfectly fine, I'm able to insert records, query them (F11), update them and delete them also.