Create lov using oaf personalization

Create lov using oaf personalization

In this post , We will be discuss about Create lov using oaf personalization. We will learn how we can create the custom lov in oaf page using personalization. Using OAF personalization , We can create new field in OAF page and then attach the custom lov to this new field in oaf personalization. OAF personalization helps to attached the customer lov to any OAF page field. Here below is the detail about create lov using oaf personalization.

Step by Step to Create lov using oaf personalization

Step1:- I am taking example of Supplier Creation page, where I will show how we can attach Custom LOV in Oracle standard pages with doing customization in the standard page and user can select the value from this LOV during supplier creation in OAF page.

This will be long topic so I will split this topic in two parts.

Create workspace in Developer.

Step2 :- Give the name of your Workspace as below.

Now you can see below your workspace and project has been created.

Now right Click on Project RohitExternalLOV è New

Click on OA Components è Select Region as below.

Give the name of Region and chose the Package Directory Carefully.

Oracle.apps.xxap.RohitExternalLOV.webui

When you will create region then as below you can see that region structure.

 

Now Again right Click on Project RohitExternalLOV è New èADF Buisness Components è View Object

To Learn OAF Online from Beginning , Please go to the OAF Tutorial

Give the name of View Object and chose the Package Directory Carefully.

Oracle.apps.xxap.RohitExternalLOV.server

Put the sql query which will select value in your LOV.

Now Again right Click on Project RohitExternalLOV è New èADF Buisness Components è Application Module.

Give the name of View Object and chose the Package Directory Carefully.

Oracle.apps.xxap.RohitExternalLOV.server

Select RohitExternalLOVVO under this AM as below.

Now go back to region then click on RohitExternalLOVRG  . When you click on Region then below you can see structure of this region as below. Right click on this structure RohitExternalLOVRG è New è Table.

Now your table object has been created under RohitExternalLOVRG region. Click on this table object and on right hand side you will see Property Inspector. Change the name of the Table object there as below.

Now again right click on Table RohitExternalLOV as below è New è messageStyledText.

Then Item1 is created under table as below. Click on Item1 and change the name of item in Property Inspector as below

Click on Item1 and change the name of item in Property Inspector as below

Now again right click on Table RohitExternalLOV as below è New è messageStyledText

Then Item1 is created under table as below. Click on Item1 and change the name of item in Property Inspector as below

Click on Item1 and change the name of item in Property Inspector as below Supplier Name.

At last your Region Structure will be look like this.

Now again click on Top Region Structure RohitExternalLOVRG and to its Properties.

In Property Inspector Under BC4j Select AM definition for this region which we created Earlier.

Oracle.apps.xxap.RohitExternalLOV.server.RohitExternalLOVAM

Now Click Item1 (ExternalSupplierNo) and in properties select View Instance

Now Click Item2 (SupplierName) and in properties select View Instance

Now everything is competed in J-developer side. Now we will register/import this Region and View object in Oracle apps and then go that page where we want to attach this LOV region and this LOV.

Use Below Script to Import OAF Objects in Oracle apps.

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxap/RohitExternalLOV/RohitExternalLOVVO.xml -rootdir $JAVA_TOP -username apps -password apps -dbconnection " (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= host_nAME)(PORT=1223))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))"
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxap/RohitExternalLOV/RohitExternalLOVAM.xml -rootdir $JAVA_TOP -username apps -password apps -dbconnection " (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= host_nAME)(PORT=1223))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))"
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxap/RohitExternalLOV/RohitExternalLOVRG.xml -rootdir $JAVA_TOP -username apps -password apps -dbconnection " (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= host_nAME)(PORT=1223))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))"

This is our Supplier Creation Page where I want to see Custom LOV of External Supplier No so that user can select that Number during supplier creation in Oracle.

First of all we get to know which VO object is working behind this suppler creation page for this you need to click on About this page and then expand all.

You need to search with Supplier form any field to get the VO working for that fields. In our case we got that HzPuiOrganizationProfileQuickVO is working on supplier page.

Click on Personalize ‘Organization Quick code link in Supplier Page

Click on Create Item as below.

Select Level – Site and Item Style – Message Lov Input.

ID= Any name you can give without spaces.

External LOV- Path of your Custom VO which you create in Jdev.

/oracle/apps/apexp/RohitExternalLOV/server/RohitExternalLOVVO.

Prompt:- External Supplier No.

View Attribute = Attribute2 (DFF Field)

View Instance = HzPuiOrganizationProfileQuickVO

Now again under External Supplier No LOV input field è click on create item for Lov mappings.

Level =Site

Item Style= Lov Map

ID= Any Id without space

Criteria Item= ExternalSupplierNo ( LOV item created in JDev)

LOV Region Item= RohitExternalLOV (LOV Region name created in JDeveloper)

Return Item = XX_EXTERNAL_SUPPLIER( LOV Input item created in OAF page by personalization in previous step)

LOV Region Item

Criteria Item

After the personalization we can see below , External Supplier No is started showing in the Supplier Creation Form in Oracle Standard OAF page.

Create lov using oaf personalization