We have an External Files background job that calls External_File_Utility_API.Execute_Batch_Process2. It runs every half hour or so to look for invoices.
When it doesn’t find the file, it throws a background job error.
ORA-20110: ExternalFileUtility.File MY_DIRECTORY\MY_FILE.CSV not exist
We’re getting more serious about managing our background job errors, and this one is generating quite a bit of noise. I’m trying to improve the signal-to-noise ratio with the ultimate goal of making every error actionable.
Is there a way to configure it to fail silently or gracefully when the file isn’t there, rather than throw this ugly error?
