USSGL configuration, period-end close, Treasury submissions. What the user says, what the agent does, what Oracle executes.
▶ User:
"Set up USSGL crosswalk for AP invoices — map account 2110 to USSGL 2110 and 4902 with TAS DHS-25-0501"
// Agent Actions
1 Validates USSGL account pair (2110/4902) against OMB USSGL supplement rules for AP transactions
2 Builds SLA Journal Line Type with debit/credit derivation conditions for each subledger event class
3 Maps TAS DHS-25-0501 segments to Oracle GL flexfield: Agency ID, Main Account, Sub-Level Prefix, Period of Availability
4 Compiles and activates the SLA Application Accounting Definition
🔗 Oracle Action:
Creates SLA Journal Line Rules + Journal Entry Rule Set + Application Accounting Definition; activates crosswalk for AP module
✅
USSGL crosswalk active for all AP transactions in 3 hours — every AP invoice now auto-generates the correct USSGL debit/credit pair without manual journal entries.
▶ User:
"Close GL period March 2026 for ledger DHS-USCG-Primary — post all pending journals and run trial balance"
// Agent Actions
1 Queries all unposted journal batches in the period; identifies manual entries vs. system-generated
2 Validates each journal for balanced debit/credit, valid account combinations, and open period
3 Posts approved batches via Oracle GL Posting API; flags any journals with hold reasons
4 Runs trial balance report and checks USSGL normal balance rules (debit-normal vs. credit-normal)
🔗 Oracle Action:
Posts all unposted journal batches, closes GL period, generates trial balance — GL_PERIODS updated to Closed status
✅
Period closed and trial balance confirmed in 45 minutes — all journals posted, period locked, USSGL normal balance exceptions flagged for review.
▶ User:
"Prepare Q2 FY2026 GTAS submission for all DHS TAS — validate against Treasury edits before submission"
// Agent Actions
1 Extracts USSGL trial balance by TAS/BETC for all active DHS appropriations
2 Applies GTAS validation edits: checks normal balance per USSGL account, validates BETC combinations
3 Flags SF-133 lines that fail GTAS business rules (e.g., unexpired unobligated balance sign)
4 Generates GTAS bulk file XML in Treasury-required format; produces reconciliation tie-out report
🔗 Oracle Action:
Runs GL balance extraction by TAS/BETC, formats GTAS XML output, validates against 140+ Treasury business rules
✅
GTAS bulk file ready for Treasury upload in 2 hours — all validation edits passed, reconciliation to trial balance complete, no manual XML formatting.
▶ User:
"Generate FACTS II trial balance for September 30 year-end — all DHS appropriations, full USSGL detail"
// Agent Actions
1 Queries Oracle GL for year-end balances by USSGL account, TAS, and BETC as of September 30
2 Applies FACTS II edit checks: validates proprietary + budgetary account balances, checks USSGL attribute table rules
3 Reconciles FACTS II budgetary accounts to SF-133 lines — flags discrepancies with source journal reference
4 Formats FACTS II bulk file for GOVERNMENTWIDE FINANCIAL REPORT system submission
🔗 Oracle Action:
Extracts year-end GL trial balance detail, applies USSGL attribute validation, generates FACTS II bulk file
✅
FACTS II submission file generated and validated in 3 hours — proprietary/budgetary reconciliation confirmed, all 140+ USSGL attribute edits passed.
▶ User:
"Set up new TAS 020-25-0503 for DHS Operations — no-year fund, link to existing GL ledger and fund control"
// Agent Actions
1 Validates TAS structure: Agency ID (020), Main Account (0503), availability type (X = no-year) against CARS requirements
2 Configures Oracle GL Code Combination segments: TAS → Balancing Segment, BETC as transaction attribute
3 Creates fund definition in Oracle Budgetary Control; sets ADA fund type and spending authority rules
4 Links TAS to existing SLA derivation rules so new appropriation inherits correct USSGL crosswalks
🔗 Oracle Action:
Creates GL Code Combination, fund definition, BETC mapping, and SLA rules for new TAS 020-25-0503
✅
New TAS fully operational in Oracle in 1 hour — fund control active, SLA crosswalks inherited, GTAS-ready from first transaction.
▶ User:
"GL to AP subledger is out of balance by $2.3M for March — find the break and create the correcting entry"
// Agent Actions
1 Queries XLA_AE_LINES and GL_JE_LINES to find transactions present in SLA but missing from GL (or vice versa)
2 Identifies the specific invoice batch that failed to transfer during period close due to a locked period
3 Prepares correcting journal entry with matched USSGL pair and correct TAS/BETC attributes
🔗 Oracle Action:
Queries SLA/GL tie-out views, identifies unaccounted AP transactions, posts correcting GL journal via Journal Import API
✅
$2.3M GL/SLA variance identified and corrected in 30 minutes — root cause documented, correcting journal posted, period now in balance.
▶ User:
"Execute September year-end close for all DHS ledgers — carry forward unexpired unobligated balances to FY2027"
// Agent Actions
1 Validates all September adjusting entries are posted; checks for unaccounted subledger transactions
2 Identifies multi-year and no-year appropriations (TAS with X availability) for balance carry-forward
3 Executes year-end close process: closes income statement accounts, rolls retained earnings, sets period statuses
4 Opens FY2027 periods and initializes beginning balance accounts with USSGL 3100/3107 entries
🔗 Oracle Action:
Executes GL Year-End Close process, carries forward qualifying balances, opens FY2027 periods across all DHS ledgers
✅
Year-end close complete and FY2027 open in 4 hours — all balance carry-forwards executed per OMB apportionment rules, beginning balances confirmed.