Oracle Applications E-Learning Lab

OAF Page Deployment Steps   This article will guide you towards the steps to follow OAF page deployment in Oracle Ebusiness Suite . In following  Steps , we  will create   a simple Lov Search Page and then migrate it in Ebusiness Suite .  1. Create a new Project under application and while creating Project Select Items as  " Workspace Configured Oracle Applications " , Provide the Project Name and Click on "Ok" After providing Project Name , another Wizard appears which asks you to enter the default package.  Remember whatever structure we going to provide in Default package , the same structure needs to  be created as a path under $JAVA_TOP/classes  directory in server. In our case we are structuring out default package as  "xxnuc.oracle.apps.ak.lov" Based on the above structure , same path needs to be created in the Application Server. after specifying default package and then Click on Next 

OAF stands for Oracle Applications Framework. This particular technology will be used to  develop Application pages , all pages will be of Web base. In Previous versions of Oracle Ebiz , Oracle Forms has been widely used to develop transactions forms , but due to its heavy nature & Time consuming Performance ,it becomes very  difficult to carry out Business operations. To improve the Performance , Oracle has introduced OAF. Oracle Application Framework (OAF) is an architecture for creating web based pages with in Oracle EBS platform.  OAF functionality can be achieved using JDEVELOPER Tool. OAF follows MVC architecute. MVC stands for Module View Controller Architecture  Schematic representation of MVC Architecture  Model (bc4j Component) Model contains the BC4J Components or objects which handles data directly from Database. It Includes Business Components for Java (BC4J Objects) which mainly are: • Entity Object • View Object • Application Module

1. Below Code will create Contact Point in Oracle . DECLARE    P_CONTACT_POINT_REC   HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;    P_PHONE_REC           HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;    P_EDI_REC_TYPE        HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;    P_EMAIL_REC_TYPE      HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;    P_TELEX_REC_TYPE      HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;    P_WEB_REC_TYPE        HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;    X_RETURN_STATUS       VARCHAR2 (1000);    X_CONTACT_POINT_ID    NUMBER;    X_MSG_COUNT           NUMBER;    X_MSG_DATA            VARCHAR2 (1000); BEGIN    P_CONTACT_POINT_REC.CONTACT_POINT_TYPE := 'EMAIL';    P_CONTACT_POINT_REC.OWNER_TABLE_NAME := 'HZ_PARTIES';    P_CONTACT_POINT_REC.OWNER_TABLE_ID := 150336; ---L_ORG_PARTY_ID; commented by  pranay tiwari on 05-Jun-2014    P_CONTACT_POINT_REC.CREATED_BY_MODULE := 'TCA_V2_API';    ----email    P_EMAIL_REC_TYPE.EMAIL_FORMAT := 'MAILHTML';