This blog describes how to create a PL/SQL based Entity Object.Oracle application has number of APIs and each API will perform numerous number of tasks.We can create PL/SQL based EO which will directly invoke the PL/SQL stored procedure from the EO.

Here I am demonstrating using a standard API FND_USER_PKG.CREATEUSER.This API has x_user_name and x_owner as mandatory parameter.My task is to create a user through OAF page which will accept User Name and Password.

Following steps needs to be performed to achieve the above scenario.

1) Create FndUserEO as follows

Include all the API parameters and WHO columns in the EO.

Make UserName and EncryptedUserPassword ( Here I am not using Encrypted Password. The column name is same as table column so I am keeping the same) column as mandatory.

Generate VO.

2) Edit FndUserEOImpl and add the following

3) Attach FndUserVO to AM

4) Create the UI

5) Deploy following files to middle tier and restart the server.

 Entity Object:
xxcust.oracle.apps.fnd.user.schema.server.FndUserEO.xml
xxcust.oracle.apps.fnd.user.schema.server.FndUserEOImpl.java

View Object:
xxcust.oracle.apps.fnd.user.server.FndUserVO.xml
xxcust.oracle.apps.fnd.user.server.FndUserVOImpl.java

User Interface:
xxcust.oracle.apps.fnd.user.webui.CreateFndUserCO.java
xxcust.oracle.apps.fnd.user.webui.CreateFndUserPG.xml

You can test by giving User Name and Password.