{"id":13380,"date":"2014-12-13T13:22:13","date_gmt":"2014-12-13T13:22:13","guid":{"rendered":"http:\/\/www.erpschools.com\/?p=13380"},"modified":"2014-12-14T04:55:44","modified_gmt":"2014-12-14T04:55:44","slug":"create-page-input-employee-details","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details","title":{"rendered":"Create Page to input Employee details"},"content":{"rendered":"

Inserting Data<\/b><\/p>\n

Create EmpEO<\/b><\/p>\n

Step1: Right click on Resources and select New Entity Object<\/p>\n

\"image1\"<\/p>\n

 <\/p>\n

Step2: Specify the name = EmpEO, Package=trng2.oracle.apps.ak.emp.schema.server (as EO will be in schema.server). Extends Entity will be given if we are customizing so leave blank<\/p>\n

Under database objects check \u201cSynonyms\u201d check box so schema objects will be populated to select. It will take some time to generate this list. Select Schema Object as \u201cFWK_TBX_EMPLOYEES\u201d<\/p>\n

\"image2\"<\/p>\n

 <\/p>\n

Step3: It shows all available attributes. If required we can create new transient attributes. Transient attributes are those which we can refer only in application but doesn\u2019t exist in database. We can learn more about transient attribute down the line<\/p>\n

\"image3\"<\/p>\n

 <\/p>\n

Step4: In next step you can see properties of all attributes. They will by default will get generated as per table definition. Please note that there should be one primary attribute in order to create EO. Also there should who columns<\/p>\n

\"image4\"<\/p>\n

 <\/p>\n

Step5: Under Entity Object Class \uf0e0 Generate Java File opt for Accessors, Create method and Remove method<\/p>\n

\"image5\"<\/p>\n

 <\/p>\n

Step6: Don\u2019t select anything here as we will be creating VO separately. You can check this if you want to create VO immediately<\/p>\n

\"image6\"<\/p>\n

 <\/p>\n

Step7: Click Finish<\/p>\n

\"image7\"<\/p>\n

 <\/p>\n

This will create EmpEOImpl.java file with all required fields. This java file will have create method which can be used for defaulting attributes<\/p>\n

Here for EMPLOYEE_ID, the value should get from sequence. So we can this attribute with sequence value.<\/p>\n

In EmpEOImpl.java \uf0e0 Create method looks as below after writing the required code<\/p>\n

public void create(AttributeList attributeList) {<\/p>\n

super.create(attributeList);<\/p>\n

OADBTransaction transaction = getOADBTransaction();\u00a0 \/\/gets transaction handler from super class<\/p>\n

Number seqNo = transaction.getSequenceValue(“FWK_TBX_EMPLOYEES_S”);<\/p>\n

setEmployeeId(seqNo);<\/p>\n

}<\/p>\n

Note:<\/b> if this is not handled in EO, we can also implement at VO level at the time new record creation.<\/p>\n

OAViewObject vo = (OAViewObject)findViewObject(“EmpVO”);<\/p>\n

OARow row = (OARow)vo.first();<\/p>\n

row.setAttribute(“EmployeeId”, getOADBTransaction().getSequenceValue(“FWK_TBX_EMPLOYEES_S”).toString());<\/p>\n

Creating VO<\/b><\/p>\n

Step1: Right click on Resources and select New View Object<\/p>\n

\"image8\"<\/p>\n

 <\/p>\n

Step2: Specify package = trng2.oracle.apps.ak.emp.server and Name = EmpVO<\/p>\n

Extends we can leave blank as we are not extending or customizing existing VO.<\/p>\n

VO can be create either with EO or direct SQL Query. Sql Query is used only when we need read only data. As we are using this VO to DML make sure to select \u201cRows Populated by a SQL Query with\u201d \uf0e0 \u201cUpdatable Access through Entity Object\u201d<\/p>\n

\"image9\"<\/p>\n

 <\/p>\n

Step3: Select EmpEO from Available list and move to Selected<\/p>\n

\"image10\"<\/p>\n

 <\/p>\n

Step4: Select the attributes you want in VO. You can select all or required attributes only. Here selected all attributes except who columns and dff attribute columns<\/p>\n

\"image11\"<\/p>\n

 <\/p>\n

Step5: In attribute setting verify default information is correct<\/p>\n

\"image12\"<\/p>\n

 <\/p>\n

Step6: In Query page check query generated is correct. You can specify where and order clause if required. To edit the query check \u201cExper Mode\u201d<\/p>\n

\"image13\"<\/p>\n

 <\/p>\n

Step7: You can see view attribute names and can skip this step<\/p>\n

\"image14\"<\/p>\n

 <\/p>\n

Step8: You can define custom bind variables if required. You can skip this<\/p>\n

\"image15\"<\/p>\n

 <\/p>\n

Step9: You can uncheck Generate Java File under View Object Class unless you want to write code in VO. Check Generate Java File with Accessors for View Row Class<\/p>\n

\"image16\"<\/p>\n

 <\/p>\n

This creates EmpVO.xml and EmpVORowImpl.java<\/p>\n

\"image17\"<\/p>\n

 <\/p>\n

Creating AM<\/b><\/p>\n

Step1: Right click on Resources and select New Application Module<\/p>\n

\"image18\"<\/p>\n

 <\/p>\n

Step2: Specify package= trng2.oracle.apps.ak.emp.server and Name=EmpAM<\/p>\n

Leave Extends blank<\/p>\n

\"image19\"<\/p>\n

 <\/p>\n

Step3: Select EmpVO to associate with AM by moving to data model<\/p>\n

\"image20\"<\/p>\n

 <\/p>\n

Please note that in Data model you can see VO name as EmpVO1 which is instance of actual VO<\/p>\n

Step4: Skip this step by clicking Next<\/p>\n

\"image21\"<\/p>\n

 <\/p>\n

Step5: See Generate Java File under Application Module Class is checked<\/p>\n

\"image22\"<\/p>\n

 <\/p>\n

Step6: Click Finish<\/p>\n

\"image23\"<\/p>\n

 <\/p>\n

This creates EmpAMImpl.java<\/p>\n

\"image24\"<\/p>\n

 <\/p>\n

Designing various UI components for EmpCreatePG<\/b><\/p>\n

Creation of Manager LOV:<\/b><\/p>\n

Step1:<\/b> Create common LOV AM which will be used for all LOVs that used in employee application<\/p>\n

Right click on resources and New Application Module and specify package = trng2.oracle.apps.ak.emp.lov.server and Name=EmpLovAM<\/p>\n

\"image25\"<\/p>\n

 <\/p>\n

Skip next two steps as we are not selecting any VOs now and in last step UNCHECK \u201cGenerate Java Files\u201d as there is no need of coding for LOV AMs. Click on finish in last step<\/p>\n

\"image26\"<\/p>\n

 <\/p>\n

Step2:<\/b> Create MgrLovVO. Right click on Resources and select New View Object<\/p>\n

Specify package = trng2.oracle.apps.ak.emp.lov.server<\/p>\n

Name = MgrLovVO<\/p>\n

\"image27\"<\/p>\n

 <\/p>\n

Skip next 3 steps by clicking next and until you get SQL Statement step. Here specify the query as<\/p>\n

SELECT full_name AS EMPLOYEE_NAME,<\/p>\n

employee_id\u00a0 \u00a0 AS EMPLOYEE_NUMBER,<\/p>\n

email_address<\/p>\n

FROM fwk_tbx_employees<\/p>\n

WHERE end_date IS NULL<\/p>\n

\"image28\"<\/p>\n

 <\/p>\n

Skip all next steps by selecting next until last Java step. Uncheck Generate Java File under MgrLovVOImpl and check Generate Java File under MgrLovVORowImpl and click finish<\/p>\n

\"image29\"<\/p>\n

 <\/p>\n

Step3:<\/b> Add MgrLovVO to EmpLovAM<\/p>\n

Right click on EmpLovAM in Application Navigator and select Edit EmpLovAM<\/p>\n

\"image30\"<\/p>\n

 <\/p>\n

In Data Model select MgrLovVO from Available View Objects and move to right under Data Model<\/p>\n

\"image31\"<\/p>\n

 <\/p>\n

Step4:<\/b> Create region for LOV<\/p>\n

Right click on Resources and select New<\/p>\n

Under Web Tier > OA Components select Region<\/p>\n

\"image32\"<\/p>\n

 <\/p>\n

Specify Name = MgrLovRN<\/p>\n

Package = trng2.oracle.apps.ak.emp.lov.webui<\/p>\n

Style=listOfValues<\/p>\n

\"image33\"<\/p>\n

 <\/p>\n

Select MgrLovRN in structure pane and set AM Definition = trng2.oracle.apps.ak.emp.lov.server.EmpLovAM<\/p>\n

Advanced Search Allowed = True<\/p>\n

Scope = Public<\/p>\n

\"image34\"<\/p>\n

 <\/p>\n

Right click on MgrLovRN in structure pane and select New > table using Wizard<\/p>\n

\"image35\"<\/p>\n

 <\/p>\n

Select Application Module = trng2.oracle.apps.ak.emp.lov.server.EmpLovAM and MgrLovVO1<\/p>\n

\"image36\"<\/p>\n

Set RegionID=MgrNamesTable<\/p>\n

\"image37\"<\/p>\n

Select all columns and move to right<\/p>\n

\"image38\"<\/p>\n

Skip next steps and finally select finish<\/p>\n

\"image39\"<\/p>\n

For EmployeeName and EmployeeNumber in structure pane set Search allowed to True. This makes LOV to have search items automatically on this field<\/p>\n

Creating VO for Implementing Message Choice (drop down \/ poplist) for positions attribute<\/b><\/p>\n

Step1: Create PositionsVO by right clicking on Resources and select New View Object<\/p>\n

Specify Package = trng2.oracle.apps.ak.emp.poplist.server<\/p>\n

Name = PositionsVO<\/p>\n

\"image40\"<\/p>\n

Step2: Skip to query step and specify below query<\/p>\n

SELECT meaning, lookup_code<\/p>\n

FROM fwk_tbx_lookup_codes_vl<\/p>\n

WHERE lookup_type = ‘FWK_TBX_POSITIONS’<\/p>\n

\"image41\"<\/p>\n

Step3: Skip to last to step and uncheck Generate Java File for PositionsVOImpl and check Generate Java File for PositionsVORowImpl<\/p>\n

\"image42\"<\/p>\n

Step4: Assign PositionsVO to EmpAM<\/p>\n

Right click on EmpAM in Application navigator and select edit EmpAM<\/p>\n

\"image43\"<\/p>\n

And move PositionsVO from available view objects to Data model<\/p>\n

\"image44\"<\/p>\n

 <\/p>\n

Designing the Page to Input Employee Details<\/b><\/p>\n

Creating page to input below employee data<\/p>\n

    \n
  1. EMPLOYEE_ID (This will be generated automatically and we used sequence in EO to derive this values. So no need of UI item for this attribute)<\/li>\n
  2. TITLE<\/li>\n
  3. FIRST_NAME<\/li>\n
  4. MIDDLE_NAME<\/li>\n
  5. LAST_NAME<\/li>\n
  6. FULL_NAME<\/li>\n
  7. EMAIL_ADDRESS<\/li>\n
  8. MANAGER_ID<\/li>\n
  9. POSITION_CODE<\/li>\n
  10. SALARY<\/li>\n
  11. START_DATE<\/li>\n<\/ol>\n

    Step1: Right click on Resources and select New<\/p>\n

    \"image45\"<\/p>\n

    Step2: Select Page under Web Tier > OA Components<\/p>\n

    \"image46\"<\/p>\n

    Step3: Specify Name=EmpCreatePG and Package= trng2.oracle.apps.ak.emp.webui<\/p>\n

    \"image47\"<\/p>\n

    Step4: Set default pageLayout region1 properties as below<\/p>\n

    ID=PageLayoutRN<\/p>\n

    AM Definition= trng2.oracle.apps.ak.emp.server.EmpAM<\/p>\n

    Window Title = Create Employee<\/p>\n

    Title = Employee Details<\/p>\n

    Warn About Changes = True (this enable page to warn pending transaction when user tries to navigate from this page. Cancel button is exception)<\/p>\n

    \"image48\"<\/p>\n

    Step5: To Create Page level buttons Apply and Cancel buttons<\/p>\n

    First select PageLayoutRN in structure pane, then right click and select New > Region<\/p>\n

    Set properties as below for this region<\/p>\n

    ID=PageButtons<\/p>\n

    Region Style=pageButtonBar<\/p>\n

    Next to add Cancel button, right click on PageButtons in the structure pane and select New > Item. Set or verify properties of this item as below<\/p>\n

    ID=Cancel<\/p>\n

    Item Style=submitButton<\/p>\n

    Attribute Set= \/oracle\/apps\/fnd\/attributesets\/Buttons\/Cancel<\/p>\n

    Disable Server Side Validation = True (will not perform server validations)<\/p>\n

    Disable Client Side Validation=True (will not perform client side validations)<\/p>\n

    Prompt=Cancel<\/p>\n

    Warn About Changes=False<\/p>\n

    Next to add Apply button, Right click on PageButtons in structure pane and select New\uf0e0Item. Set or verify properties of this item as below<\/p>\n

    ID=Apply<\/p>\n

    Item Style= submitButton<\/p>\n

    Attribute Set= \/oracle\/apps\/fnd\/attributesets\/Buttons\/Apply<\/p>\n

    Prompt=Apply<\/p>\n

    \"image49\"<\/p>\n

    Step2: Right click on PageLayoutRN of EmpCreatePG in structure panel and select New \uf0e0 Region<\/p>\n

    Step3: Set region properties as follows<\/p>\n

    ID=MainRN<\/p>\n

    Region Style = messageComponentLayout<\/p>\n

    Step4: Under MainRN create items as below<\/p>\n

      \n
    1. MessageStyledText (for Employee ID)<\/li>\n<\/ol>\n

      ID=EmpId<\/p>\n

      Data Type = NUMBER<\/p>\n

      View Instance = EmpVO1<\/p>\n

      View Attribute = EmployeeId<\/p>\n

      Prompt = Employee Number<\/p>\n

        \n
      1. Creating radio buttons for Title<\/li>\n<\/ol>\n

        In OAF radio buttons on UI behaves as individual unless you group them programmatically. So that it will allows to select one radio button from group. At run time you need to set name and value for each radio button. Radion buttons having same name will be a group.<\/p>\n

          \n
        1. messageRadioButton<\/li>\n<\/ol>\n

          ID=TitleMr<\/p>\n

          View Instance = EmpVO1<\/p>\n

          View Attribute = Title<\/p>\n

          Prompt = Mr<\/p>\n

          Checked Value = Mr<\/p>\n

            \n
          1. messageRadioButton<\/li>\n<\/ol>\n

            ID=TitleMrs<\/p>\n

            View Instance = EmpVO1<\/p>\n

            View Attribute = Title<\/p>\n

            Prompt = Mrs<\/p>\n

            Checked Value = Mrs<\/p>\n

              \n
            1. \u00a0 \u00a0 messageRadioButton<\/li>\n<\/ol>\n

              ID=TitleMiss<\/p>\n

              View Instance = EmpVO1<\/p>\n

              View Attribute = Title<\/p>\n

              Prompt = Miss<\/p>\n

              Checked Value = Miss<\/p>\n

                \n
              1. MessageTextInput<\/li>\n<\/ol>\n

                ID=FirstName<\/p>\n

                Maximum Length=20<\/p>\n

                View Instance = EmpVO1<\/p>\n

                View Attribute = FirstName<\/p>\n

                Prompt = First Name<\/p>\n

                  \n
                1. MessageTextInput<\/li>\n<\/ol>\n

                  ID=LastName<\/p>\n

                  Maximum Length=40<\/p>\n

                  View Instance = EmpVO1<\/p>\n

                  View Attribute = LastName<\/p>\n

                  Prompt = Last Name<\/p>\n

                    \n
                  1. MessageTextInput<\/li>\n<\/ol>\n

                    ID=EmailAddr<\/p>\n

                    Maximum Length=240<\/p>\n

                    View Instance = EmpVO1<\/p>\n

                    View Attribute = EmailAddress<\/p>\n

                    Prompt = Email<\/p>\n

                      \n
                    1. MessageLovInput<\/li>\n<\/ol>\n

                      ID=MgrId<\/p>\n

                      External LOV = \/trng2\/oracle\/apps\/ak\/emp\/lov\/webui\/MgrLovRN<\/p>\n

                      (note: if any confirmation message displays select yes)<\/p>\n

                      Maximum Length=240<\/p>\n

                      View Instance = EmpVO1<\/p>\n

                      View Attribute = ManagerId<\/p>\n

                      Prompt = Manager<\/p>\n

                        \n
                      1. If we create message lov input, it will have lovMappings under this item in structure panel<\/li>\n<\/ol>\n

                        \"image50\"<\/p>\n

                        By default it will have one mapping item but we can create any number of mapping items. This is used to map item of LOV to current page item<\/p>\n

                        Set lovMap1 properties as below<\/p>\n

                        LOV Region Item = EmployeeNumber<\/p>\n

                        Return Item = MgrId<\/p>\n

                        Criteria Item = MgrId<\/p>\n

                          \n
                        1. MessageChoice<\/li>\n<\/ol>\n

                          ID=Position<\/p>\n

                          Picklist View Definition= trng2.oracle.apps.ak.emp.poplist.server.PositionsVO<\/p>\n

                          (Note: for picklist view def you need to specify actual VO name. for view instance you have to specify instance name like PositionsVO1)<\/p>\n

                          Picklist Display Attribute = Meaning<\/p>\n

                          PIcklist Value Attribute=LookupCode<\/p>\n

                          View Instance = EmpVO1<\/p>\n

                          View Attribute = PositionCode<\/p>\n

                          Prompt = Position<\/p>\n

                            \n
                          1. MessageTextInput<\/li>\n<\/ol>\n

                            ID=Salary<\/p>\n

                            Data Type = NUMBER<\/p>\n

                            View Instance = EmpVO1<\/p>\n

                            View Attribute = Salary<\/p>\n

                            Prompt = Salary<\/p>\n

                              \n
                            1. MessageTextInput<\/li>\n<\/ol>\n

                              ID=StartDate<\/p>\n

                              Data Type = DATE<\/p>\n

                              View Instance = EmpVO1<\/p>\n

                              View Attribute = StartDate<\/p>\n

                              Prompt = Start Date<\/p>\n

                                \n
                              1. MessageTextInput<\/li>\n<\/ol>\n

                                ID=EndDate<\/p>\n

                                Data Type = DATE<\/p>\n

                                View Instance = EmpVO1<\/p>\n

                                View Attribute = EndDate<\/p>\n

                                Prompt = End Date<\/p>\n

                                Create Controller for EmpCreatePG<\/b><\/p>\n

                                Step1: Right click on PageLayoutRN region in EmpCreatePG and \u201cSet New Controller\u201d<\/p>\n

                                \"image51\"<\/p>\n

                                Step2: Specify Package= trng2.oracle.apps.ak.emp.webui and Name= EmpCreateCO<\/p>\n

                                \"image52\"<\/p>\n

                                Row Initialization to create a new record<\/b><\/p>\n

                                Before providing values to VO need to create a VO row. This VO row will receive values when form submitted.<\/p>\n

                                 <\/p>\n

                                Step1: Add createEmployee() method in EmpAMImpl.java<\/p>\n

                                public void createEmployee()<\/p>\n

                                {<\/p>\n

                                OAViewObject vo = (OAViewObject)getEmpVO1();<\/p>\n

                                \/\/ below initializes the VO used for both update and query as per<\/p>\n

                                \/\/ standards but not mandatory<\/p>\n

                                if (!vo.isPreparedForExecution())<\/p>\n

                                {<\/p>\n

                                vo.executeQuery();<\/p>\n

                                }<\/p>\n

                                Row row = vo.createRow();<\/p>\n

                                vo.insertRow(row);<\/p>\n

                                \/\/ Required per OA Framework Model Coding Standard but not mandatory<\/p>\n

                                row.setNewRowState(Row.STATUS_INITIALIZED);<\/p>\n

                                }<\/p>\n

                                Step2: Add apply method which is used to commit the pending transaction at AM level<\/p>\n

                                public void apply()<\/p>\n

                                {<\/p>\n

                                getTransaction().commit();<\/p>\n

                                }<\/p>\n

                                Step3: Add rollback method which is used to rollback the pending transaction at AM level<\/p>\n

                                public void rollbackTxn()<\/p>\n

                                {<\/p>\n

                                getTransaction().rollback();<\/p>\n

                                }<\/p>\n

                                Write below code in EmpCreateCO.java in processRequest method to set group for radio buttons used for Title column. It should be under super constructor in processRequest method. Otherwise they will not behave as a group<\/b><\/p>\n

                                public void processRequest(OAPageContext pageContext, OAWebBean webBean)<\/p>\n

                                {<\/p>\n

                                super.processRequest(pageContext, webBean);<\/p>\n

                                OAMessageRadioButtonBean rbMr = (OAMessageRadioButtonBean) webBean.findChildRecursive(“TitleMr”);<\/p>\n

                                rbMr.setName(“Title”);<\/p>\n

                                rbMr.setValue(“Mr”);<\/p>\n

                                OAMessageRadioButtonBean rbMiss = (OAMessageRadioButtonBean) webBean.findChildRecursive(“TitleMiss”);<\/p>\n

                                rbMiss.setName(“Title”);<\/p>\n

                                rbMiss.setValue(“Miss”);<\/p>\n

                                OAMessageRadioButtonBean rbMrs = (OAMessageRadioButtonBean) webBean.findChildRecursive(“TitleMrs”);<\/p>\n

                                rbMrs.setName(“Title”);<\/p>\n

                                rbMrs.setValue(“Mrs”);<\/p>\n

                                if (!pageContext.isFormSubmission())<\/p>\n

                                {<\/p>\n

                                \/\/below two statements can also be used to call AM method<\/p>\n

                                \/\/ \u00a0 \u00a0 \u00a0 OAApplicationModule am = pageContext.getApplicationModule(webBean);<\/p>\n

                                \/\/ \u00a0 \u00a0 \u00a0 am.invokeMethod(“createEmployee”,null);<\/p>\n

                                EmpAMImpl am = (EmpAMImpl)pageContext.getApplicationModule(webBean);<\/p>\n

                                am.createEmployee();<\/p>\n

                                }<\/p>\n

                                Step4: In processFormRequest of EmpCreateCO write below code which will execute on clicking apply or cancel button<\/p>\n

                                public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)<\/p>\n

                                {<\/p>\n

                                super.processFormRequest(pageContext, webBean);<\/p>\n

                                OAApplicationModule am = pageContext.getApplicationModule(webBean);<\/p>\n

                                if (pageContext.getParameter(“Apply”) != null)<\/p>\n

                                {<\/p>\n

                                am.invokeMethod(“apply”);<\/p>\n

                                }<\/p>\n

                                if (pageContext.getParameter(“Cancel”) != null)<\/p>\n

                                {<\/p>\n

                                am.invokeMethod(“rollbackTxn”);<\/p>\n

                                }<\/p>\n

                                }<\/p>\n

                                To default FullName<\/b><\/p>\n

                                In EmpEOImpl.java add highlighted code in below two methods<\/b><\/p>\n

                                public void setFirstName(String value) {<\/p>\n

                                if ((value != null) || (!(“”.equals(value.trim()))))<\/p>\n

                                {<\/p>\n

                                String lastName = getLastName();<\/p>\n

                                if (lastName == null)<\/p>\n

                                {<\/p>\n

                                lastName = “”;<\/p>\n

                                }<\/p>\n

                                setFullName(lastName.concat(“, “).concat(value));<\/p>\n

                                }<\/p>\n

                                setAttributeInternal(FIRSTNAME, value);<\/p>\n

                                }<\/p>\n

                                 <\/p>\n

                                public void setLastName(String value) {<\/p>\n

                                if ((value != null) || (!(“”.equals(value.trim()))))<\/p>\n

                                {<\/p>\n

                                String firstName = getFirstName();<\/p>\n

                                if (firstName == null)<\/p>\n

                                {<\/p>\n

                                firstName = “”;<\/p>\n

                                }<\/p>\n

                                setFullName(value.concat(“, “).concat(firstName));<\/p>\n

                                }<\/p>\n

                                setAttributeInternal(LASTNAME, value);<\/p>\n

                                }<\/p>\n

                                Validating start date not to be less than sysdate<\/b><\/p>\n

                                In EmpEOImpl.java add highlighted code in below method<\/b><\/p>\n

                                public void setStartDate(Date value) {<\/p>\n

                                \u00a0 \u00a0 \u00a0 \u00a0 <\/b>validateStartDate(value);<\/b><\/p>\n

                                setAttributeInternal(STARTDATE, value);<\/p>\n

                                }<\/p>\n

                                Write validateStartDate method in EmpEOImpl.java as below<\/b><\/p>\n

                                OADBTransaction transaction = getOADBTransaction();<\/p>\n

                                long sysdate = transaction.getCurrentDBDate().dateValue().getTime();<\/p>\n

                                long startDate = value.dateValue().getTime();<\/p>\n

                                if (startDate < sysdate)<\/p>\n

                                {<\/p>\n

                                throw new OAAttrValException(OAException.TYP_ENTITY_OBJECT,<\/p>\n

                                getEntityDef().getFullName(), \/\/ EO name<\/p>\n

                                getPrimaryKey(), \/\/ EO PK<\/p>\n

                                “StartDate”, \/\/ Attribute Name<\/p>\n

                                value, \/\/ Attribute value<\/p>\n

                                “AK”, \/\/ Message product short name<\/p>\n

                                “FWK_TBX_T_START_DATE_PAST”); \/\/ Message name<\/p>\n

                                }<\/p>\n","protected":false},"excerpt":{"rendered":"

                                Inserting Data Create EmpEO Step1: Right click on Resources and select New Entity Object   Step2: Specify the name = EmpEO, Package=trng2.oracle.apps.ak.emp.schema.server (as EO will be in schema.server). Extends Entity will be given if we are customizing so leave blank Under database objects check \u201cSynonyms\u201d check box so schema objects will be populated to select. […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111],"tags":[],"class_list":["post-13380","post","type-post","status-publish","format-standard","hentry","category-oracle-application-framework-articles"],"yoast_head":"\nCreate Page to input Employee details - erpSchools<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Narasimha\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details\"},\"author\":{\"name\":\"Narasimha\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/46075962b877fb633e20447c79725736\"},\"headline\":\"Create Page to input Employee details\",\"datePublished\":\"2014-12-13T13:22:13+00:00\",\"dateModified\":\"2014-12-14T04:55:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details\"},\"wordCount\":2225,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/image117.png\",\"articleSection\":[\"OAF\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details\",\"url\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details\",\"name\":\"Create Page to input Employee details - erpSchools\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/image117.png\",\"datePublished\":\"2014-12-13T13:22:13+00:00\",\"dateModified\":\"2014-12-14T04:55:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#primaryimage\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/image117.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/image117.png\",\"width\":469,\"height\":593},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create Page to input Employee details\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/46075962b877fb633e20447c79725736\",\"name\":\"Narasimha\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a59a4c3c2b563e3560b2e9c020c8178d6315e50ed3fed9d668de1170c726c4b?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a59a4c3c2b563e3560b2e9c020c8178d6315e50ed3fed9d668de1170c726c4b?s=96&d=blank&r=g\",\"caption\":\"Narasimha\"},\"url\":\"https:\/\/erpschools.com\/erps\/author\/narasimha\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Page to input Employee details - erpSchools","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details","twitter_misc":{"Written by":"Narasimha","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details"},"author":{"name":"Narasimha","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/46075962b877fb633e20447c79725736"},"headline":"Create Page to input Employee details","datePublished":"2014-12-13T13:22:13+00:00","dateModified":"2014-12-14T04:55:44+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details"},"wordCount":2225,"commentCount":1,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/image117.png","articleSection":["OAF"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details","url":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details","name":"Create Page to input Employee details - erpSchools","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/image117.png","datePublished":"2014-12-13T13:22:13+00:00","dateModified":"2014-12-14T04:55:44+00:00","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#primaryimage","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/image117.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/image117.png","width":469,"height":593},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/oracle-application-framework-articles\/create-page-input-employee-details#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Create Page to input Employee details"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/46075962b877fb633e20447c79725736","name":"Narasimha","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a59a4c3c2b563e3560b2e9c020c8178d6315e50ed3fed9d668de1170c726c4b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a59a4c3c2b563e3560b2e9c020c8178d6315e50ed3fed9d668de1170c726c4b?s=96&d=blank&r=g","caption":"Narasimha"},"url":"https:\/\/erpschools.com\/erps\/author\/narasimha"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/13380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=13380"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/13380\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=13380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=13380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=13380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}