| Client | U.S. Department of Veterans Affairs |
| Industry | Federal Government — Veterans Health Administration |
| Oracle Version | Oracle Financials / CoreFLS |
| Modules | AP PO GL |
| Engagement Period | 2003 – 2004 |
| Project Type | Federal Financial System Integration — VistA Fee Payments to Oracle/CoreFLS |
| Complexity | High · Federal Government · SGL Accounting · VistA Integration · MD050 Custom Design |
The U.S. Department of Veterans Affairs engaged William Delaney Consulting to design and document the Oracle financial system integration for VA's community care fee payment processing — the mechanism by which the VA pays community (non-VA) healthcare providers for medical services delivered to veterans under VA's fee authorization programs. This engagement bridged two complex federal systems: VistA (Veterans Health Information Systems and Technology Architecture), the VA's clinical system that generates fee authorizations, and CoreFLS (Core Financial and Logistics System), the VA's Oracle-based federal financial system that processes payments and produces Standard General Ledger (SGL) accounting entries.
The MD050 functional design documents — covering fee authorization edits and cancellations, AP payment approach, PO approach, and SGL accounting approach — represent Oracle AIM deliverables produced under federal government contracting standards. The CoreFLS-to-Treasury integration for Electronic Funds Transfer payments and the SGL-compliant accounting design reflect the distinctive requirements of federal financial systems that must comply with the U.S. Government Standard General Ledger and Treasury financial reporting standards.
The VA's community care fee program — paying non-VA providers for care delivered to veterans — was one of the largest federal payment programs in 2003–2004, processing millions of payments to thousands of providers annually. The fee authorization process began in VistA: clinical staff at VA facilities authorized community care appointments and associated payments through VistA's fee management functions. These authorizations needed to flow from VistA into CoreFLS (the VA's Oracle financial system) to generate AP invoices, purchase orders, and ultimately Treasury disbursement through electronic funds transfer.
CoreFLS is Oracle Financials configured for U.S. federal government accounting requirements — a specialized variant of Oracle EBS that implements the U.S. Government Standard General Ledger (SGL) chart of accounts, Treasury financial reporting requirements (SF-133, SF-132), and federal appropriation accounting rules that commercial Oracle implementations do not address. Consultants working in CoreFLS environments must understand both Oracle's standard AP/PO/GL functionality and the additional federal accounting layer that CoreFLS imposes.
The Standard General Ledger (SGL) — maintained by the U.S. Treasury — defines the uniform chart of accounts and accounting structure required for all federal agencies. Every financial transaction in a federal Oracle system must produce SGL-compliant accounting entries that satisfy both agency financial reporting and governmentwide Treasury reporting. SGL account coding in federal Oracle implementations replaces commercial GL account generator configuration — the mapping rules are defined by Treasury, not by the agency.
The AP Approach design document defined how fee authorizations generated in VistA flowed into Oracle AP as invoices. VistA fee authorizations carry the clinical authorization data (veteran, provider, service type, authorized amount) that must map to Oracle AP invoice header and line attributes. The integration approach addressed: data extraction from VistA, transformation to Oracle AP Open Interface format, validation rules that mirror the fee authorization business rules, and error handling for authorizations that failed Oracle validation.
The PO Approach document addressed the purchasing side of community care fee management — the mechanism by which the VA's blanket purchase orders with community providers supported the AP invoice processing for fee payments. Federal procurement rules under the Federal Acquisition Regulation (FAR) govern how the VA contracts with community care providers, and the Oracle PO configuration needed to reflect those contracting structures while enabling efficient AP matching against the VA's high volume of small-dollar fee payments.
The SGL Approach document defined the U.S. Government Standard General Ledger accounting entries required for each fee payment transaction type: the appropriation accounting for fee payments charged against VA's medical services appropriation, the obligation/accrual accounting that records commitments when authorizations are issued, and the disbursement accounting when Treasury EFT payments are made. Federal appropriation accounting requires tracking obligations (commitments against budget authority) separately from expenditures — a double-entry layer that commercial Oracle GL does not implement by default.
The VISTA Fee Authorizations Edit and Cancel MD050 design document addressed the business process for modifying or cancelling previously authorized community care payments — a common occurrence when veterans reschedule appointments, when authorized services are not rendered, or when payment amounts require correction. The design specified the Oracle transaction sequences required to reverse or adjust previously posted AP invoices and their associated SGL accounting entries, while maintaining the authorization audit trail required for VA's fee management compliance.
The CoreFLS-to-Treasury EOB (Explanation of Benefits) letter design addressed the downstream reporting to veterans and providers of VA fee payments processed through Treasury's electronic funds transfer system. CoreFLS-generated payments route through the Treasury's Payment Management System (PMS), and the remittance advice (EOB letter) to the community care provider must carry sufficient detail to enable the provider to match the VA payment against their outstanding claims.
| Deliverable | Type | Purpose |
|---|---|---|
| Fee AP Approach Design | Oracle AIM Functional Design | VistA fee authorization to Oracle AP invoice integration design with open interface mapping and validation rules |
| Fee PO Approach Design | Oracle AIM Functional Design | Community care provider purchase order structure and AP matching design for fee payment processing |
| SGL Accounting Approach | Federal Accounting Design | U.S. Government Standard General Ledger accounting entries for fee authorization, obligation, and disbursement |
| MD050 — VISTA Fee Authorizations Edit and Cancel | Oracle AIM MD050 | Functional design for modifying and cancelling VistA fee authorizations with Oracle transaction reversal sequences |
| Central Fee Design | Oracle AIM Functional Design | Design for centralized fee authorization processing across VA medical centers |
| CoreFLS-to-Treasury EOB Letter Design | Integration Design | Remittance advice design for VA fee payments processed through Treasury EFT to community care providers |