The desired functionality cannot be achieved directly through the IEE. However, we can implement a solution using PL/SQL Developer to accomplish your goal in the background. With PL/SQL Developer, we can create a procedure that enforces the uniqueness of the record creation for the persistent field and ensures that it does not contain blank or NULL values. This can be achieved by defining appropriate constraints. You can use the following ORACLE commands via PL/SQL Developer to do the needful.ALTER TABLE MTG_COMPANY_PERSON_CLT MODIFY ( CF$_MTG_EMP_NO NOT NULL);CREATE UNIQUE INDEX <index_name> ON MTG_COMPANY_PERSON_CLT(CF$_MTG_EMP_NO);current version: Apps 10 UPD12
Issue was solved via Solution ID: 307107 - Bug ID: 166841
We just updated from Apps 10 Update 14 to 20, and this is now different. Did IFS discontinue this option? This issue has been fixed in IFS Fixed Version: APP10UPD21
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.