Insert statement in oaf

Insert statement in oaf

In this post, We will discuss how we can insert statement in oaf. We will try to insert records from OAF page in the post. I will show you the complete code for Insert statement in oaf. We will try to create one OAF page here below which will insert records from oaf page to the database. This will store data from Oaf page to the Oracle Database. Here below is the Insert statement in oaf.

 

 

Complete Step by step Insert statement in oaf.

 

 

1.First we will create table on which we insert Data.

Create a new workspace name "RohitDataEntryOaf".
Right Click on "Applications".Click on "NewOAWorkspace".



Enter the name of Workspace="RohitDataEntryOaf".Click Ok.

 Project wizard will open click next.

Enter the name of the Project="RohitDataEntryOaf".
Default Package= "rohit.oracle.apps.fnd.RohitDataEntryOaf"

Package determines the directory where the java class files and other files related to this project strored.
In this directory oracle.apps.fnd must be required."fnd" is the oracle application shortname you can use other applications like "ak" in this.

Enter the RunTime connection .Enter the E-business Suit Application User Name and Password.(already explained in the JDev installation).





Workspace and project has been created.

If we have to insert data we have to use EO.
TO create Entity Object(EO).

Right Click on the project "RohitDataEntryOaf".Click New

Enter the Entity Object name="SupplierEntryEO"

Defualt Package="rohit.oracle.apps.fnd.RohitDataEntryOaf.server"

Schema Object = XX_SUPPLIER_MASTER               //Your Table Name.

we create "Entity Object" under the "Server" directory of the project as OAF Standard.

Click Next.

Click next and then finish.

EO has been create as below.

Now we create a View Object(VO) which is based on Entity Object(EO).

Right Click on the project "RohitDataEntryOaf".Click New

 Enter the View Object name="SupplierEntryVO"

Defualt Package="rohit.oracle.apps.fnd.RohitDataEntryOaf.server"

we create "View Object" under the "Server" directory of the project as OAF Standard.

Click Next.

Select the "SupplierEntryEO" in the left hand side and then shuttle this to the right and then click Next.

 Click Next and then Finish.

View Object has created as below.

Now  we create "Application Module".

Right Click on the project "RohitDataEntryOaf".Click New

 Application Module wizard has open as below click next

Enter the Application Module name="RohitDataEntryAM"

Defualt Package="rohit.oracle.apps.fnd.RohitDataEntryOaf.server"

we create "Application module" under the "Server" directory of the project as OAF Standard.
Click next and then finish.

.
Select the "SupplierEntryVO" in the left hand side and then shuttle this to the right and then click next and then finish.

Application Module has created as Below.

Due to the Length of this post I have split this post in two parts Please find the Second part here Below.

Part2:- https://rpforacle.blogspot.com/2018/01/part2-creating-data-entry-page-in-oaf.html