Skip to Main Content

APEX

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!

Interactive Grid - Column - Not Updatable by User - But updatable through DA

user11993880Aug 5 2021

We are in Application Express 20.2.0.00.20.
I have two regions.
Example: Dept (Master)
Emp (Detail)
Whenever the user clicks on the Department region record, detailed employee region Interactive Grid data will get a refresh.

I have the following requirement on detail region.

  1. Commission column is not updatable/enterable by the user.
  2. Commission column is calculated based on the department selected on each record of the employee.
  3. I should be able to save this entire record.

When I disable the commission column, the value is not getting saved into the database.

I tried using multiple Dynamic Action events to enable and disable the Commission field, but still, time the value of the Commission not getting saved into the database.

I have seen a couple of posts on making display field and Hidden field combinations and it doesn't seem to be working in this version.

Please share.

Comments
Post Details
Added on Aug 5 2021
4 comments
435 views