3 Replies Latest reply: Mar 4, 2014 4:37 PM by Jackie Han RSS

How to restrict code combination values of KFF in OAF?

Jackie Han Explorer
Currently Being Moderated

Dear All,


I have KeyFlexField with three segments  in Advanced Table region on OA page, when we click on KFF field, it is allowing us to search combinations with provided segments.

I want to restrict those combinations based on disable date(Inactive ON), that means if combination is inactive then particular combination should not come when we click on search of KFF field.


I am using Oracle9i Jdeveloper(version 1453)). Front end Oracle Applications Extension( - build 1570)

Database - Oracle Database 11g Enterprise Edition Release


My requirement is to restrict codecombination values based on Disable date(Inactive) records. Inactive Code combination values also coming when we perform search on KFF field.


Please help to suggest.




  • Correct Answers - 10 points
  • Helpful Answers - 5 points