Forum Stats

  • 3,873,100 Users
  • 2,266,505 Discussions
  • 7,911,423 Comments

Discussions

add Validation when inserting in ADF table

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

Hello,

I need some help.

I'm a newbie and I'm using JDeveloper 12.2.1.4.0.

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

Answers