The United States Coast Guard (USCG) had numerous
legacy systems for financial, procurement, material management and
project management. Particularly, the USCG was unable to appropriately
track costs and inventory relating to the repairs of ships, boats,
etc. The USCG was tasked to be in compliance with Chief Financial
Officers (CFO) Act and governments Anti-Deficiency Act when approving
Purchase Requisitions and Materials.
How Segundo Helped
Segundo performed data mapping between the legacy
systems and the Oracle Federal Financial applications. In automating
Industrials, Segundo implemented the functional and technical designs
for Oracle Project Accounting, Oracle Accounts Payable, Oracle Purchasing
and Oracle Inventory. Thereby ensuring accurate financials data
is integrated with Oracle General Ledger and Departmental Accounting
and Financial System (DAFIS), Department of Transportation's
(DOT's) official system of records.
Segundo also developed a solution so that USCG
complies with the government's Anti-Deficiency Act. The Anti-Deficiency
Act precludes the government agency from over spending its budgets.
The funds check solution ensured that every cost charged to a project
has been funded and therefore as a compliance with the Anti-Deficiency
Act that each and every project are not overcharged.
Segundo designed and developed a number of custom
extensions to comply with the integration between Oracle Federal
Financial applications and DAFIS. Segundo used its open and scalable
methodology to deliver such extensions. Particular emphasis was
given not to customize any standard table and thereby ensuring the
ease of future upgrades.
As a compliance with the Anti-Deficiency Act, Segundo
developed a real time funds check solution within the Oracle Project
Accounting module. By employing pre-insert triggers functionality
the funds check solution can be invoked from inventory issue, purchase
requisition approval or any other application screen. There are
three elements to the funds check solution, project budgets, total
cost, and potential charge. Segundo designed and developed custom
views to analyze budgets at the lowest, top and project levels.
Subsequently total cost analyzed actual costs and commitments. The
commitments accounted for all costs not currently reside in Oracle
Project Accounting including transactions awaiting transfers due
to systems process. The commitment cost calculation excluded open
purchase requisitions as one of the legislation compliance tests.
Therefore, prior to transacting a potential charge to a project/task
relationship, the funds check solution compares project budget against
total cost by rolling up the costs at the appropriate budget level.
If the transaction is unsuccessful, a rudimentary error is displayed.
Segundo implemented such solutions across USCG sites through out
the United States.
Also the USCG passed Chief Financial Officers (CFO)
Act audit and as a result Segundo employees honored by the USCG
for their outstanding contributions.