This discussion is archived
2 Replies Latest reply: Oct 11, 2012 4:33 AM by JohnvanderKooij RSS

which job

user522961 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    OK.
  • 2. Re: which job
    JohnvanderKooij Explorer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points