Read files from that directory (Java anyone?)Ĥ. Create a directory object on the Oracle server.ģ. Load those results into a table and then fail the normal load process if we detect any incongruities.ġ.
Query the appropriate tables at certain intervals to verify it matches the file amounts.ģ. Read the files when they first come in (on disk).Ģ. To provide the business (and ourselves) with a way to track when files came in and if the entire processed worked as expected (no lost dollars, no lost record counts).ġ. On occasion, those files are double, or even triple, loaded. We have absolutely no control over this, it lies with another group.
Inbound Remittance Advice files are loaded into our Operational Data Store (ODS). I can't post the entire set of code but I can post the relevant parts. I mentioned sometime back that I would be posting the code.
0 kommentar(er)
