substr(servprov_gid, instr(servprov_gid,'.')+1) as SCAC,
attribute3 as Customer,
substr(ivs1.shipment_gid, instr(ivs1.shipment_gid, '.') + 1) as ShipmentID,
attribute17 as ExceptionReason,
attribute18 as ExceptionDesc
FROM invoice INV
JOIN invoice_status ivs ON ivs.invoice_gid = inv.invoice_gid AND ivs.status_type_gid = 'RUAN.APPROVAL'
WHERE LOWER(attribute17) LIKE Lower('%MISSING%')
and ivs.status_value_gid in ('RUAN.APPROVAL_FAILED','RUAN.APPROVAL_NOT_APPROVED')
ORDER by servprov_gid ASC, invoice_date DESC
This works perfectly in Oracle SQL developer. When I try and use it in UiPath though, I get the error
This makes zero sense to me as this works in oracle.
substr(inv.servprov_gid, instr(inv.servprov_gid,‘.’)+1) as SCAC,
inv.attribute3 as Customer,
substr(ivs.shipment_gid, instr(ivs.shipment_gid, ‘.’) + 1) as ShipmentID,
inv.attribute17 as ExceptionReason,
inv.attribute18 as ExceptionDesc
FROM invoice inv
JOIN invoice_status ivs ON ivs.invoice_gid = inv.invoice_gid AND ivs.status_type_gid = ‘RUAN.APPROVAL’
WHERE LOWER(inv.attribute17) LIKE LOWER(‘%MISSING%’)
AND ivs.status_value_gid IN (‘RUAN.APPROVAL_FAILED’, ‘RUAN.APPROVAL_NOT_APPROVED’)
ORDER BY inv.servprov_gid ASC, inv.invoice_date DESC;
Oracle SQL is case-sensitive inside double quotes. In your SQL environment, the identifiers might be recognized in a case-insensitive manner, but this may not be the case in other environments. Ensure that the case of the column names and aliases matches the actual case in the database schema.