Batch Element Entry Loader process

Batch Element Entry has significant advantages over PAYMIX, but it should also be noted that PAYMIX is being phased out in 11.5.4 of the application. BEE can be utilized manually, but can be batch loaded as well. In 11.0.3 the application did not provide the api's required for loading, so we emulated the PAYMIX api's on our own. These were later replaced by 11.5.4 api's.

Some things to note:

- BEE loader files are comma delimited format (csv). These can be easily generated from an Excel spreadsheet. (see below for layout requirements)
- Batch line entries that fail will need to be resubmitted under a new batch name. They cannot be appended to an existing batch.
- If no batch lines are created, or the batch header creation fails completely, it may require one of the following :
- Deletion of the Batch Header via the application
- Deletion of the entries that apply to the Batch in question within the TEMP_PAY_BATCH_LINES table (this table stores the csv loader file for processing)
- Output of job will be displayed in the concurrent manager, indicating failure points if they occur.
- Upon successful completion of the BEE loader, the data in TEMP_PAY_BATCH_LINES will be truncated since it is temporary only.

Sample code here

Pages: 1 · 2 · 3 · 4 · 5