How to deploy Oracle Custom Application developed in OAF in Oracle Application Server

Step 1:Create your necessary Database Obejcts i.e.Tables,Views,Sequences,Synonims in Apps schema.

i)

CREATE TABLE apps.XXGP_JDMS_APP_TABLE

(

  JD_ID              VARCHAR2(100 BYTE),

  APP_USER_NAME      VARCHAR2(100 BYTE),

  APP_STATUS         VARCHAR2(100 BYTE),

  APP_LEVEL          NUMBER,

  APPROVER_COMMENTS  VARCHAR2(1000 BYTE),

  NOTIFICATION_ID    VARCHAR2(100 BYTE),

  CREATED_BY         NUMBER,

  CREATION_DATE      DATE,

  LAST_UPDATE_LOGIN  NUMBER,

  LAST_UPDATED_BY    NUMBER,

  LAST_UPDATE_DATE   DATE

)

ii)

DROP SEQUENCE APPS.GP_JDMS_TRX_SEQ;

CREATE SEQUENCE APPS.GP_JDMS_TRX_SEQ

  START WITH 1

  MAXVALUE 5000

  MINVALUE 1

  CYCLE

  CACHE 20

  NOORDER;

iii)

CREATE OR REPLACE function apps.getNextTransForJDMS return varchar2

is

jdid  varchar2(20);

begin

SELECT 'GJD'||TO_CHAR(SYSDATE,'DDMMYYYY')||GP_JDMS_TRX_SEQ.NEXTVAL into jdid FROM DUAL;

return jdid;

end;

/

And compile the packages for Oracle Workflows.

Step 2. Connect to the APP server and goto the $JAVA_TOP folder.

Step 3. Goto your Java_home/project folder/My Classes and transfer the folder in ASCII mode to the  $JAVA_TOP.

Step 4: Transfer the .class files into the corresponding folder in binary mode and replace after warning.

Step 5: Import the .xml pages in app server by the following command.

C:\JDEVELOPER_\jdevbin\jdev\bin\import C:\p4573517_11i_current\jdevhome\jdev\myprojects\oracle\apps\ak\jdms\webui\JDcreationPG.xml -username apps -password yourpass -rootdir C:\p4573517_11i_current\jdevhome\jdev\myprojects\ -dbconnection "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Server ip)(PORT = server ip))) (CONNECT_DATA = (SERVICE_NAME = DEV)))"

 


Step 6: Create the functions from Application developer->function

i) Description:

Function	User Function Name	Description
XXGP_JDMS	JD Managerment	JD Management System
XXGP_JDMS_ADMIN_HOME	XXGP_JDMS_ADMIN_HOME	JDMS Home for Admin
XXGP_JDMS_DEPT_HEAD	XXGP_JDMS_DEPT_HEAD	JDMS Page for Department Head
XXGP_JDMS_DIV_HEAD	XXGP_JDMS_DIV_HEAD	JDMS Page for Division Head
XXGP_JDMS_HR_ADMIN	XXGP_JDMS_HR_ADMIN	JDMS Page for HR Admin
XXGP_JDMS_SECTION_HEAD	XXGP_JDMS_SECTION_HEAD	JDMS Page for Section Head

ii) Properties:

Please select the type= SSWA jsp function.

iii)  Web HTML

Function	HTML Call
XXGP_JDMS	OA.jsp?page=/oracle/apps/ak/jdms/webui/HomePG
XXGP_JDMS_ADMIN_HOME	OA.jsp?page=/oracle/apps/ak/jdms/webui/AdminHomePG
XXGP_JDMS_DEPT_HEAD	OA.jsp?page=/oracle/apps/ak/jdms/webui/Department
XXGP_JDMS_DIV_HEAD	OA.jsp?page=/oracle/apps/ak/jdms/webui/DivisionPG
XXGP_JDMS_HR_ADMIN	OA.jsp?page=/oracle/apps/ak/jdms/webui/SearchPG
XXGP_JDMS_SECTION_HEAD	OA.jsp?page=/oracle/apps/ak/jdms/webui/SectionPG

  
Step 7: Create the responsibility.
For example:
JDMS for Section Head 

JDMS for HR Admin 

Step 8: Create Menus to add the responsibilities  into it.

For example:

Menu	JD VIEW FOR DEPARTMENT HEAD
User Menu Name	JD View For Department Head
Menu Type	Standard
Seq	Prompt	Function	Description
10	JD View For Department Head	XXGP_JDMS_DEPT_HEAD	JD View for Department Head
20	JD Creation	JD Managerment	JD Creation

Step 9. Assign the responsibilities into the corresponding menus.