SQL> SELECT x.*, (select banner from v$version where banner like 'Oracle Database%') ver
  FROM xmltable('/XML/FILTER' passing
                        , cd     xmltype path '*') x ;
                xmltype('<?xml version="1.0" encoding="UTF-8"?><XML><FILTER><BU_ID>5</BU_ID></FILTER></XML>')
                columns   bu_id NUMBER path '/XML/BU_ID'
                        , bubu_id NUMBER path 'BU_ID'
                        , cd     xmltype path '*') x ;

     BU_ID    BUBU_ID CD                             VER
---------- ---------- ------------------------------ ----------------------------------------------------------------------------------------------------
         5          5 <BU_ID>5</BU_ID>               Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production



SELECT /*+ NO_QUERY_TRANSFORMATION */  x.*, (select banner from v$version where banner like 'Oracle Database%') ver
                columns  bu_id NUMBER path '/XML/BU_ID'
  FROM xmltable('/XML/FILTER' passing
                xmltype('<?xml version="1.0" encoding="UTF-8"?><XML><FILTER><BU_ID>5</BU_ID></FILTER></XML>')
                columns  bu_id NUMBER path '/XML/BU_ID'
                        , bubu_id NUMBER path 'BU_ID'
                        , cd     xmltype path '*') x ;

     BU_ID    BUBU_ID CD                             VER
---------- ---------- ------------------------------ ----------------------------------------------------------------------------------------------------
                    5 <BU_ID>5</BU_ID>               Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production



SELECT bu_id, pu_id, process_id, YEAR, MONTH, to_date('01.' || MONTH || '.' || YEAR, 'DD.MM.YYYY'), material_id, supplier, form_id
  FROM xmltable('/XML/FILTER' passing
               ,process_id VARCHAR2(50) path '//FILTER/PROCESS_ID'
                xmltype('<?xml version="1.0" encoding="UTF-8"?><XML><FILTER><BU_ID>5</BU_ID><PU_ID>76</PU_ID><PROCESS_ID>kz_underground_mining</PROCESS_ID><YEAR>2016</YEAR><MONTH>3</MONTH><SECTOR_ID>-10</SECTOR_ID><MATERIAL_ID></MATERIAL_ID><PROXY_ID>PCK_MNGF615C_NEW2.f_get_data</PROXY_ID><USERMENU_ID>4504</USERMENU_ID><MII_TARGET_FORM_GRID>grid</MII_TARGET_FORM_GRID><USERNAME>ASMARKEVICH</USERNAME></FILTER></XML>')
                columns bu_id NUMBER path '//FILTER/BU_ID'
               ,pu_id NUMBER path '//FILTER/PU_ID'
               ,process_id VARCHAR2(50) path '//FILTER/PROCESS_ID'
               ,YEAR VARCHAR2(4) path '//FILTER/YEAR'
               ,MONTH VARCHAR2(2) path '//FILTER/MONTH'
               ,material_id NUMBER path '//FILTER/MATERIAL_ID'
               ,supplier VARCHAR2(32) path '//FILTER/SUPPLIER_ID'
 11                 ,form_id VARCHAR2(100) path '//FILTER/FORM_ID');
SELECT bu_id, pu_id, process_id, YEAR, MONTH, to_date('01.' || MONTH || '.' || YEAR, 'DD.MM.YYYY'), material_id, supplier, form_id
                                                                             *
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected



SELECT /*+ NO_QUERY_TRANSFORMATION */ bu_id, pu_id, process_id, YEAR, MONTH, to_date('01.' || MONTH || '.' || YEAR, 'DD.MM.YYYY'), material_id, supplier, form_id
                columns bu_id NUMBER path '//FILTER/BU_ID'
  FROM xmltable('/XML/FILTER' passing
               ,MONTH VARCHAR2(2) path '//FILTER/MONTH'
                xmltype('<?xml version="1.0" encoding="UTF-8"?><XML><FILTER><BU_ID>5</BU_ID><PU_ID>76</PU_ID><PROCESS_ID>kz_underground_mining</PROCESS_ID><YEAR>2016</YEAR><MONTH>3</MONTH><SECTOR_ID>-10</SECTOR_ID><MATERIAL_ID></MATERIAL_ID><PROXY_ID>PCK_MNGF615C_NEW2.f_get_data</PROXY_ID><USERMENU_ID>4504</USERMENU_ID><MII_TARGET_FORM_GRID>grid</MII_TARGET_FORM_GRID><USERNAME>ASMARKEVICH</USERNAME></FILTER></XML>')
                columns bu_id NUMBER path '//FILTER/BU_ID'
               ,pu_id NUMBER path '//FILTER/PU_ID'
               ,process_id VARCHAR2(50) path '//FILTER/PROCESS_ID'
               ,YEAR VARCHAR2(4) path '//FILTER/YEAR'
               ,MONTH VARCHAR2(2) path '//FILTER/MONTH'
               ,material_id NUMBER path '//FILTER/MATERIAL_ID'
               ,supplier VARCHAR2(32) path '//FILTER/SUPPLIER_ID'
               ,form_id VARCHAR2(100) path '//FILTER/FORM_ID');

     BU_ID      PU_ID PROCESS_ID                     YEAR MO TO_DATE   MATERIAL_ID SUPPLIER                         FORM_ID
---------- ---------- ------------------------------ ---- -- --------- ----------- -------------------------------- ------------------------------
         5         76 kz_underground_mining          2016 3  01-MAR-16