Skip to main content

Posts

Showing posts from September, 2013

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 SEQUEN...