OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Need to make my forms Read Only

Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to make my forms Read Only (Oracle Apps /12i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to make my forms Read Only [message #551984]

Mon, 23 April 2012 01:49

maggy_ashee
Messages: 70
Registered: May 2007

Member

Hi Team,

When I log Responsibility 'AAA', I need all my forms/some of my forms to Open in 'Read Only' mode. Can you please suggest me some idea to acheive this functionality.

Thanks

Report message to a moderator

Re: Need to make my forms Read Only [message #551998 is a reply to message #551984]

Mon, 23 April 2012 02:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know how Oracle Apps. does that, but pure Forms have several options.

One is to call a form using its QUERY_ONLY parameter. For example, URL would look like this:

http://myserver/forms90/f90servlet?form=MODULE1.fmx&query_only=YES

Or, if you use CALL_FORM, include QUERY_ONLY parameter:

CALL_FORM('empbrowser', no_hide, no_replace, query_only);

Or, in WHEN-NEW-FORM-INSTANCE trigger, use SET_BLOCK_PROPERTY and set INSERT_ALLOWED, UPDATE_ALLOWED and DELETE_ALLOWED to FALSE:

Set_Block_Property('your_block', INSERT_ALLOWED, PROPERTY_FALSE);

Report message to a moderator

Re: Need to make my forms Read Only [message #552017 is a reply to message #551998]

Mon, 23 April 2012 03:41

maggy_ashee
Messages: 70
Registered: May 2007

Member

Hi Guys,

Thanks for your inputs however I would like to restrict it in Function level.I.e in Application devloper --> Application--> Function.

Report message to a moderator

Re: Need to make my forms Read Only [message #552021 is a reply to message #552017]

Mon, 23 April 2012 03:44

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

I have no idea what that means.

Report message to a moderator

Re: Need to make my forms Read Only [message #552025 is a reply to message #552021]

Mon, 23 April 2012 04:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This must be Oracle Apps. voodoo; I don't speak it either.

@maggy_ashee, if you wish, this topic can be moved into the Oracle Apps. forum. Hopefully, someone will be able to answer your question.

Report message to a moderator

Re: Need to make my forms Read Only [message #552058 is a reply to message #552025]

Mon, 23 April 2012 06:36

maggy_ashee
Messages: 70
Registered: May 2007

Member

Oh ok, can you please move it to Oracle Apps then...

Report message to a moderator

Previous Topic:	Distribution set
Next Topic:	Need to find forms Username

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 05:28:08 CST 2024