Technology Stack - EBS (MOSC)

MOSC Banner

how to make row in table readonly based on column value

edited Aug 20, 2021 10:58AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hi Sir,

   Lets say I have table with following values

order#       cust_address   status             qty

100          123 main st       New                 3

101           111 joe st         Closed             4

102           112 main dr      Open               5

--------------------------------------------------------------

My requirement is , when I get these records in oracle form10g, I need to make sure "Closed" status record is only display only and other than Closed status records should be editable.

On implementation I perform following task

     In when-form-instance , I wrote , execute_query;

     Then in post_query I set property to Update property to false .

It's not working the way I need.

-------------------------

Then I put execute_query at block level and use pre-block or post-block to set Update property for that row items as false. it's not working.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center