2 Replies Latest reply: Feb 26, 2013 6:12 AM by Nicolette RSS

    Incident Tracking Packaged Application error

    Teneriffe_141212
      I installed the "Incident Tracking" prepackaged application that came with my APEX 4.2. Inside the application, I created a new "Assignee" and then proceeded to assign a ticket (via Tickets screen) to the newly created assignee. When I do this, it then puts the below text in a text bubble "Updates", the text should actually read changed from to "Name of the newly created assignee" instead of a the number, which is the ID in the assignee table. Which I believe is a bug, I'm looking for a fix for this, but struggling to find where to edit the code for this, can anyone help? I think the code sits inside an internal plugin in the application, but am having trouble finding it.

      Update Assignee changed from to *284657827008667618081368371512647126206*
      blah@gmail.com - Wednesday 20-FEB-2013 03:17 (Now)




      When searching for the code I found it in...

      ...... SNIP ......

      wwv_flow_api.create_page_plug (
      p_id=> 21813153649240572742 + wwv_flow_api.g_id_offset,
      p_flow_id=> wwv_flow.g_flow_id,
      p_page_id=> 50,
      p_plug_name=> 'Right Side',
      p_region_name=>'',
      p_escape_on_http_output=>'Y',
      p_plug_template=> 0,
      p_plug_display_sequence=> 100,
      p_plug_new_grid => false,
      p_plug_new_grid_row => false,
      p_plug_new_grid_column => false,
      p_plug_display_column=> 1,
      p_plug_display_point=> 'REGION_POSITION_03',
      p_plug_item_display_point=> 'ABOVE',
      p_plug_source=> s,
      p_plug_source_type=> 'PLSQL_PROCEDURE',
      p_translate_title=> 'Y',
      p_plug_query_row_template=> 1,
      p_plug_query_headings_type=> 'QUERY_COLUMNS',
      p_plug_query_num_rows => 15,
      p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
      p_plug_query_row_count_max => 500,
      p_plug_query_show_nulls_as => ' - ',
      p_plug_display_condition_type => '',
      p_pagination_display_position=>'BOTTOM_RIGHT',
      p_plug_customized=>'0',
      p_plug_caching=> 'NOT_CACHED',
      p_plug_comment=> '');
      end;
      /
      declare
      s varchar2(32767) := null;
      l_clob clob;
      l_length number := 1;
      begin
      s := null;
      wwv_flow_api.create_page_plug (
      p_id=> 21813153853846572743 + wwv_flow_api.g_id_offset,
      p_flow_id=> wwv_flow.g_flow_id,
      p_page_id=> 50,
      p_plug_name=> 'Incident',
      p_region_name=>'',
      p_escape_on_http_output=>'Y',
      p_plug_template=> 21813089941594564463+ wwv_flow_api.g_id_offset,
      p_plug_display_sequence=> 80,
      p_plug_new_grid => false,
      p_plug_new_grid_row => false,
      p_plug_new_grid_column => false,
      p_plug_display_column=> 1,
      p_plug_display_point=> 'BODY_3',
      p_plug_item_display_point=> 'ABOVE',
      p_plug_source=> s,
      p_plug_source_type=> 'STATIC_TEXT_ESCAPE_SC',
      p_translate_title=> 'Y',
      p_plug_query_row_template=> 1,
      p_plug_query_headings_type=> 'COLON_DELMITED_LIST',
      p_plug_query_row_count_max => 500,
      p_plug_display_condition_type => '',
      p_plug_customized=>'0',
      p_plug_caching=> 'NOT_CACHED',
      p_plug_comment=> '');
      end;
      /
      declare
      s varchar2(32767) := null;
      l_clob clob;
      l_length number := 1;
      begin
      s:=s||'select '||unistr('\000a')||
      ' '''' class, --use grayComment for gray look'||unistr('\000a')||
      ' ''Note'' note_type,'||unistr('\000a')||
      ' replace(sys.htf.escape_sc(dbms_lob.substr(note,2000,1)),chr(10),''
      '') note_text,'||unistr('\000a')||
      ' '''' attribute_1,'||unistr('\000a')||
      ' '''' attribute_2,'||unistr('\000a')||
      ' '''' attribute_3,'||unistr('\000a')||
      ' '''' attribute_4,'||unistr('\000a')||
      ' lower(created_by)||'' - ''||to_char(created,''Day DD-MON-YYYY HH24:MI'') created_by,'||unistr('\000a')||
      ' apex_util.get_since(created) c';

      s:=s||'reated_on,'||unistr('\000a')||
      ' '''' attribute_5,'||unistr('\000a')||
      ' created'||unistr('\000a')||
      'from EBA_INTRACK_NOTES '||unistr('\000a')||
      'where INCIDENT_ID = :P50_ID '||unistr('\000a')||
      'union all'||unistr('\000a')||
      'select '||unistr('\000a')||
      ' ''grayComment'' class, --use grayComment for gray look'||unistr('\000a')||
      ' ''Update'' note_type,'||unistr('\000a')||
      ' case follow_up_type '||unistr('\000a')||
      ' when ''STATUS_CHANGE'' then'||unistr('\000a')||
      ' ''Status changed from <strong>''||'||unistr('\000a')||
      ' (select status_name from EBA_INTRACK_STATUS where id = status_old_va';

      s:=s||'l)||''</strong> to <strong>''||'||unistr('\000a')||
      ' (select status_name from EBA_INTRACK_STATUS where id = status_new_val) ||''</strong>'''||unistr('\000a')||
      ' when ''CLOSE_DATE_CHANGE'' then'||unistr('\000a')||
      ' ''Close date changed from <strong>''||status_old_val||''</strong> to <strong>''||status_new_val||''</strong>'''||unistr('\000a')||
      ' when ''ASSIGNEE_CHANGE'' then'||unistr('\000a')||
      ' *''Assignee changed from*+ <strong>''||sys.htf.escape_sc(status_old_val)||''</s';

      s:=s||'trong> to+_ <strong>''||sys.htf.escape_sc(status_new_val)||''</strong>'''||unistr('\000a')||
      ' when ''URGENCY_CHANGE'' then'||unistr('\000a')||
      ' ''Urgency changed from <strong>''||'||unistr('\000a')||
      ' (select URGENCY_NAME from EBA_INTRACK_URGENCY where id = status_old_val)||''</strong> to <strong>''||'||unistr('\000a')||
      ' (select URGENCY_NAME from EBA_INTRACK_URGENCY where id = status_new_val) ||''</strong>'''||unistr('\000a')||
      '     when ''SEVERITY_CHANGE'' then'||unistr('\000a')||
      '     ';


      .... SNIP .....
        • 2. Re: Incident Tracking Packaged Application error
          Nicolette
          Teneriffe_141212 wrote:
          wwv_flow_api.create_page_plug (
          p_id=> 21813153649240572742 + wwv_flow_api.g_id_offset,
          p_flow_id=> wwv_flow.g_flow_id,
          p_page_id=> 50,
          p_plug_name=> 'Right Side',
          p_region_name=>'',
          p_escape_on_http_output=>'Y',
          p_plug_template=> 0,
          p_plug_display_sequence=> 100,
          p_plug_new_grid         => false,
          p_plug_new_grid_row     => false,
          p_plug_new_grid_column  => false,
          p_plug_display_column=> 1,
          p_plug_display_point=> 'REGION_POSITION_03',
          p_plug_item_display_point=> 'ABOVE',
          p_plug_source=> s,
          p_plug_source_type=> 'PLSQL_PROCEDURE',
          p_translate_title=> 'Y',
          p_plug_query_row_template=> 1,
          p_plug_query_headings_type=> 'QUERY_COLUMNS',
          p_plug_query_num_rows => 15,
          p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
          p_plug_query_row_count_max => 500,
          p_plug_query_show_nulls_as => ' - ',
          p_plug_display_condition_type => '',
          p_pagination_display_position=>'BOTTOM_RIGHT',
          p_plug_customized=>'0',
          p_plug_caching=> 'NOT_CACHED',
          p_plug_comment=> '');
          end;
          Means that the problem is with a report region on page p_page_id=> 50 of type pl/sql. The display sequence is 100.
          See the source of the region for the offending text.

          Try to debug the sql statement that is returned by the source. Does it return what you expect if you run it in sql workshop.

          Nicolette