Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java
===================================================================
diff -u -r28084 -r28088
--- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java	(.../InvoicePlanOptimizeManagerImpl.java)	(revision 28084)
+++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanOptimizeManagerImpl.java	(.../InvoicePlanOptimizeManagerImpl.java)	(revision 28088)
@@ -1181,7 +1181,7 @@
 			if(CollectionUtils.isNotEmpty(disposableGoodsNameList)){
 				String disposableNameJoinSpecificationColumn = "(case when specification is null then name else concat(name,'[',specification,']') end)";
 				if(DatabaseUtil.isOracle(dbConnection.getDatabase())){
-					disposableNameJoinSpecificationColumn = "(case when specification is null then name else name || '[' || specification || ']' end)";
+					disposableNameJoinSpecificationColumn = "(case when specification is null then name else concat(concat(concat(name , '[') , specification), ']') end)";
 				}
 				@SuppressWarnings("unchecked")
 				List<DisposableGoods> disposableGoodsList =