Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Make Custom Form As Read Only

miro_fepsFeb 20 2017 — edited Mar 1 2017

Hi,

I've a custom Form which want to add it to New Read Only Resposnbility

I created New Function to the same form , added the parameter QUERY_ONLY=YES , when user press new button nothing is created , but when he query he's able to update the values & insert

How can i make this form totally Query Only "Not Updateable , or inserting "

Thanks

This post has been answered by miro_feps on Mar 1 2017
Jump to Answer

Comments

Matej D.

Use set_block_property.

For example:

Set_Block_Property('myblock',UPDATE_ALLOWED,PROPERTY_FALSE);

Set_Block_Property('myblock',DELETE_ALLOWED,PROPERTY_FALSE);

Set_Block_Property('myblock',INSERT_ALLOWED,PROPERTY_FALSE);

Set_Block_Property('myblock',QUERY_ALLOWED,PROPERTY_TRUE);

Regards

Manu.

Dear,

Set block's Insert Allowed, Update Allowed and Delete Allowed property to No.

Manu.

miro_feps

this means i've to modify the Form itself !!! , cause i want this form for all resposnbilities to be editable Except this read Only Responsibility

NOTE : i tried to make that through personalization by making this block (Insert,update,delete) FALSE , but it's still updating

Andreas Weiden

You have a custom form, why can't you change it then? As far as i remember when defining a function in eBusiness-suite, you can define additional parameters which should be passed to the form. So create one named "Readonly".Instead of one function, create two calling the same form, but passing different values for your parameter. In Forms in the PRE-FORM-trigger check the value for that parameter and use the already shown statements to disable block-operations.

miro_feps

i wanted to do that through making that new function with same form & adding the parameter QUERY_ONLY = YES or personalization because i need to add multiple custom forms that is why i don't want to go to form level and make changes on than then again registering form & new functions .

miro_feps

i tried both ways

1- when i made the QUERY_ONLY=YES , not making new but when query and open the form it's editable .

2- when i make personalization it's not disabling also .

Sanjay Desai EBS

Can you just send screen shot having  parameters you have set at function level ?

miro_feps

Below is screenshots for the below :

1- Function description

1.jpg

2- Function Parameter

2.jpg

3- the Custom Form After Doing the query

3.JPG

Sanjay Desai EBS

I think your setup seems to be ok.

Can you go thru personalization to set the property update_allowed, inset allowed & delete_allowed false at block level ?

miro_feps

I tried that also but still the form is editable

Any idea what i can trace inside the form itself that can be stopping the form to be as query only !!

John_K

1) The form will only support the QUERY_ONLY parameter if it has been developed to do so. As it's custom, you're not guaranteed that.

2) If you want a form to be query-only then I'd suggest doing it this way rather than personalizations. With a personalization you'll need to update them any time a new block is added to the form.

miro_feps
Answer

Hi ,

I just solved that thanks

We need to do the following

1- Edit the form itself & use that parameter 'QUERY_ONLY' for validation  in the WHEN-NEW-FORM-INSTANCE

2- Add the validation if this parameter is YES then we make all blocks (insert,update,delete) Block property with FALSE & IF Parameter Not YES we make all blocks (insert,update,delete) Block property with TRUE

Thanks ALL

Marked as Answer by miro_feps · Sep 27 2020
Kalpataru

Close the thread by marking it as answered.

1 - 14
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 29 2017
Added on Feb 20 2017
14 comments
3,130 views