Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tbl_ipcolo_billing_mst (
    cmp                  VARCHAR2(4000),
    sap_id               VARCHAR2(4000),
    id_od_countchange    VARCHAR2(4000),
    id_od_changeddate    DATE,
    rrh_countchange      VARCHAR2(4000),
    rrh_changeddate      DATE,
    tenancy_countchange  VARCHAR2(4000),
    tenancy_changeddate  DATE,
    rfs_date             DATE,
    rfe1_date            DATE,
    infra_provider       VARCHAR2(4000),
    ip_colo_siteid       VARCHAR2(4000),
    site_name            VARCHAR2(4000),
    r4gstate             VARCHAR2(4000),
    mw_installed         VARCHAR2(4000),
    dg_nondg             VARCHAR2(4000),
    eb_noneb             VARCHAR2(4000),
    tower_type           VARCHAR2(4000),
    vendor_code          VARCHAR2(4000),
    rfcdate              DATE,
    political_state_name VARCHAR2(4000),
    political_state_code VARCHAR2(4000),
    site_drop_date       DATE
  );
CREATE PROCEDURE insert_expt_excel(
  strxml  IN xmltype,
  poutmsg OUT NVARCHAR2
)
AS
BEGIN
  INSERT INTO tbl_ipcolo_billing_mst (
    cmp,
    sap_id,
    id_od_countchange,
    id_od_changeddate,
    rrh_countchange,
    rrh_changeddate,
    tenancy_countchange,
    tenancy_changeddate,
    rfs_date,
    rfe1_date,
    infra_provider,
    ip_colo_siteid,
    site_name,
    r4gstate,
    mw_installed,
    dg_nondg,
    eb_noneb,
    tower_type,
    vendor_code,
    rfcdate,
    political_state_name,
    political_state_code,
    site_drop_date
  )
  SELECT cmp,
         sap_id,
         id_od_countchange,
         id_od_changeddate,
         NULL AS rrh_countchange,
         NULL AS rrh_changeddate,
         tenancy_countchange,
         tenancy_changeddate,
         rfs_date,
         rfe1_date,
         infra_provider,
         ip_colo_siteid,
         site_name,
         r4gstate,
         mw_installed,
         dg_nondg,
         eb_noneb,
         tower_type,
         vendor_code,
         rfcdate,
         political_state_name,
         political_state_code,
         site_drop_date
  FROM   XMLTABLE(
           '//NewDataSet/excelData'
           PASSING strxml
           COLUMNS cmp                  VARCHAR2(4000) PATH './CMP',
                   sap_id               VARCHAR2(4000) PATH './SAP_ID',
                   id_od_countchange    VARCHAR2(4000) PATH './ID_OD_COUNTCHANGE',
                   id_od_changeddate    DATE           PATH './ID_OD_CHANGEDDATE',
                   tenancy_countchange  VARCHAR2(4000) PATH './TENANCY_COUNTCHANGE',
                   tenancy_changeddate  DATE           PATH './TENANCY_CHANGEDDATE',
                   rfs_date             DATE           PATH './RFS_DATE',
                   rfe1_date            DATE           PATH './RFE1_DATE',
                   infra_provider       VARCHAR2(4000) PATH './INFRA_PROVIDER',
                   ip_colo_siteid       VARCHAR2(4000) PATH './IP_COLO_SITEID',
                   site_name            VARCHAR2(4000) PATH './SITE_NAME',
                   r4gstate             VARCHAR2(4000) PATH './R4GSTATE',
                   mw_installed         VARCHAR2(4000) PATH './MW_INSTALLED',
                   dg_nondg             VARCHAR2(4000) PATH './DG_NONDG',
                   eb_noneb             VARCHAR2(4000) PATH './EB_NONEB',
                   tower_type           VARCHAR2(4000) PATH './TOWER_TYPE',
                   vendor_code          VARCHAR2(4000) PATH './VENDOR_CODE',
                   rfcdate              DATE           PATH './RFCDATE',
                   political_state_name VARCHAR2(4000) PATH './POLITICAL_STATE_NAME',
                   political_state_code VARCHAR2(4000) PATH './POLITICAL_STATE_CODE',
                   site_drop_date       DATE           PATH './SITE_DROP_DATE'
         );

  IF ( SQL%ROWCOUNT > 0 ) THEN
    poutmsg := '1';
  ELSE
    poutmsg := '0';
  END IF;
END insert_expt_excel;
/
DECLARE
  success NUMBER(1,0);
BEGIN
  insert_expt_excel( XMLType( '<NewDataSet>
  <excelData>
    <CMP>abc</CMP>
    <SAP_ID>def</SAP_ID>
    <ID_OD_COUNTCHANGE>ghi</ID_OD_COUNTCHANGE>
    <ID_OD_CHANGEDDATE>2019-09-30</ID_OD_CHANGEDDATE>
  </excelData>
</NewDataSet>' ), success );
  IF success = 1 THEN
    COMMIT;
  ELSE
    ROLLBACK;
  END IF;
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
    ROLLBACK;
END;
/
1 rows affected

SELECT * FROM tbl_ipcolo_billing_mst;


CMP
SAP_ID
ID_OD_COUNTCHANGE
ID_OD_CHANGEDDATE
RRH_COUNTCHANGE
RRH_CHANGEDDATE
TENANCY_COUNTCHANGE
TENANCY_CHANGEDDATE
RFS_DATE
RFE1_DATE
INFRA_PROVIDER
IP_COLO_SITEID
SITE_NAME
R4GSTATE
MW_INSTALLED
DG_NONDG
EB_NONEB
TOWER_TYPE
VENDOR_CODE
RFCDATE
POLITICAL_STATE_NAME
POLITICAL_STATE_CODE
SITE_DROP_DATE


abc
def
ghi
30-SEP-19
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null