Friday, 30 March 2018

Part2 OAF VO Extension : How to add new Column in the Expense Report Summary Home Page

Part 2 OAF VO Extension : How to add new Column in the Expense Report Summary Home Page

 
In this post , we will do View Object VO extension in Oracle Application OAF web pages. first of all , we will discuss the need of the VO extension in OAF. When we have an requirement to display some more attributes or fields in the OAF page then we do VO extension to meet this requirement. We all know that , We see the data in the OAF page through View Objects(VO) and in a single page can have more then 1 View Objects(VO). First of all , we need to find out that , in which Standard View object , we need to add new Fields in OAF Page. Then we do view Extension , to add this new field in the View Object and then display this new Field in the OAF page through Personalizations.
This is the Second Part of OAF VO Extension. We have already created a OAF project in the J-Developer and now in the Post , we will start doing VO Extension in this Project.
 
Here below is the First part of this Topic.
 
 

Step13:- Creation VO Extension

 
Now right Click on the Project as below and click New.
 
Part2 OAF VO Extension : How to add new Column in the Expense Report Summary Home Page


 
Step14:- Now Create View Object as below :-
 
Part2 OAF VO Extension : How to add new Column in the Expense Report Summary Home Page

 
 
Step15:- Create Extended VO Name and select the Package.
Now select the Standard VO which you want to Extend Click on the Browse Button under Extends as below and Select the Standard View Object 'TrackExpesneReportsVO'  which we want to Extend in this VO Extension.
 
Part2 OAF VO Extension : How to add new Column in the Expense Report Summary Home Page
Select the same path under which your Standard Controller Placed in the Jdevhome folder MyProjects folder.
 
Step17:- Select the 'TrackExpesneReportsCO' Standard Page Controller.

 
 
Step18:- This is the Extended view Object Final Screen Click Next.
 
 
Step19:- This is The Query working for the Standard View Object. Copy the Query of the View Object in the Toad.
Part2 OAF VO Extension : How to add new Column in the Expense Report Summary Home Page
 
 
Step20:- Now Add the Custom column 'Attribute5' which you want to display in the OAF Page. Always add the New Column in the Last.
 
OAF VO Extension
 
 
Step21:-Paste the Changed Sql query in the VO Object and Click Next.
OAF VO Extension
 
Step22:-Select the required Check Box and click Finish.
OAF VO Extension
 
 
 
Step23:- This is the Extended VO created As Below.
 
OAF VO Extension
 
Step24:- Now We will do Substitution of this Custom view Object.
Right click on the Project and Click Project Properties.
 
Go to the Substitutions:-
 
OAF VO Extension
 
 
 
 
Step23:- Move the VO file in Java_Top and then Import this View Object with the Help of this Script.
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxap/oie/server/ TrackExpenseReportsVOEx.xml -rootdir $JAVA_TOP -username apps -password apps -dbconnection " (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server name)(PORT=100001))(CONNECT_DATA=(SERVICE_NAME=SID NAME)))"
 
 
Step23:- Now again go Back to the Web page in application where we want to do this View Object Extension. Now Click on the 'Personalize Link' Highlighted below.
 
 
 
 
 
Step24:- Now click on Create Item Icon as below to add new field in the View Object.
 
 
 
 
Step25:- Create Item with Style 'Message Styled Text'.
 
 
 
Step26:- Give the Item Properties as below.
 
 
Step27:- Give the name of the Extended View Object  in View Instance and the Name of your New View object Column in the View Attribute as below.
 
 
Step28:- Now we can see below Tracking No. field displaying in the OAF Expense Home Page.
 
 
Part2 OAF VO Extension : How to add new Column in the Expense Report Summary Home Page

9 comments:

Anonymous said...

Hi,
When I import the xml there was error :

: XML-20112: (Fatal Error) Error opening external DTD 'jbo_03_01.dtd'.
Warning: Could not find the customization level value for document "/hack/oracle/apps/po/notifications/server/XXPoNotifLinesSummaryVOEx".
no protocol: jbo_03_01.dtd

Importing file "/oracle/TEST1/fs1/EBSapps/comn/java/classes/hack/oracle/apps/po/notifications/server/XXPoNotifLinesSummaryVOEx.xml" as "/hack/oracle/apps/po/notifications/server/XXPoNotifLinesSummaryVOEx".
Error:
no protocol: jbo_03_01.dtd

Basha said...

Hi,
Same Error is coming to me. Can you please suggest on this step to continue the next step.

Rohit said...

Hi Basha,

Can you please share the XML import Script you are using to Import this Extended VO

Meggie said...

Hi,
I got the same error when deploy am file.
My import script is as following:
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/mine/oracle/apps/ak/employee/server/MyEmployeeAM.xml -username apps -password a
ppsdlsit -dbconnection "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.52.96)(PORT=1525)))(CONNECT_DATA=(SERVICE_NAME=DLSIT)))" -rootdir $JAVA_TOP

the error message is following:
: XML-20112: (Fatal Error) Error opening external DTD 'jbo_03_01.dtd'.
Warning: Could not find the customization level value for document "/mine/oracle/apps/ak/employee/server/MyEmployeeAM".
no protocol: jbo_03_01.dtd

Importing file "/dlebs/sit/apps/apps_st/comn/java/classes/mine/oracle/apps/ak/employee/server/MyEmployeeAM.xml" as "/mine/oracle/apps/ak/employee/server/MyEmployeeAM".

Error:
no protocol: jbo_03_01.dtd

Import failed.

any suggest please?

Rohit said...

Hi Meggie,

first thing Have you already migrates the Customization files in this below path $JAVA_TOP/mine/oracle/apps/ak/employee/server/MyEmployeeAM

Then you can run the Import Script

Second , Are you dosing VO Extension , Then why you are giving the MyEmployeeAM in the Java Import.

SE said...

Hi,

Following this note I am also doing a VO Extention for Buyer's workcenter to add Supplier Number to the search page. However I am getting this error oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition fmps.oracle.apps.po.document.server.CocPoHeadersSummaryVO of type View Definition not found

Pls. help

Basha said...

at step 23:
When I import the xml as below command
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/ap/oie/server/TrackExpenseReportsVOEx.xml -rootdir $JAVA_TOP -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=plane.cbposystems.com)(PORT=1620))(CONNECT_DATA=(SERVICE_NAME=VIS)(INSTANCE_NAME=VIS)))"

: XML-20112: (Fatal Error) Error opening external DTD 'jbo_03_01.dtd'.
Warning: Could not find the customization level value for document "/oracle/apps/ap/oie/server/TrackExpenseReportsVOEx".
no protocol: jbo_03_01.dtd

Can you please suggest on this

Anonymous said...

your blog is really informative and helpful for me. Thanks for sharing information
Oracle Fusion Financials Online Training
Oracle Fusion Technical Online Training

Vidyesh said...

as per MOS Note (Doc ID 848851.1), we don't need to import BC4J files. Just copy is enough.

 

SOLUTION

Do not try to use the xmlimporter to load BC4J files.
Instead, BC4J files just needs to be copied to the location specified in JAVA_TOP.

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *