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!

IG Column make readonly and update

RajeshAlexApr 17 2024

Hi All,

We are on Apex 22.1.0.

I have an IG based on table EMP.

I want the salary column as read only, but I need to automatically populate the salary from another table when a new record is created and based on the department value. Once this is done, I need to make the column readonly.

What I have done is , I created a dynamic action on the Department field and use PLSQL to populate the salary field.

By default I set the field as read only and then I use a javascript to remove read only and the populate salary value.

This works fine, however I get below error once in a while

Uncaught TypeError: Cannot read properties of null (reading '35')
at Object._getIdentity (interactiveGrid.min.js?v=22.1.0:1:41962)
at Object.getRecordId (interactiveGrid.min.js?v=22.1.0:1:17896)
at q.<computed>.<computed>._setModelValue (interactiveGrid.min.js?v=22.1.0:6:21656)
at a.<computed> [as _setModelValue] (desktop_all.min.js?v=22.1.0:29:2891)
at q.<computed>.<computed>._deactivateCell (interactiveGrid.min.js?v=22.1.0:7:69986)
at a.<computed> [as _deactivateCell] (desktop_all.min.js?v=22.1.0:29:2891)
at q.<computed>.<computed>.focusin (interactiveGrid.min.js?v=22.1.0:7:16834)
at HTMLDivElement.i (desktop_all.min.js?v=22.1.0:29:8316)
at HTMLDivElement.dispatch (desktop_all.min.js?v=22.1.0:2:43064)
at v.handle (desktop_all.min.js?v=22.1.0:2:41048)

Thank You

Alex

This post has been answered by Karel Ekema on Apr 19 2024
Jump to Answer
Comments
Post Details
Added on Apr 17 2024
10 comments
896 views