Java Excel

http://www.vogella.com/tutorials/JavaWebTerminology/article.html
http://www.javabeat.net/difference-servlet-jsp/
http://www.differencebetween.net/technology/difference-between-jsp-and-servlet/
Enviroment File
. /a01/oracle/PRODERP/apps/apps_st/appl/APPSPRODERP_oracleapps.env
JAVA
OC4J Properties (configuration file)
/a01/oracle/PRODERP/inst/apps/CRP2_erpdev1/ora/10.1.3/j2ee/oacore/config 10.1.3 for webserver
Context file (total configuration), port number, dbc file location
/a01/oracle/PRODERP/inst/apps/CRP2_erpdev1/appl/admin
All Jsp Files
/a01/oracle/PRODERP/apps/apps_st/comn/webapps/oacore/html
Oracle Home : /d00/oracle/PRODERP/db/tech_st/11.1.0
Oracle Trace File : /d00/oracle/PRODERP/db/tech_st/11.1.0/admin/PRODERP_oracledb/diag/rdbms/bseclone/BSECLONE/trace
https://pacesettergraam.wordpress.com/tag/oaf-page-deployment/
http://dilipoaf.blogspot.in/2013/07/deploying-your-viewobject-extensions.html
https://blogs.oracle.com/prajkumar/entry/deploy_oaf_page
https://blogs.oracle.com/manojmadhusoodanan/entry/self_secured_page_creation_in
Download the page
enable the personalization
FND: Personalization Seeding Mode
Personalize Self-Service Defn - Yes
FND: Personalization Region Link Enabled - Yes
Now u can see the path.
Now download the server folder and webui folder
Integrate these file by ging the AM path in  server page and CO 
DECLARE
BEGIN
jdr_utils.listdocuments('/oracle/apps/per', TRUE);
END;
dbc file location
$INST_TOP/appl/fnd/12.0.0/secure
select node_name, node_id, server_id 
from fnd_nodes;
Importing Command 
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/employee/oracle/apps/po/requisition/webui/EmployeePG.xml -username apps -password t3st1nd1a -rootdir $JAVA_TOP -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bseclone.mailbse.com)(PORT=1522))(CONNECT_DATA=(SID=BSECLONE)))"
java oracle.jrad.tools.xml.importer.XMLImporter  $JAVA_TOP/Apple/oracle/apps/po/india/webui/SearchSupplierPG.xml -username apps -password d3st1ny -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= erpdev1.mailbse.com)(PORT=1522))(CONNECT_DATA=(SID=CRP2)))" -rootdir $JAVA_TOP
https://books.google.co.in/books?id=HTxOCAAAQBAJ&pg=PA42-IA30&lpg=PA42-IA30&dq=ADD_ROWS_EVENT.equals&source=bl&ots=PjRuto6kQH&sig=vUxGDR4EexUz7LodvWVccOapWYs&hl=en&sa=X&ei=yIRoVZk01ZG4BM6Hg6gN&ved=0CDcQ6AEwAw#v=onepage&q=ADD_ROWS_EVENT.equals&f=false
if ("update".equals(pageContext.getParameter(EVENT_PARAM))) 
pageContext.setForwardURL("OA.jsp?page=/prajkumar/oracle/apps/fnd/searchdemo/webui/UpdatePG", 
                                    null, 
                                    OAWebBeanConstants.KEEP_MENU_CONTEXT,                             
                                    null,                                                    
                                    null, 
                                    true,                             
                                    OAWebBeanConstants.ADD_BREAD_CRUMB_NO, 
                                    OAWebBeanConstants.IGNORE_MESSAGES); 
-------------------------------------------------------------------------------------------------
public void remove() 
{ super.remove(); 
} // end remove()
    
public void apply() 
{ getTransaction().commit(); 
}
public void rollback() 
{getTransaction().rollback(); 
}
if ("delete".equals(pageContext.getParameter(EVENT_PARAM))) 
---------------------------------------------------------------------------------------------------
OADBTransaction oadbtransaction = (OADBTransaction)getTransaction();
StringBuffer str = new StringBuffer(); 
 str.append( " BEGIN "); /;
 str.append( " test_package.data_sum( "); 
 str.append( " item1     => :1, "); 
 str.append( " item2     => :2, "); 
 str.append( " data_sum  => :3  "); 
 str.append( "  ); "); 
 str.append( " END; ");
OracleCallableStatement oraclecallablestatement =  (OracleCallableStatement)oadbtransaction.createCallableStatement(str.toString(), 1);
 try
 { 
  oraclecallablestatement.setInt(1,  Integer.parseInt(item1) ); 
  oraclecallablestatement.setInt(2,  Integer.parseInt(item2) );
  oraclecallablestatement.registerOutParameter(3, Types.VARCHAR);
  oraclecallablestatement.execute(); 
  retValues = oraclecallablestatement.getString(3); 
 } 
---------------------------------------------------------------------------------
 vo.setWhereClause(null);
 vo.setWhereClauseParams(null);



















































Comments

Post a Comment

Popular posts from this blog

OAF Registration

The basic file available in OAF is java file and XML file. we never move java file to server *.java(we never move source code) ----------------------------------- if we want to deploy OAF page .*xml, .*java ---------------------------- we move class file(eo,vo, am) xml file--> bc4j objects, pg files ----------------------------------- Class,XML--> JAVA_TOP PG.xml--> MDS Layer -------------------------------------------- open putty echo applmgr$echo $JAVA_TOP  --> (D:\oracle\VIS\apps\apps_st\comn\java\classes\) move the folder in this folder oracle seeded files will be in oracle folder ------------------- for pg.xml we have import statement import C:\jdev\jdevhome\jdev\febpaftraining\myprojrcts\xxibm\oracle\apps\fnd\webui\studentDNMUsingEOPG.xml -username apps -password apps -dbconnection "(DESCRIPTIOn=(ADDRESS=(PROTOCOL=tcp)(HOST=glo.dev.com)(PORT=1521))(CONNECT_DATA=(SID=VIS)))" -rootDor C:\jdev\jdevhome\jdev\ feboaftraining\mypr...
Read more
public void intEmployee(String empName,String empId) { String voName="DynamicVO"; OAViewObject vo = (OAViewObject) findViewObject(voName); Number empNum = null; try { empNum = new Number(empId); } catch(Exception e) { } if (vo != null) { vo.setWhereClause(null); vo.setWhereClauseParams(null); if(!empName.equals("") && !empId.equals("") ) { String s1 = " EMPLOYEE_ID = "+empNum+" AND "+" UPPER(EMPLOYEE_NAME) LIKE "+"UPPER("+"'"+empName+"'"+")";  vo.setWhereClause(s1); } else if(!empName.equals("")) { String s2 = " UPPER(EMPLOYEE_NAME) LIKE "+"UPPER("+"'"+empName+"'"+")";  vo.setWhereClause(s2); } else if(!empId.equals("")) { String s3 = " EMPLOYEE_ID = "+ empNum; vo.setWhereClause(s3); } } vo.executeQuery(); } public...
Read more