There are the scenarios for VO Extensions:
Step 1: If there is new field addition in the Page which is not there in the existing VO.
Step 2: There might be No New field addition in OAF Page, but there will be the requirement to add the extra condition in WHERE CLAUSE or HAVING CLAUSE or GROUP BY.
=======================================
Now my scenario is Step 1: (My Requirement)
a. First understand the requirement where to do and what to do.
b. Find the right page (Page Path), and right VO (VO Path) where change is required. Here there will be the chances of Page Path and VO Path different.
c. Create the same VO path in local system.
d. Go JAVA_TOP in respected instance (Server) and path, download the ".class" files into local system of same path which is created in above step "c".
e. Open the JDeveloper and Create empty project with custom path like example:
xxcustom.oracle.apps.ap.invoice.request.webui
f. To avoid errors while creation of new vos, before creating a new custom vos, create the .java files for standard .class files, so that SQL can easily modifiable without any errors.
g. After creation of Project in JDeveloper create the New VO with naming conventions, details below:
VO Name: xxcustom..VO
Custom Path: xxcustom.oracle.apps.ap.invoice.request.server
Extends: select standard VO
path and vo like below:
oracle.apps.ap.invoice.request.server.ApinvoiceHdrDetailsVO
h. After creation of custom vo then compile the VO and Make the changes.
i. Do the Substitution for created custom VO and Standard VO:
Navigation: Project --> Properties --> Business Componenets --> Substitutions -->
right side select Standard VO and Left side Custom VO and finally Submit.
j. import the file into server with below commands:
jpximport D:\Yadul\p9879989_R12_160918\jdevhome\jdev\myprojects\xxprojectname.jpx -username apps -password apps-dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1988))(CONNECT_DATA=(SID=VIS12)))"
k. then after move the .class files into server.
l. move the .project file ".jpx" file. For this we need to create one custom path in Server Instance ($JAVA_TOP/xxcustom/jpxfiles/install/) , here we need to move the .jpx file.
m. here in the same path run the below command to implement the changes into the page:
java oracle.jrad.tools.xml.importer.JPXImporter $JAVA_TOP/xxcustom/jpxfiles/install/xxprojectname.jpx -userId 1 -username apps -password dwcsapps0119 -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1988))(CONNECT_DATA=(SID=VIS12)))"
n. Our changes done, we can see the changes in the standard page.
Step 1: If there is new field addition in the Page which is not there in the existing VO.
Step 2: There might be No New field addition in OAF Page, but there will be the requirement to add the extra condition in WHERE CLAUSE or HAVING CLAUSE or GROUP BY.
=======================================
Now my scenario is Step 1: (My Requirement)
a. First understand the requirement where to do and what to do.
b. Find the right page (Page Path), and right VO (VO Path) where change is required. Here there will be the chances of Page Path and VO Path different.
c. Create the same VO path in local system.
d. Go JAVA_TOP in respected instance (Server) and path, download the ".class" files into local system of same path which is created in above step "c".
e. Open the JDeveloper and Create empty project with custom path like example:
xxcustom.oracle.apps.ap.invoice.request.webui
f. To avoid errors while creation of new vos, before creating a new custom vos, create the .java files for standard .class files, so that SQL can easily modifiable without any errors.
g. After creation of Project in JDeveloper create the New VO with naming conventions, details below:
VO Name: xxcustom..VO
Custom Path: xxcustom.oracle.apps.ap.invoice.request.server
Extends: select standard VO
path and vo like below:
oracle.apps.ap.invoice.request.server.ApinvoiceHdrDetailsVO
h. After creation of custom vo then compile the VO and Make the changes.
i. Do the Substitution for created custom VO and Standard VO:
Navigation: Project --> Properties --> Business Componenets --> Substitutions -->
right side select Standard VO and Left side Custom VO and finally Submit.
j. import the file into server with below commands:
jpximport D:\Yadul\p9879989_R12_160918\jdevhome\jdev\myprojects\xxprojectname.jpx -username apps -password apps-dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1988))(CONNECT_DATA=(SID=VIS12)))"
k. then after move the .class files into server.
l. move the .project file ".jpx" file. For this we need to create one custom path in Server Instance ($JAVA_TOP/xxcustom/jpxfiles/install/) , here we need to move the .jpx file.
m. here in the same path run the below command to implement the changes into the page:
java oracle.jrad.tools.xml.importer.JPXImporter $JAVA_TOP/xxcustom/jpxfiles/install/xxprojectname.jpx -userId 1 -username apps -password dwcsapps0119 -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1988))(CONNECT_DATA=(SID=VIS12)))"
n. Our changes done, we can see the changes in the standard page.
No comments:
Post a Comment