The UFI Account Validation is triggered by a nightly Batch Job Service. UFI Account Validation runs automatically each night.
When The Post Charges Process batch job initiates a new Post Charges process, a forced UFI Account Validation executes if at least 30 minutes have passed since the last validation.
Process Overview
The following must occur:
- The Batch Job Service calls the UFI Web Service.
- The UFI Web Service is installed locally in your environment and configured to connect to your financial system database. It must be publicly accessible so that the WebTMA batch job service can connect.
- Access to the UFI Web Service is secured via an API Key.
The following screenshot illustrates key in UFI Web Service appsettings.json.
The UFI API Key field on the UFI Setup window is used to enter the key.
Path: Accounting > Universal Financial > UFI Setup
Segment-Based SQL Generation
UFI Account Validation dynamically builds a SQL statement using the validation scripts provided for each Account Segment.
Each segment must include two aliases for validation to function correctly.
Path: Accounting > Universal Financial > UFI Segment
The Validation SQL must return two alias (TMA_CHART_SEGMENT and TMA_CHART_SEGMENT_NAME) as illustrated in the screenshot above.
Master Account Data Retrieval
The service pulls a read-only list of master account data from your financial system using the generated SQL.
Invalid Account Table Management
The Invalid Account table is cleared at the beginning of the validation process to ensure accurate, up-to-date results.
WebTMA Account Validation
The system retrieves a list of WebTMA Accounts from the WebTMA database.
Each WebTMA Account is validated against the following criteria:
- Number of segments
- Length of each segment
- Existence of each segment in the master account data
Accounts that do not meet the above criteria are considered invalid.
Their Account ID is inserted into the Invalid Account table.
Invalid Accounts
The following constraints apply to Invalid Accounts:
- Cannot be selected for new use within WebTMA record entry.
- Cannot be used during the Post Charges batch process.