Skip to Main Content

add Validation when inserting in ADF table

User_7TK0DAug 23 2022 — edited Aug 23 2022

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
image.pngclicked the create button
image.pngafter inputting the data, when I click save button it should not insert because the person number and the cycle is already existing the table
image.pngimage.png
This is the functionality of the buttons
image.png
Thank you.

This post has been answered by Timo Hahn on Aug 23 2022
Jump to Answer
Comments
Post Details