1 2 Previous Next 15 Replies Latest reply on Jul 16, 2019 5:11 AM by Er.RJ

    date in report showing 19 but i want 2019 in IG oracle apex

    Er.RJ

      Hello All,

       

      Can anyone help me, how can i show previously stored data in DB for due_date column (date stored as 07-MON-19) but in IG i need it to display as YYYY ie, 2019 instead of 19. ex: 07-MON-2019

      i tried couple of things mentioned below:

      1. replace(TO_CHAR(a.DUE_DATE,'DD-MON-YYYY'),'-00','-20')  DUE_DATE

      2.TO_DATE(TO_CHAR(a.DUE_DATE,'DD-MON-YY'),'DD-MON-RRRR') DD

       

      both giving me date as expected that is 07-MON-2019 but as am using IG, due_date column is date picker so when i edit and change the date am getting error mentioned below:

       

      • An unexpected internal application error has occurred.

       

      Debug output:

      0.034110.00160
      Reset NLS settings
      4

      1%

      0.035710.00110
      alter session set  NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CALENDAR='GREGORIAN' NLS_SORT='BINARY' NLS_COMP='BINARY'
      4

      0%

      0.036810.00010
      ...NLS: Set Decimal separator="."
      4

      0%

      0.036920.00057
      ...NLS: Set NLS Group separator=","
      4

      0%

      0.037480.00020
      ...NLS: Set g_nls_date_format="DD-MON-RR"
      4

      0%

      0.037680.00015
      ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"
      4

      0%

      0.037830.00126
      ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"
      4

      0%

      0.039090.00034
      ...Setting session time_zone to +01:00
      4

      0%

      0.039420.00574
      R E Q U E S T show
      4

      2%

      0.045170.00155
      Language derived from: FLOW_PRIMARY_LANGUAGE, current browser language: en
      4

      1%

      0.046720.00012
      alter session set nls_language='AMERICAN' nls_territory='AMERICA'
      4

      0%

      0.046840.00033
      NLS: CSV charset=WE8MSWIN1252
      4

      0%

      0.047170.00009
      ...NLS: Set Decimal separator="."
      4

      0%

      0.047260.00036
      ...NLS: Set NLS Group separator=","
      4

      0%

      0.047620.00012
      ...NLS: Set g_nls_date_format="DD-MON-RR"
      4

      0%

      0.047730.00011
      ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"
      4

      0%

      0.047840.00122
      ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"
      4

      0%

      0.049060.00100
      Setting NLS: NLS_TIMESTAMP_FORMAT="DD-MON-RR HH.MI.SS AM"
      4

      0%

      0.050060.00016
      ...NLS: Set g_nls_date_format="DD-MON-RR"
      4

      0%

      0.050220.00012
      ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SS AM"
      4

      0%

      0.050340.00021
      ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"
      4

      0%

      0.050550.00012
      NLS: Language=en
      4

      0%

      0.050670.00192
      Application 514, Page Template: 249772717013229833
      4

      1%

      0.052590.00102
      Authentication check: CUSTOM_DB_AUTHENTICATION (NATIVE_CUSTOM)
      4

      0%

      0.053620.00221
      Session State: fetch from database (exact)
      4

      1%

      0.055830.00021
      ... sentry+verification success
      4

      0%

      0.056040.00141
      ...Session ID 2930670847085 can be used
      4

      1%

      0.057450.00096
      ...Setting session time_zone to US/Pacific
      4

      0%

      0.058410.00451
      ...Check for session expiration:
      4

      2%

      0.062910.00036
      Branches - point: BEFORE_HEADER
      4

      0%

      0.063280.00151
      Display Page from Cache
      4

      1%

      0.064780.00736
      Fetch application meta data
      4

      3%

      0.072140.00089
      Setting NLS: NLS_TIMESTAMP_FORMAT="DD-MON-RR HH.MI.SS AM"
      4

      0%

      0.073040.00013
      ...NLS: Set g_nls_date_format="DD-MON-RR"
      4

      0%

      0.073170.00011
      ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SS AM"
      4

      0%

      0.073280.00021
      ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"
      4

      0%

      0.073490.00041
      ...http header processing
      4

      0%

      0.073900.00145
      ...set mime type: text/html
      4

      1%

      0.075350.00064
      ...set additional http headers
      4

      0%

      0.075990.00032
      Process point: BEFORE_HEADER
      4

      0%

      0.076310.00026
      Processes - point: BEFORE_HEADER
      4

      0%

      0.076570.00179
      ...Process "set time zone" - Type: NATIVE_PLSQL
      4

      1%

      0.078360.00423
      ...Execute Statement: begin declare c integer := 0; begin for c1 in ( select timezone_preference from   eba_proj_tz_pref where  username = upper(:P_USER_NAME)) loop -- if c1.timezone_preference is not null then c := c + 1; APEX_UTIL.SET_SESSION_TIME_ZONE (P_TIME_ZONE => c1.timezone_preference ); end if; exit; end loop; if c = 0 then if apex_util.get_session_time_zone is null then APEX_UTIL.SET_SESSION_TIME_ZONE (P_TIME_ZONE => 'US/Pacific'); end if; end if; end; end;
      4

      2%

      0.082580.00174
      ...close http header
      4

      1%

      0.084320.00201
      Show page template header
      4

      1%

      0.086330.00038
      Load JavaScript file=/i/libraries/jquery/1.12.3/jquery-1.12.3.js?v=5.1.4.00.08
      4

      0%

      0.086720.00022
      Load JavaScript file=/i/libraries/jquery/2.2.3/jquery-2.2.3.js?v=5.1.4.00.08
      4

      0%

      0.086930.00056
      Set RequireJS define jquery=apex.jQuery
      4

      0%

      0.087490.00062
      Load JavaScript file=/i/libraries/apex/core.js?v=5.1.4.00.08
      4

      0%

      0.088120.00028
      Load JavaScript file=/i/libraries/apex/debug.js?v=5.1.4.00.08
      4

      0%

      0.088400.00028
      Load JavaScript file=/i/libraries/apex/util.js?v=5.1.4.00.08
      4

      0%

      0.088680.00025
      Load JavaScript file=/i/libraries/apex/locale.js?v=5.1.4.00.08
      4

      0%

      0.088930.00030
      Load JavaScript file=/i/libraries/apex/lang.js?v=5.1.4.00.08
      4

      0%

      0.089230.00023
      Load JavaScript file=/i/libraries/apex/message.js?v=5.1.4.00.08
      4

      0%

      0.089460.00030
      Load JavaScript file=wwv_flow.js_messages?p_app_id=514&p_lang=en&p_version=5.1.4.00.08-14759049154634&p_builder=Y
      4

      0%

      0.089750.00026
      Load JavaScript file=/i/libraries/apex/storage.js?v=5.1.4.00.08
      4

      0%

      0.090010.00025
      Load JavaScript file=/i/libraries/apex/navigation.js?v=5.1.4.00.08
      4

      0%

      0.090260.00026
      Load JavaScript file=/i/libraries/apex/event.js?v=5.1.4.00.08
      4

      0%

      0.090520.00025
      Load JavaScript file=/i/libraries/apex/server.js?v=5.1.4.00.08
      4

      0%

      0.090770.00026
      Load JavaScript file=/i/libraries/apex/page.js?v=5.1.4.00.08
      4

      0%

      0.091030.00025
      Load JavaScript file=/i/libraries/apex/region.js?v=5.1.4.00.08
      4

      0%

      0.091270.00031
      Load JavaScript file=/i/libraries/apex/item.js?v=5.1.4.00.08
      4

      0%

      0.091580.00032
      Load JavaScript file=/i/libraries/apex/apex_5_0.js?v=5.1.4.00.08
      4

      0%

      0.091900.00126
      Load JavaScript file=/i/libraries/apex/widget.js?v=5.1.4.00.08
      4

      0%

      0.093160.00031
      Load JavaScript file=/i/libraries/apex/widget.util.js?v=5.1.4.00.08
      4

      0%

      0.093480.00027
      Load JavaScript file=/i/libraries/apex/dynamic_actions_core.js?v=5.1.4.00.08
      4

      0%

      0.093750.00038
      Load JavaScript file=/i/libraries/apex/dynamic_actions.js?v=5.1.4.00.08
      4

      0%

      0.094130.00026
      Load JavaScript file=/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.4.00.08
      4

      0%

      0.094380.00027
      Load JavaScript file=/i/libraries/apex/actions.js?v=5.1.4.00.08
      4

      0%

      0.094650.00025
      Load JavaScript file=/i/libraries/apex/widget.checkboxAndRadio.js?v=5.1.4.00.08
      4

      0%

      0.094900.00026
      Load JavaScript file=/i/libraries/apex/widget.popupLov.js?v=5.1.4.00.08
      4

      0%

      0.095160.00025
      Load JavaScript file=/i/libraries/apex/widget.selectList.js?v=5.1.4.00.08
      4

      0%

      0.095400.00026
      Load JavaScript file=/i/libraries/apex/widget.textarea.js?v=5.1.4.00.08
      4

      0%

      0.095660.00025
      Load JavaScript file=/i/libraries/apex/widget.yesNo.js?v=5.1.4.00.08
      4

      0%

      0.095910.00026
      Load JavaScript file=/i/libraries/apex/widget.menu.js?v=5.1.4.00.08
      4

      0%

      0.096170.00025
      Load JavaScript file=/i/libraries/apex/widget.toggleCore.js?v=5.1.4.00.08
      4

      0%

      0.096420.00026
      Load JavaScript file=/i/libraries/apex/widget.collapsible.js?v=5.1.4.00.08
      4

      0%

      0.096670.00025
      Load JavaScript file=/i/libraries/apex/tooltipManager.js?v=5.1.4.00.08
      4

      0%

      0.096920.00026
      Load JavaScript file=/i/libraries/apex/theme.js?v=5.1.4.00.08
      4

      0%

      0.097180.00025
      Load JavaScript file=/i/libraries/apex/legacy.js?v=5.1.4.00.08
      4

      0%

      0.097430.00799
      Load JavaScript file=/i/libraries/jquery-migrate/1.4.1/jquery-migrate-1.4.1.js?v=5.1.4.00.08
      4

      3%

      0.105410.00283
      Rendering form open tag and internal values
      4

      1%

      0.108240.00013
      Evaluate which regions should be rendered for display point REGION_POSITION_07
      4

      0%

      0.108370.01356
      ...No regions to render
      4

      5%

      0.121930.00013
      Evaluate which regions should be rendered for display point REGION_POSITION_06
      4

      0%

      0.122060.00021
      ...No regions to render
      4

      0%

      0.122270.00014
      Process point: AFTER_HEADER
      4

      0%

      0.122410.00034
      Processes - point: AFTER_HEADER
      4

      0%

      0.122750.00112
      Evaluate which regions should be rendered for display point AFTER_HEADER
      4

      0%

      0.123870.00013
      Render regions
      4

      0%

      0.124000.00062
      ...Region: CSS Links
      4

      0%

      0.124620.00106
      ...region is nocache - do not cache
      4

      0%

      0.125680.00148
      ......No page items/buttons to render
      4

      1%

      0.127160.00011
      Evaluate which sub regions should be rendered
      4

      0%

      0.127270.00043
      ...No sub regions to render
      4

      0%

      0.127700.00014
      Process point: BEFORE_BOX_BODY
      4

      0%

      0.127840.00017
      Processes - point: BEFORE_BOX_BODY
      4

      0%

      0.128010.00031
      Show page template body
      4

      0%

      0.128320.00051
      Evaluate which regions should be rendered for display point REGION_POSITION_01
      4

      0%

      0.128830.00052
      Render regions
      4

      0%

      0.129340.00137
      Evaluate which regions should be rendered for display point BODY
      4

      1%

      0.130710.00012
      Render regions
      4

      0%

      0.130830.00056
      ...Region: Open Action Items
      4

      0%

      0.131390.00213
      ...region is nocache - do not cache
      4

      1%

      0.133520.00109
      ......Buttons: p_plug_id=>251615537241599060,p_position=>REGION_TEMPLATE_EDIT
      4

      0%

      0.134610.00504
      .........Button: id=>252981213480868786,name=>Clear,condition_met=>true,template=>249846740351229958
      4

      2%

      0.139650.00394
      ......Render page items and buttons
      4

      1%

      0.143590.00038
      Load JavaScript file=/i/libraries/apex/model.js?v=5.1.4.00.08
      4

      0%

      0.143960.00027
      Load JavaScript file=/i/libraries/apex/widget.menu.js?v=5.1.4.00.08
      4

      0%

      0.144230.00027
      Load JavaScript file=/i/libraries/apex/widget.toolbar.js?v=5.1.4.00.08
      4

      0%

      0.144500.00028
      Load JavaScript file=/i/libraries/apex/widget.stickyWidget.js?v=5.1.4.00.08
      4

      0%

      0.144770.00032
      Load JavaScript file=/i/libraries/apex/widget.tableModelViewBase.js?v=5.1.4.00.08
      4

      0%

      0.145090.00063
      Load JavaScript file=/i/libraries/apex/widget.grid.js?v=5.1.4.00.08
      4

      0%

      0.145710.00092
      Load JavaScript file=/i/libraries/apex/widget.splitter.js?v=5.1.4.00.08
      4

      0%

      0.146630.00029
      Load JavaScript file=/i/libraries/apex/widget.recordView.js?v=5.1.4.00.08
      4

      0%

      0.146920.00027
      Load JavaScript file=/i/libraries/apex/widget.iconList.js?v=5.1.4.00.08
      4

      0%

      0.147190.00031
      Load JavaScript file=/i/libraries/apex/widget.combobox.js?v=5.1.4.00.08
      4

      0%

      0.147500.00028
      Load JavaScript file=/i/libraries/jquery-ui/1.10.4/ui/i18n/oracle/jquery.ui.datepicker-en.js?v=5.1.4.00.08
      4

      0%

      0.147780.00027
      Load JavaScript file=/i/libraries/apex/widget.timepicker.js?v=5.1.4.00.08
      4

      0%

      0.148050.00026
      Load JavaScript file=/i/libraries/apex/widget.datepicker.js?v=5.1.4.00.08
      4

      0%

      0.148310.00027
      Load JavaScript file=/i/libraries/apex/widget.interactiveGrid.js?v=5.1.4.00.08
      4

      0%

      0.148590.00017
      Load JavaScript file=/i/libraries/apex/widget.jetChart.js?v=5.1.4.00.08
      4

      0%

      0.148750.00009
      Load RequireJS
      4

      0%

      0.148850.01252
      Load Oracle JET RequireJS config
      4

      5%

      0.161370.00478
      Load JavaScript file=/i/libraries/apex/widget.popupLov.js?v=5.1.4.00.08
      4

      2%

      0.166150.00191
      Load JavaScript file=/i/libraries/apex/widget.textarea.js?v=5.1.4.00.08
      4

      1%

      0.168060.00461
      Load JavaScript file=/i/libraries/apex/widget.textarea.js?v=5.1.4.00.08
      4

      2%

      0.172670.00437
      Load JavaScript file=/i/libraries/apex/widget.selectList.js?v=5.1.4.00.08
      4

      2%

      0.177040.00529
      ...Execute Statement: select AI_TYPE, id from EBA_PROJ_STATUS_AIS_TYPES where is_active_yn = 'Y' or id = :P73_AI_TYPE order by is_active_yn desc, display_sequence
      4

      2%

      0.182330.00616
      Load JavaScript file=/i/libraries/apex/widget.selectList.js?v=5.1.4.00.08
      4

      2%

      0.188490.00194
      Load JavaScript file=/i/libraries/apex/widget.textarea.js?v=5.1.4.00.08
      4

      1%

      0.190430.00114
      Load JavaScript file=/i/libraries/jquery-ui/1.10.4/ui/i18n/oracle/jquery.ui.datepicker-en.js?v=5.1.4.00.08
      4

      0%

      0.191570.00150
      Load JavaScript file=/i/libraries/apex/widget.timepicker.js?v=5.1.4.00.08
      4

      1%

      0.193080.00289
      Load JavaScript file=/i/libraries/apex/widget.datepicker.js?v=5.1.4.00.08
      4

      1%

      0.195970.00166
      Load JavaScript file=/i/libraries/jquery-ui/1.10.4/ui/i18n/oracle/jquery.ui.datepicker-en.js?v=5.1.4.00.08
      4

      1%

      0.197630.00224
      Load JavaScript file=/i/libraries/apex/widget.datepicker.js?v=5.1.4.00.08
      4

      1%

      0.199870.00104
      Load JavaScript file=/i/libraries/jquery-ui/1.10.4/ui/i18n/oracle/jquery.ui.datepicker-en.js?v=5.1.4.00.08
      4

      0%

      0.200910.00140
      Load JavaScript file=/i/libraries/apex/widget.timepicker.js?v=5.1.4.00.08
      4

      1%

      0.202310.01417
      Load JavaScript file=/i/libraries/apex/widget.datepicker.js?v=5.1.4.00.08
      4

      5%

      0.216480.00014
      Evaluate which sub regions should be rendered
      4

      0%

      0.216620.00058
      ...No sub regions to render
      4

      0%

      0.217200.00057
      Evaluate which regions should be rendered for display point BODY_1
      4

      0%

      0.217770.00016
      Render regions
      4

      0%

      0.217930.00011
      Evaluate which regions should be rendered for display point BODY_2
      4

      0%

      0.218030.00026
      ...No regions to render
      4

      0%

      0.218290.00017
      ......No page items/buttons to render
      4

      0%

      0.218450.00010
      Evaluate which regions should be rendered for display point BODY_3
      4

      0%

      0.218560.00029
      ...No regions to render
      4

      0%

      0.218850.00010
      Evaluate which regions should be rendered for display point REGION_POSITION_05
      4

      0%

      0.218940.00230
      ...No regions to render
      4

      1%

      0.221240.00013
      Evaluate which regions should be rendered for display point REGION_POSITION_04
      4

      0%

      0.221370.00022
      ...No regions to render
      4

      0%

      0.221590.00014
      Process point: AFTER_BOX_BODY
      4

      0%

      0.221730.00015
      Processes - point: AFTER_BOX_BODY
      4

      0%

      0.221880.00013
      Process point: BEFORE_FOOTER
      4

      0%

      0.222020.00017
      Processes - point: BEFORE_FOOTER
      4

      0%

      0.222190.00010
      Evaluate which regions should be rendered for display point BEFORE_FOOTER
      4

      0%

      0.222280.00010
      ...No regions to render
      4

      0%

      0.222380.00010
      Show page footer
      4

      0%

      0.222480.00013
      Show page tempate footer
      4

      0%

      0.222610.00438
      Rendering form close tag and page checksum
      4

      2%

      0.227000.00039
      Load JavaScript file=/i/libraries/apex/widget.menu.js?v=5.1.4.00.08
      4

      0%

      0.227390.00415
      Load JavaScript file=/i/apex_ui/js/devToolbar.js?v=5.1.4.00.08
      4

      2%

      0.231540.00031
      Load JavaScript file=/i/libraries/hammer/2.0.4/hammer-2.0.4.js?v=5.1.4.00.08
      4

      0%

      0.231850.00029
      Set RequireJS define hammerjs=Hammer
      4

      0%

      0.232130.00037
      Load JavaScript file=/i/libraries/apex/widget.apexTabs.js?v=5.1.4.00.08
      4

      0%

      0.232500.00034
      Load JavaScript file=/i/libraries/apex/widget.stickyWidget.js?v=5.1.4.00.08
      4

      0%

      0.232850.00036
      Load JavaScript file=/i/libraries/apex/widget.stickyTableHeader.js?v=5.1.4.00.08
      4

      0%

      0.233200.00036
      Load JavaScript file=/i/themes/theme_42/1.1/js/modernizr-custom.js?v=5.1.4.00.08
      4

      0%

      0.233560.00175
      Load JavaScript file=/i/themes/theme_42/1.1/js/theme42.js?v=5.1.4.00.08
      4

      1%

      0.235310.00042
      Load JavaScript file=/i/libraries/oraclejet/2.0.2/js/libs/require/require.js?v=5.1.4.00.08
      4

      0%

      0.235730.00768
      Load JavaScript file=/i/libraries/apex/requirejs.jetConfig.js?v=5.1.4.00.08
      4

      3%

      0.243410.00016
      Process point: AFTER_FOOTER
      4

      0%

      0.243570.02820
      Processes - point: AFTER_FOOTER
      4

      10%

      0.271760.00013
      gv$sesstat.statistic# = 436: execute count=2
      4

      0%

      0.27190-
      Final commit

       

       

      Oracle apex 5.1 11g

       

       

      Thanks in advance

        1 2 Previous Next