9 Replies Latest reply on Nov 10, 2012 9:48 AM by 884536

    VO extension error

    884536
      Hi frnds,

      I need to attach a new EO to existing VO. all are standared components only. i done all the vo extension steps . but the page gives error as



      oracle.apps.fnd.framework.OAException: oracle.jbo.NoObjException: JBO-25003: Object PerApplicationsEO of type Entity Usage not found
           at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1223)
           at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
           at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2406)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1759)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
           at oa_html._OA._jspService(_OA.java:84)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at oa_html._OA._jspService(_OA.java:94)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      ## Detail 0 ##
      oracle.apps.fnd.framework.OAException: oracle.jbo.NoObjException: JBO-25003: Object PerApplicationsEO of type Entity Usage not found
           at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
           at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)
           at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
           at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
           at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:750)
           at oracle.apps.per.irc.candidateManagement.webui.CandidateApplicantDetailsCO.processRequest(CandidateApplicantDetailsCO.java:141)
           at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)
           at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
           at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)

      the extended VO query is given below.

      SELECT PASF.ASSIGNMENT_ID,
      PASF.EFFECTIVE_START_DATE,
      PASF.EFFECTIVE_END_DATE,
      PASF.BUSINESS_GROUP_ID,
      PASF.VACANCY_ID,
      PASF.JOB_ID,
      PASF.LOCATION_ID,
      PASF.CHANGE_REASON,
      PASF.APPLICANT_RANK,
      PAF.PERSON_ID,
      PAF.EFFECTIVE_START_DATE AS EFFECTIVE_START_DATE1,
      PAF.EFFECTIVE_END_DATE AS EFFECTIVE_END_DATE1,
      PAF.PARTY_ID,
      PAV.VACANCY_ID AS VACANCY_ID1,
      PAV.NAME,
      PAV.DESCRIPTION,
      HLA.LOCATION_ID AS LOCATION_ID1,
      HLA.LOCATION_CODE,
      HLA.DERIVED_LOCALE,
      PASF.ASSIGNMENT_STATUS_TYPE_ID,
      PAST.ASSIGNMENT_STATUS_TYPE_ID AS ASSIGNMENT_STATUS_TYPE_ID1,
      PAST.USER_STATUS,
      PASF.ASSIGNMENT_ID AS ASSIGNMENT_ID,
      ORG.ORGANIZATION_ID,
      ORG.NAME AS OrganizationName,
      IVSC.OBJECT_ID,
      IVSC.SEARCH_CRITERIA_ID,
      IVSC.OBJECT_TYPE,
      IVSC.EMPLOYEE,
      IVSC.CONTRACTOR,
      IVSC.MIN_SALARY,
      IVSC.MAX_SALARY,
      IVSC.SALARY_CURRENCY,
      IVSC.MAX_SALARY || ' ' || IVSC.SALARY_CURRENCY AS MAX_SALARY_WITH_CURR,
      DECODE (DECODE (Employee, 'Y', 1, 0) + DECODE (Contractor, 'Y', 2, 0),
      1, 'E',
      2, 'C',
      3, 'EC',
      'NA')
      AS EmployeeContractor,
      DECODE (
      offer.offer_status,
      'EXTENDED', 'Y',
      'PENDING_EXTENDED', 'Y',
      DECODE (
      (SELECT iosh.change_reason
      FROM irc_offer_Status_history iosh
      WHERE iosh.offer_id = offer.offer_id
      AND iosh.offer_status_history_id =
      (SELECT MAX (offer_status_history_id)
      FROM irc_offer_status_history iosh1
      WHERE iosh1.offer_id = offer.offer_id)),
      'APL_ACCEPTED', 'Y',
      DECODE (TO_CHAR (PASF.EFFECTIVE_END_DATE, 'DD-MM-RRRR'),
      '31-12-4712', 'N',
      'Y')))
      AS EndDated,
      PASF.ASS_ATTRIBUTE_CATEGORY,
      PASF.ASS_ATTRIBUTE1,
      PASF.ASS_ATTRIBUTE2,
      PASF.ASS_ATTRIBUTE3,
      PASF.ASS_ATTRIBUTE4,
      PASF.ASS_ATTRIBUTE5,
      PASF.ASS_ATTRIBUTE6,
      PASF.ASS_ATTRIBUTE7,
      PASF.ASS_ATTRIBUTE8,
      PASF.ASS_ATTRIBUTE9,
      PASF.ASS_ATTRIBUTE10,
      PASF.ASS_ATTRIBUTE11,
      PASF.ASS_ATTRIBUTE12,
      PASF.ASS_ATTRIBUTE13,
      PASF.ASS_ATTRIBUTE14,
      PASF.ASS_ATTRIBUTE15,
      PASF.ASS_ATTRIBUTE16,
      PASF.ASS_ATTRIBUTE17,
      PASF.ASS_ATTRIBUTE18,
      PASF.ASS_ATTRIBUTE19,
      PASF.ASS_ATTRIBUTE20,
      PASF.ASS_ATTRIBUTE21,
      PASF.ASS_ATTRIBUTE22,
      PASF.ASS_ATTRIBUTE23,
      PASF.ASS_ATTRIBUTE24,
      PASF.ASS_ATTRIBUTE25,
      PASF.ASS_ATTRIBUTE26,
      PASF.ASS_ATTRIBUTE27,
      PASF.ASS_ATTRIBUTE28,
      PASF.ASS_ATTRIBUTE29,
      PASF.ASS_ATTRIBUTE30,
      PAF.ATTRIBUTE_CATEGORY,
      PAF.ATTRIBUTE1,
      PAF.ATTRIBUTE2,
      PAF.ATTRIBUTE3,
      PAF.ATTRIBUTE4,
      PAF.ATTRIBUTE5,
      PAF.ATTRIBUTE6,
      PAF.ATTRIBUTE7,
      PAF.ATTRIBUTE8,
      PAF.ATTRIBUTE9,
      PAF.ATTRIBUTE10,
      PAF.ATTRIBUTE11,
      PAF.ATTRIBUTE12,
      PAF.ATTRIBUTE13,
      PAF.ATTRIBUTE14,
      PAF.ATTRIBUTE15,
      PAF.ATTRIBUTE16,
      PAF.ATTRIBUTE17,
      PAF.ATTRIBUTE18,
      PAF.ATTRIBUTE19,
      PAF.ATTRIBUTE20,
      PAF.ATTRIBUTE21,
      PAF.ATTRIBUTE22,
      PAF.ATTRIBUTE23,
      PAF.ATTRIBUTE24,
      PAF.ATTRIBUTE25,
      PAF.ATTRIBUTE26,
      PAF.ATTRIBUTE27,
      PAF.ATTRIBUTE28,
      PAF.ATTRIBUTE29,
      PAF.ATTRIBUTE30,
      PAF.PER_INFORMATION_CATEGORY,
      PAF.PER_INFORMATION1,
      PAF.PER_INFORMATION2,
      PAF.PER_INFORMATION3,
      PAF.PER_INFORMATION4,
      PAF.PER_INFORMATION5,
      PAF.PER_INFORMATION6,
      PAF.PER_INFORMATION7,
      PAF.PER_INFORMATION8,
      PAF.PER_INFORMATION9,
      PAF.PER_INFORMATION10,
      PAF.PER_INFORMATION11,
      PAF.PER_INFORMATION12,
      PAF.PER_INFORMATION13,
      PAF.PER_INFORMATION14,
      PAF.PER_INFORMATION15,
      PAF.PER_INFORMATION16,
      PAF.PER_INFORMATION17,
      PAF.PER_INFORMATION18,
      PAF.PER_INFORMATION19,
      PAF.PER_INFORMATION20,
      PAF.PER_INFORMATION21,
      PAF.PER_INFORMATION22,
      PAF.PER_INFORMATION23,
      PAF.PER_INFORMATION24,
      PAF.PER_INFORMATION25,
      PAF.PER_INFORMATION26,
      PAF.PER_INFORMATION27,
      PAF.PER_INFORMATION28,
      PAF.PER_INFORMATION29,
      PAF.PER_INFORMATION30,
      IPC.POSTING_CONTENT_ID,
      IPC.NAME AS NAME2,
      IAV.MANAGE_APPLICANTS_ALLOWED,
      IAV.AGENCY_VACANCY_ID,
      PAV.ASSESSMENT_ID,
      IPC.DETAILED_DESCRIPTION,
      IPC.JOB_REQUIREMENTS,
      IPC.HOW_TO_APPLY,
      PRA.DATE_START,
      PRA.RECRUITMENT_ACTIVITY_ID,
      PASF.SOURCE_TYPE,
      PASF.JOB_POST_SOURCE_NAME,
      HrLookupsEO.LOOKUP_TYPE,
      HrLookupsEO.LOOKUP_CODE,
      HrLookupsEO.MEANING,
      DECODE (
      DECODE (
      offer.offer_status,
      'EXTENDED', 'LINK',
      'PENDING_EXTENDED', DECODE (
      NVL (
      (SELECT ioff.offer_id
      FROM irc_offers ioff
      WHERE ioff.offer_id = offer.offer_id
      AND TRUNC (SYSDATE) <=
      ioff.expiry_date),
      0),
      0, 'TEXT',
      'LINK'),
      DECODE (
      NVL (
      (SELECT MAX (iosh.offer_id)
      FROM irc_offer_status_history iosh
      WHERE iosh.offer_id = offer.offer_id
      AND iosh.offer_status = 'CLOSED'
      AND iosh.CHANGE_REASON = 'APL_ACCEPTED'),
      0),
      0, 'TEXT',
      'LINK')),
      'TEXT', 'TEXT',
      'LINK', DECODE (
      NVL (
      (SELECT offer_extended_method
      FROM irc_offers ioff
      WHERE ioff.offer_id = offer.offer_id),
      (SELECT fnd_profile.VALUE ('IRC_OFFER_SEND_METHOD')
      FROM DUAL)),
      'HARDCOPY', 'TEXT',
      'SYSTEM', 'LINK'))
      AS OFFER_LINK_FLAG,
      PAF.FULL_NAME,
      PAF.EMAIL_ADDRESS,
      phone.PHONE_TYPE,
      phone.PHONE_NUMBER,
      phone.PHONE_ID,
      IAD.ASSIGNMENT_DETAILS_ID,
      IAD.ATTEMPT_ID,
      NVL (
      (SELECT 1
      FROM DUAL
      WHERE pasf.assignment_type = 'A'
      AND pasf.effective_end_date <= TRUNC (SYSDATE)),
      0)
      AS IS_TERMINATED_APPLICATION,
      IAD.QUALIFIED AS QUALIFIED,
      IAD.CONSIDERED AS CONSIDERED,
      IPC.JOB_TITLE,
      NVL (IAV.Manage_applicants_allowed, 'N') AS VAC_VIEW_ALLOWED,
      NVL2 (FND_PROFILE.VALUE ('IRC_AGENCY_NAME'), 'Y', 'N') AS VIEW_ATTR,
      PerApplicationsEO.APPL_ATTRIBUTE20,
      PerApplicationsEO.APPLICATION_ID
      FROM PER_ALL_ASSIGNMENTS_F PASF,
      PER_ALL_PEOPLE_F PAF,
      PER_ALL_VACANCIES PAV,
      HR_LOCATIONS_ALL_VL HLA,
      PER_ASSIGNMENT_STATUS_TYPES_V PAST,
      HR_ALL_ORGANIZATION_UNITS_VL ORG,
      IRC_SEARCH_CRITERIA IVSC,
      IRC_POSTING_CONTENTS_VL IPC,
      PER_ALL_PEOPLE_F PER,
      IRC_AGENCY_VACANCIES IAV,
      PER_RECRUITMENT_ACTIVITIES PRA,
      PER_RECRUITMENT_ACTIVITY_FOR PRF,
      HR_LOOKUPS HrLookupsEO,
      IRC_OFFERS offer,
      PER_PHONES phone,
      IRC_ASSIGNMENT_DETAILS_F IAD,
      PER_APPLICATIONS PerApplicationsEO

      The bold shows the newly attached EO and its attrbutes.but still how the error says EO not found ??
        • 1. Re: VO extension error
          884536
          any suggestions plz ..
          • 2. Re: VO extension error
            shreevat
            Try bouncing the server.

            Thanks
            Shree
            • 3. Re: VO extension error
              Sumit Chandra Sharma
              You are trying to extend a Standard VO and including the EO in the extended VO. Please confirm if this understanding is correct.
              Also try to highlight the logic behind this approach. May be we can also arrive at alternate solutions for the problem.

              Regards
              Sumit
              • 4. Re: VO extension error
                884536
                Hi ,

                Shreevat@i tried bouncing the apche but no luck.

                Sumit @ your understading is right .

                I need to add a column called appl_attribute20 which is there in PerApplicationsEO
                right now the VO is based on some EO's
                PerAllpeopleEO
                HrLookupEO
                PerAllAssignmentsEO
                IrcOffersEO
                .
                .
                .
                .
                .
                so, to add this PerApplicationsEO to the VO , i have extended the standared VO

                Steps i followed for Vo extension was:
                1.downloaded the standared VO from the server to my jdev
                2.created a new package xx.oracle.apps.per.irc.applicant.server
                3.downloaded all the realted EO for the Vo to the project
                4.created a new VO named xxApplicationDetailsVO
                5.attached the New EO i.e PerApplicationsEO to the custom VO
                6.modified the query in expert mode
                7.finished the vo extn
                8.manually modified the VO.xml file to convert the newly added attributes from transient to calculated attribute.

                Regards
                Gk

                Edited by: 881533 on Oct 18, 2012 6:19 AM
                • 5. Re: VO extension error
                  Sumit Chandra Sharma
                  Anyway only one of the EO can be updateable and others are just as aliases. You dont need to add the EO (if this is not the updateable EO for this VO). All you need to do is extend the VO and include the additional column in the query and get this attributed added in the VO.

                  Please check if that helps.

                  Regards
                  • 6. Re: VO extension error
                    884536
                    Sumit,

                    its a updatable EO,

                    Edited by: 881533 on Nov 6, 2012 3:27 PM
                    • 7. Re: VO extension error
                      884536
                      any updates on this pls, iam still facing this isssue...
                      • 8. Re: VO extension error
                        Sumit Chandra Sharma
                        If its updateable EO, then please extend and substitute the EO itself. Thereafter its easy to include the additional EO mapped attribute in the VO.
                        1 person found this helpful
                        • 9. Re: VO extension error
                          884536
                          Sumit,

                          thanks a lot, i was able to complete the Eo extn and VO extn also, before closing this thread i have a small doubt:

                          if i create a dynamic VO in controller using below code
                          String xxOnTheFlyVOQuery = "select description xxdesc from fnd_user ";
                          ViewObject xxOnTheFlyViewObject = oam.findViewObject("xxFNDUserDescVO");
                          if(xxOnTheFlyViewObject == null)
                          xxOnTheFlyViewObject = oam.createViewObjectFromQueryStmt("xxFNDUserDescVO", xxOnTheFlyVOQuery);
                          xxOnTheFlyViewObject.setWhereClauseParams(null);
                          xxOnTheFlyViewObject.executeQuery();

                          The view attribute for the VO will be considered as xxdesc ??
                          or do i need to add the attribute using xxFNDUserDescVO.addDynamicAttribute("xxdesc") .