Instead of 'ALTER TABLE OLE_DLVR_PTRN_BILL_FEE_TYP_T MODIFY CRDT_ISSUED DECIMAL(10, 4)' run following 

alter table OLE_DLVR_PTRN_BILL_T rename column CRDT_ISSUED to CRDT_ISSUED_OLD;
alter table OLE_DLVR_PTRN_BILL_T add CRDT_ISSUED DECIMAL(10, 4);
update OLE_DLVR_PTRN_BILL_T set CRDT_ISSUED = CRDT_ISSUED_OLD;
alter table OLE_DLVR_PTRN_BILL_T drop column CRDT_ISSUED_OLD;

-------------------------------------------------------------------------------------------

Instead of 'ALTER TABLE OLE_DLVR_PTRN_BILL_FEE_TYP_T MODIFY CRDT_REMAINING DECIMAL(10, 4)' run following

alter table OLE_DLVR_PTRN_BILL_T rename column CRDT_REMAINING to CRDT_REMAINING_OLD;
alter table OLE_DLVR_PTRN_BILL_T add CRDT_REMAINING DECIMAL(10, 4);
update OLE_DLVR_PTRN_BILL_T set CRDT_REMAINING = CRDT_REMAINING_OLD;
alter table OLE_DLVR_PTRN_BILL_T drop column CRDT_REMAINING_OLD

--------------------------------------------------------------------------


Instead of 'ALTER TABLE OLE_DLVR_PTRN_BILL_FEE_TYP_T MODIFY CRDT_ISSUED DECIMAL(10, 4)' run following

alter table OLE_DLVR_PTRN_BILL_FEE_TYP_T rename column CRDT_ISSUED to CRDT_ISSUED_OLD;
alter table OLE_DLVR_PTRN_BILL_FEE_TYP_T add CRDT_ISSUED DECIMAL(10, 4);
update OLE_DLVR_PTRN_BILL_FEE_TYP_T set CRDT_ISSUED = CRDT_ISSUED_OLD;
alter table OLE_DLVR_PTRN_BILL_FEE_TYP_T drop column CRDT_ISSUED_OLD;
 
 ------------------------------------------------

Instead of 'ALTER TABLE OLE_DLVR_PTRN_BILL_FEE_TYP_T MODIFY CRDT_REMAINING DECIMAL(10, 4)' run following

alter table OLE_DLVR_PTRN_BILL_FEE_TYP_T rename column CRDT_REMAINING to CRDT_REMAINING_OLD;
alter table OLE_DLVR_PTRN_BILL_FEE_TYP_T add CRDT_REMAINING DECIMAL(10, 4);
update OLE_DLVR_PTRN_BILL_FEE_TYP_T set CRDT_REMAINING = CRDT_REMAINING_OLD;
alter table OLE_DLVR_PTRN_BILL_FEE_TYP_T drop column CRDT_REMAINING_OLD;