Oracle FORM Personalization to make DFF Mandatory / Oracle FORM Personalization to creating DFF Mandatory

Making DFF Mandatory using Oracle Form Personalization: In Oracle R12:


Scenario: Solution:







Above Condition SQL Code:


:HEADER.USER_JE_SOURCE_NAME = 'Manual' and
:HEADER.SHOW_TAX_STATUS = 'Not Required' and
(SUBSTR(:LINES.ACCOUNTING_FLEXFIELD,11,6) IN ('113330','122235')) and
:LINES.CONTEXT is null




Creating the Scenario to test Personalization:









Here in above screen, I provided the all the required values so that it will not generate any error.
Below screen will generate the error.






Here in above screen second circle, provided the value for DFF and last field DFF value is empty, so that above error generated.