OAF Compilation commands

 






*************************

* Compiling .JAVA file  *

*************************

>javac *.java


--> The above command compiles all java files present in a folder.


NOTE: 1) .java files present in each and every folder need to be compiled.

      2) .java file when compiled provides corresponding .class file


*****************

*Destination URI*

*****************

OA.jsp?page=/Xxcust/oracle/apps/ar/ListOfVal/Dependent/webui/dependentPG&OrderNumber={@OrderNumber}&retainAM=Y

OA.jsp?page=/Xxcust/oracle/apps/ar/DetailAndDML/detail/webui/carDetailPG&carMakeparam={@Carmake}&carModelparam={@Carmodel}&carverparam={@CarVer}&retainAM=Y



**************************

* FOR PAGES (OR) REGIONS *

**************************


import command to be run in putty:


java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/xxhw/oracle/apps/fnd/helloworld/webui/HelloWorldPG.xml -username apps -password password -rootdir $JAVA_TOP -dbconnection “(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=r12.erpschools.com)(PORT=9376)) (CONNECT_DATA= (SID=VIS)))”

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oafreg/oracle/apps/po/requisition/webui/oafregPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection “(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))”


java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/search/RBsearch/webui/rbsearchPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/search/AutoCustCriteria/webui/AutoCustCrtriaPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/search/ManualSearch/webui/manualPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/subPrograms/webui/procPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/ConcPrgm/webui/concPrgmPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"


LOV

---

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/ListOfVal/Independent/lov/webui/IndLovRN.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/ListOfVal/Independent/lov/webui/IndOrgIdRN.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/ListOfVal/Dependent/lov/webui/LovDepRN.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/ListOfVal/Dependent/lov/webui/LovOrdNumRN.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"


java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/DetailAndDML/detail/lov/webui/CarMakeRN.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/DetailAndDML/detail/lov/webui/CarVerRN.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"


java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/DetailAndDML/Insert/lov/webui/CarColorRN.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/DetailAndDML/Insert/lov/webui/CarmakeRN.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"



PAGE

----

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/ListOfVal/Independent/webui/IndependentPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/ListOfVal/Dependent/webui/dependentPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"


java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/DetailAndDML/detail/webui/carDetailPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/DetailAndDML/detail/webui/carsPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"


java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/DetailAndDML/Insert/webui/carEntryPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/DetailAndDML/Insert/webui/CarInfoPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"


java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/Xxcust/oracle/apps/ar/MasterDetail/webui/mstdtlPG.xml -username apps -password apps -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = apps.ora.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = vis)))"



java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/rhmozf/oracle/apps/ozf/oa/ACDordupld/webui/OrdUpldPG.xml -username apps -password appsebsdev -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = afsodevdb01.onerheem.com)(PORT = 1528)))(CONNECT_DATA =(SERVICE_NAME = EBSDEV)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/xxrhm/oracle/apps/ap/noe/webui/XXRHMNOExpenseReportsPG.xml -username apps -password appsebsdev -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = afsodevdb01.onerheem.com)(PORT = 1528)))(CONNECT_DATA =(SERVICE_NAME = EBSDEV)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/rhmozf/oracle/apps/ozf/oa/request/webui/XXRHMRMAUploadPG.xml -username apps -password appsebsdev -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = afsodevdb01.onerheem.com)(PORT = 1528)))(CONNECT_DATA =(SERVICE_NAME = EBSDEV)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/rhm/oracle/apps/msd/upload/webui/RHMDMlifeCycleUploadPG.xml -username apps -password appsebsdev -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = afsodevdb01.onerheem.com)(PORT = 1528)))(CONNECT_DATA =(SERVICE_NAME = EBSDEV)))"

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/rhm/oracle/apps/msd/upload/webui/RHMDMlifeCycleValidationPG.xml -username apps -password appsebsdev -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = afsodevdb01.onerheem.com)(PORT = 1528)))(CONNECT_DATA =(SERVICE_NAME = EBSDEV)))"



OA.jsp?page=/rhm/oracle/apps/msd/upload/webui/RHMDMlifeCycleUploadPG

OA.jsp?page=/rhmozf/oracle/apps/ozf/oa/ACDordupld/webui/OrdUpldPG

OA.jsp?page=/rhmozf/oracle/apps/ozf/oa/request/webui/XXRHMRMAUploadPG



EBSPROJ

-------

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/rhm/oracle/apps/wip/spr/webui/RHMshipToSitesUploadPG.xml -username apps -password appsebsproj -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = afsoprojdb01.onerheem.com)(PORT = 1575)))(CONNECT_DATA =(SERVICE_NAME = EBSPROJ)))"



OA.jsp?page=/rhm/oracle/apps/wip/spr/webui/RHMshipToSitesUploadPG







Comments

Post a Comment

Popular posts from this blog

AD_ZD_TABLE : Steps to follow while creating table in R12.2.*

Image
  *********** * GRANTS * ********** Team – do not use Grant statements in the SQL scripts while migrating through STAT , instead use  EXEC AD_ZD.GRANT_PRIVS. Manual steps run in DEV Environment: 1. As XXCUST, manually Create/Alter custom table in EBSDEV or EBSPROJ (XXCUST schema for all custom tables). 2. In EBSDEV/EBSPROJ: If creating the table, run:  AD_ZD_TABLE.UPGRADE (‘SCHEMA’,’TABLE’); If altering the table, run: AD_ZD_TABLE.PATCH (‘SCHEMA’,’TABLE’); 3. Insert at least one row of data in the custom table. * This is mandatory for XDF to extract the table definition and for successful Stat archive set creation. 4. As table owner, grant privileges on new/altered table and editioned view to APPS, primarily so AD_ZD.GRANT_PRIVS can be run for privileges. GRANT ALL ON SCHEMA.TABLE TO APPS WITH GRANT OPTION; GRANT ALL ON SCHEMA.EDITIONED_VIEW# TO APPS WITH GRANT OPTION; 5. If additional privileges are required on the new/altered table, the following needs to be run as APPS: ex
Read more

OAF page to UPLOAD the data from excel sheet to the database table

Image
   UPLOAD BUTTON (logic below): Excel sheet column structure: Table Structure: Code inside Controller: public void processFormRequest(OAPageContext  pageContext,  OAWebBean    webBean) {      super.processFormRequest(pageContext, webBean);      OAApplicationModule  am = (OAApplicationModule)pageContext.getApplicationModule(webBean);      String   filename   = null;      String   fname       = null;      String   ext            = null;     pageContext.writeDiagnostics(this,"Inside PFR..",1);      if(pageContext.getParameter("UploadBtn") != null)   //ID of the Upload button       {                DataObject   upload  =  pageContext.getNamedDataObject("FileUpload");  //import oracle.cabo.ui.data.DataObject; //"FileUpload" is the ID of the item with style "messageFileUpload".                 try {                       filename = (String)upload.selectValue(null, "UPLOAD_FILE_NAME");                       int mid =  filename.lastIn
Read more

Initiating a webservice API from Plsql package !!

Image
create or replace PACKAGE      xxat_3pl_webservice_pkg AS --=============================================================================================== -- Program name         Creation Date     Original Version   Created by   JIRA -- xx_webapi_dhl_fnc    ***********       1.0                 -- ----------------------------------------------------------------------------------------------- -- Description: -- This function will use a dummy waybill number for 3PL carriers and get the original waybill number. -- This program uses SOA platform to post and get the information from 3PL carrier. -- -- Parameter    : p_waybill_dummy_no      IN     Scan SHIP by user -- -- ----------------------------------------------------------------------------------------------- -- Modification History: -- Modified Date     Version    Done by               Change Description -- **-***-****       1.1         -- ===============================================================================================
Read more