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!

How to reference master IG columns when validating detail IG?

Eslam_ElbyalyJul 25 2019 — edited Jul 29 2019

Apex 18.2.

hi,

I have a page with a master-detail interactive grids.

master ig columns : (id pk, si_id, si_type_id).

detail ig columns : (....., qty).

- I created a validation on the detail ig with type of "function that returns an error text". My code is based on the value of si_type_id column in the master ig but unfortunately, it does not see the if statement.

If TO_NUMBER(:SI_TYPE_ID) = 1

then

............

return 'quantity is greater than the original quantity';

end if;

Is it normal for Apex not to see a column in another ig other than the one I am validating?

Comments
Post Details
Added on Jul 25 2019
6 comments
468 views