sqlplus -s arbor/arbor123@FXADMUAT << EOF> CN_DN1.txt
set trimspool on heading off
set linesize 30000
SET WRAP OFF
SELECT SourceIdentifier||'^'||SourceFileName||'^'||GLAccountCode||'^'||Division||'^'||SubDivision||'^'||ProfitCentre1||'
^'||ProfitCentre2||'^'||PlantCode||'^'||
tax_return_period||'^'||New_supplier_gst_id||'^'||Document_type||'^'||supply_type||'^'||cr_db_no||'^'||NVL(TO_CHAR(credi
t_note_dt,'YYYY-MM-DD'),TO_CHAR(debit_note_dt,'YYYY-MM-DD'))||'^'||old_invoice_no||'^'||TO_CHAR(old_invoice_date,'YYYY-M
M-DD')||'^'||CRDRPreGST||'^'||line_item_no||'^'||new_gst_id_new||'^'||UINorComposition||'^'||OriginalCustomerGSTIN||'^'|
|customer_name||'^'||CustomerCode||'^'||BillToState||'^'||ShipToState||'^'||nvl(sns_pos,new_state_code)||'^'||PortCode||
'^'||ShippingBillNumber||'^'||ShippingBillDate||'^'||FOB||'^'||ExportDuty||'^'||new_HSN_CODE||'^'||ProductCode||'^'||new
_nature_of_supply||'^'||CategoryOfProduct||'^'||UnitOfMeasurement||'^'||Quantity||'^'||cr_db_amount||'^'||IGST_tax_rate|
|'^'||IGST_tax_amount||'^'||CGT_tax_RATE||'^'||other_tax_rate||'^'||CGT_tax_AMOUNT||'^'||other_tax_amount||'^'||SGST_tax
_RATE||'^'||SGST_tax_AMOUNT||'^'||CessRateAdvalorem||'^'||CessAmountAdvalorem||'^'||CessRateSpecific||'^'||CessAmountSpe
cific||'^'||cr_db_amount+IGST_tax_amount+CGT_tax_AMOUNT+SGST_tax_AMOUNT+other_tax_amount||'^'||ReverseChargeFlag||'^'||T
CSFlag||'^'||eComGSTIN||'^'||
ITCFlag||'^'||ReasonForCreditDebitNote||'^'||AccountingVoucherNumber||'^'||AccountingVoucherDate||'^'||Userdefinedfield1
||'^'||Userdefinedfield2||'^'||Userdefinedfield3 FROM arbor.CN_DN_APR18_DATA2 WHERE UPPER(backout_flag)='VALID' AND new_
gst_id_new IS NOT NULL;
exit
EOF

cr_db_amount+IGST_tax_amount+CGT_tax_AMOUNT+SGST_tax_AMOUNT+other_tax_amount

ERROR at line 3:
ORA-01722: invalid number