2 Replies Latest reply: Oct 11, 2012 6:33 AM by John van der Kooij RSS

    which job

    user522961
      Hi,
      on HR91 , tools 8.52, database ORACLE 11g R2, I have this error in oracle alertlog :

      ORA-07445: exception found : dump noyau [evaopn3()+1779] [ACCESS_VIOLATION] [ADDR:0x4] [PC:0x1428547A9] [UNABLE_TO_READ] []

      And the query is :
      SELECT FILL.HRS_PERSON_ID,FILL.HRS_RCMNT_ID,FILL.OPRID,TO_CHAR(CAST((FILL.HRS_SUBMITTED_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),FILL.LAST_NAME_SRCH,FILL.FIRST_NAME_SRCH,FILL.NAME_DISPLAY,FILL.APP_PER_STATUS,FILL.HRS_PROFILE_SEQ,FILL.HRS_JOB_OPENING_ID,FILL.STATUS_CODE,FILL.HRS_STATUS_CODE,FILL.DESCR,FILL.STATUS_REASON,TO_CHAR(FILL.HRS_STATUS_DT,'YYYY-MM-DD'),FILL.ENTRY_SOURCE,TO_CHAR(FILL.ENTRY_DATE,'YYYY-MM-DD'),FILL.PREV_EMPL_BY_COMPY,TO_CHAR(CAST((FILL.HRS_ROW_ADD_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),FILL.HRS_ROW_ADD_OPRID,TO_CHAR(CAST((FILL.HRS_ROW_UPD_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),FILL.HRS_ROW_UPD_OPRID,FILL.HIGHEST_EDUC_LVL,FILL.DEPTID,FILL.JPM_CAT_ITEM_QUAL2 FROM PS_HRS_FIND_RSLT_I FILL  where HRS_RCMNT_ID = :1 AND HRS_PERSON_ID = :2
      How to know which peoplesoft job runs this query ?

      Thank you
        • 1. Re: which job
          user522961
          OK.
          • 2. Re: which job
            John van der Kooij
            I would start with opening the record definition HRS_FIND_RSLT_I in AppDesigner, checking its object references.

            In an 8.52.09 environment this would be:
            Searching for references to record HRS_FIND_RSLT_I ...
            Used by HRS_FIND_APP_R_SBP (Page) (Field)
            Used by HRS_FIND_APP_R_SBP (Page) DESCR (Field)
            Used by HRS_FIND_APP_R_SBP (Page) HRS_JOB_OPENING_ID (Field)
            Used by HRS_FIND_APP_R_SBP (Page) HRS_PERSON_ID (Field)
            Used by HRS_FIND_APP_R_SBP (Page) HRS_PROFILE_SEQ (Field)
            Used by HRS_FIND_APP_R_SBP (Page) HRS_RCMNT_ID (Field)
            Used by HRS_FIND_APP_R_SBP (Page) NAME_DISPLAY (Field)
            Used by HRS_FIND_APP_R_SBP (Page) PREV_EMPL_BY_COMPY (Field)
            Used by HRS_FIND_APP_R_SBP (Page) STATUS_CODE (Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_APP360_DTA_PB(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_PERSON_ID(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_APP360_DTA_PB(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_PROFILE_SEQ(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_RCMNT_S_ACTION(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_JOB_OPENING_ID(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_RCMNT_S_ACTION(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_PERSON_ID(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_RCMNT_S_ACTION(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_PROFILE_SEQ(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_RCMNT_S_ACTION(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_RCMNT_ID(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_RCMNT_S_ACTION(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . STATUS_CODE(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_RESUME_BTN(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_PERSON_ID(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_RCM_WRK(RECORD) . HRS_RESUME_BTN(FIELD) . FieldChange(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_PROFILE_SEQ(Field)
            Used in PeopleCode: HRS_APPLICANT_TRACKING(APPLICATION_PACKAGE) . HRS_FIND_APP(APPLICATION_PACKAGE1) . BUS(APPLICATION_PACKAGE2) . Controller(APPLICATION_CLASS) . OnExecute(METHOD) as HRS_FIND_RSLT_I(RecName) . DESCR(Field)
            Used in PeopleCode: HRS_APPLICANT_TRACKING(APPLICATION_PACKAGE) . HRS_FIND_APP(APPLICATION_PACKAGE1) . BUS(APPLICATION_PACKAGE2) . Controller(APPLICATION_CLASS) . OnExecute(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_JOB_OPENING_ID(Field)
            Used in PeopleCode: HRS_APPLICANT_TRACKING(APPLICATION_PACKAGE) . HRS_FIND_APP(APPLICATION_PACKAGE1) . BUS(APPLICATION_PACKAGE2) . Controller(APPLICATION_CLASS) . OnExecute(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_PERSON_ID(Field)
            Used in PeopleCode: HRS_APPLICANT_TRACKING(APPLICATION_PACKAGE) . HRS_FIND_APP(APPLICATION_PACKAGE1) . BUS(APPLICATION_PACKAGE2) . Controller(APPLICATION_CLASS) . OnExecute(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_PROFILE_SEQ(Field)
            Used in PeopleCode: HRS_APPLICANT_TRACKING(APPLICATION_PACKAGE) . HRS_FIND_APP(APPLICATION_PACKAGE1) . BUS(APPLICATION_PACKAGE2) . Controller(APPLICATION_CLASS) . OnExecute(METHOD) as HRS_FIND_RSLT_I(RecName) . HRS_RCMNT_ID(Field)
            Used in PeopleCode: HRS_APPLICANT_TRACKING(APPLICATION_PACKAGE) . HRS_FIND_APP(APPLICATION_PACKAGE1) . BUS(APPLICATION_PACKAGE2) . Controller(APPLICATION_CLASS) . OnExecute(METHOD) as HRS_FIND_RSLT_I(RecName) . NAME_DISPLAY(Field)
            Used in PeopleCode: HRS_APPLICANT_TRACKING(APPLICATION_PACKAGE) . HRS_FIND_APP(APPLICATION_PACKAGE1) . BUS(APPLICATION_PACKAGE2) . Controller(APPLICATION_CLASS) . OnExecute(METHOD) as HRS_FIND_RSLT_I(RecName) . STATUS_CODE(Field)
            Used in PeopleCode: HRS_APPLICANT_TRACKING(APPLICATION_PACKAGE) . HRS_FIND_APP(APPLICATION_PACKAGE1) . BUS(APPLICATION_PACKAGE2) . Controller(APPLICATION_CLASS) . OnExecute(METHOD) as RECORD(RecName) . HRS_FIND_RSLT_I(Field)
            Used in PeopleCode: HRS_COMMON(APPLICATION_PACKAGE) . CMP_HRS_REC_SCHAPP(APPLICATION_PACKAGE1) . UI(APPLICATION_PACKAGE2) . RecSchAppPage(APPLICATION_CLASS) . OnExecute(METHOD) as RECORD(RecName) . HRS_FIND_RSLT_I(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_ACT_WRK(RECORD) . HRS_APP_ACT_BTN(FIELD) . FieldChange(METHOD) as RECORD(RecName) . HRS_FIND_RSLT_I(Field)
            Used in PeopleCode: HRS_REC_SCHAPP(COMPONENT) . GBL(MARKET) . HRS_APP_ACT_WRK(RECORD) . HRS_APP_ACT_BTN(FIELD) . FieldEdit(METHOD) as RECORD(RecName) . HRS_FIND_RSLT_I(Field)
            Search Completed - Found 29 definition(s)

            Looking at the list the Application Packages are most interesting when you're talking about jobs, unless some AppEngine uses a CI for example. But my biggest guess would be AppPackage HRS_APPLICANT_TRACKING.