Forum Stats

  • 3,873,118 Users
  • 2,266,506 Discussions


add Validation when inserting in ADF table

User_7TK0D Member Posts: 11 Green Ribbon
edited Aug 23, 2022 4:18PM in JDeveloper and ADF


I need some help.

I'm a newbie and I'm using JDeveloper

How can I add validation in ADF table when inserting? My requirement was if the status of the person number is NEW and PENDING with same cycle, it will not insert to avoid duplication and it will insert only if the status is already set to PROCESSED

For example,

The UI page

clicked the create button

after inputting the data, when I click save button it should not insert because the person number and the cycle is already existing the table

This is the functionality of the buttons

Thank you.

Best Answer