Body
All of the student account services payments, fees, and related charges from Banner get uploaded into Oracle every night.
There is a UC4 chain called AR_ORACLE_UPLOAD. The chain consists of two jobs. The first one is a stored procedure that creates a csv file.
The second job is a Linux shell script that calls a Rest API to upload the file to Oracle and runs the job to process the Journals. It is an
all in one API call. Note the API call uses a JWT token to connect to Oracle. We have a certificate that is uploaded to Oracle.
Should there be any errors in the import such as cross validation errors, they will show in Oracle under General Accounting -> Journals -> Import Errors
To correct the records, just click on the process id it will download an Excel file. You can make the corrections and upload to Oracle.
