In this blog I will explain how to perform Entity Object ( EO ) Extension.As a prerequisite please read my previous blog.I am doing this exercise based on PL/SQL EO.

Following attributes are part of FndUserEO.

Here I will add a validation to UserName attribute "Length should be > 5".

Following steps need to perform.

1) Download all files of  "Entity Object Based on PL/SQL" to JDEV_USER_HOME/myprojects and JDEV_USER_HOME/myclasses.If you want to see the content of source java file decompile it and save it in JDEV_USER_HOME/myprojects.

2) Create new Entity Object XXFndUserEO as follows.

Include all attributes of parent EO.

3) Add the validation code snippet to XXFndUserEOImpl.java as follows.

4) Create the substitution as follows.

5) Migrate files to $JAVA_TOP.

xxcustom.oracle.apps.fnd.user.schema.server.XXFndUserEOImpl.java
xxcustom.oracle.apps.fnd.user.schema.server.XXFndUserEO.xml

6) Migrate the substitution..

7) Bounce the server.

8) Verify the substitution has applied properly.

Access Create User Page and create a User.

You can see the validation message if user name length is less than 5.

Give User Name as XXCUST4 and verify the table.

  The FND_USER has created successfully.