Blitz Report Excel Add-in Skills
AI skills for business users of the Blitz Report Excel add-in: Oracle E-Business Suite analysis, period close readiness and upload actions in Claude in Excel and Microsoft 365 Copilot in Excel. Installs and explains the skills; they run in Excel.
Install
/plugin marketplace add enginatics/ai-skills
/plugin install blitz-report-excel-addin-ai-skills@enginaticsThen run /blitz-report-excel-addin-ai-skills:excel-skills-setup to install the skills into Claude in Excel or Microsoft 365 Copilot in Excel, or download a single skill below. The skills run in Excel through the Blitz Report Excel add-in.
Skills
Analytics
Anomaly Detection
br-anomaly-detectionFind unusual or suspicious rows in a Blitz Report dataset — outlier transactions, duplicate invoices, abnormal amounts, data-quality errors — using robust statistics, Mahalanobis distance, Benford's Law, and duplicate detection.
Clustering
br-clusteringSegment a Blitz Report dataset into natural groups using K-Means or DBSCAN, then profile and name each segment in plain business language.
Data Dashboard
br-data-dashboardBuild an interactive dashboard on top of any tabular data sheet — KPI cards, charts, and slicers — without modifying the source columns.
Forecasting
br-forecastingForecast a time series from a Blitz Report — future demand, sales, GL trend, AR collections, cash, or inventory — using Excel's native FORECAST.ETS (Holt-Winters) with seasonality detection, confidence intervals, and a backtest accuracy check.
RFM Analysis
br-rfm-analysisScore customers (or vendors) on Recency, Frequency, and Monetary value from a transactional Blitz Report and map them to named segments like Champions, Loyal, At Risk, and Hibernating.
Audit and Security
EBS Audit Trail & Access Review
br-audit-trailAnswer "who changed what, when" across Oracle EBS setups and access: mine the FND Audit Trail reports for setup and profile changes by record and column, correlate with user login history and responsibility assignments, and produce a reviewable change narrative for an audit window or an incident. Read-only.
Instance Diff
br-instance-diffCompare Oracle EBS instances through Blitz Reports in Excel: run the same report with the same parameters against two configured environments (DEV/TEST/PROD, pre/post-upgrade, source/clone) and explain the differences — row counts, missing and extra keys, changed values by column — or diff the two instances' report catalogs.
Cash Management
Cash and Working Capital
Fixed Assets
General Ledger
Finish a Spreadsheet Server / GL Wand / GL Connect conversion
br-fsg-conversion-reviewFinish a financial statement workbook converted from Spreadsheet Server, GL Wand or GL Connect to Blitz FSG: read its Conversion Log sheet, fix in the workbook what the converter could not (period cells read by other formulas, formula-driven format and segment cells, hierarchy suffixes, unsupported currency types, cells left unconverted), ask the user about the rest, and mark every log line.
GL Account Coding Assistant
br-gl-account-coderSuggest GL account coding from the ledger's own history: given transactions to code (or re-code), mine GL Account Analysis for how this entity has historically coded the same supplier, source, category or description, and propose the account combination with a confidence level and the precedent shown. Optionally stage approved corrections as a journal via the GL Journal Upload — only on explicit user confirmation.
GL Period Close Readiness
br-gl-close-readinessAssess Oracle EBS General Ledger period-close readiness in Excel: have the br-run-reports skill extract GL period statuses, unposted/error journals, and the trial balance, then give a red/amber/green verdict with remediation and build a GL close-readiness scorecard.
GL variance analysis
br-fsg-variance-analysisExplain why Oracle EBS GL balances moved - compare a financial statement or account balances between two periods, year over year or actual against budget with Blitz FSG, flag the material variances, drill the largest to journal lines and subledger transactions, and draft variance commentary for the user to review.
Getting Started
Analytics Standards
br-analytics-standardsShared performance and coding standards for all br_ analytics skills (br-ap-holds-analysis, br-ap-close-readiness, br-ar-close-readiness, br-gl-close-readiness, br-fa-close-readiness, br-inv-cost-close-readiness, br-ce-recon-readiness, br-subledger-gl-reconciliation, br-close-process-monitor, br-month-end-readiness). Read at the start of any br_ skill run via read_skill("br-analytics-standards").
Blitz Report Finder
br-report-finderFind the right Oracle EBS Blitz Report by MEANING, not by name: load the full report library once into the workbook, then match the user's business question ("which report shows unapplied receipts by operating unit?") against every report's name, category and description, explain the top candidates, and hand the chosen one to br-run-reports.
Blitz Report Skill Author
br-skill-authorWrite a new Blitz Report Excel skill or extend one of the shipped br-* skills: interview the user for the business question, discover the exact report names, parameters and list values live from the connected Oracle EBS instance, write a complete SKILL.md in the shipped format into a worksheet, and give the steps to install it in Copilot in Excel or Claude in Excel.
Excel Skills Setup
excel-skills-setupInstall the Blitz Report Excel add-in AI skills into Claude in Excel or Microsoft 365 Copilot in Excel, update them, and explain which skill fits a task.
Financial statements in Excel
br-run-fsgBuild, refresh, read and drill Oracle EBS financial statements in Excel with Blitz FSG through the Blitz Report add-in - income statement, balance sheet, trial balance, account balances by period, actual vs budget - and explain a number by drilling it to account balances, journal lines and subledger transactions, then to a detailed Blitz Report of those transactions.
Run Blitz Reports in Excel
br-run-reportsFind, run, and analyze Oracle EBS Blitz Reports in Excel (GL, AP, AR, INV, PO, WIP, FA, HR and concurrent-program data).
Run Blitz Uploads in Excel
br-run-uploadsCreate, load or update Oracle EBS records from Excel with Blitz Uploads via the BLITZ REPORT ADD-IN (the br_* worksheet functions) - journals, invoices, purchase documents, items, suppliers, customers, assets and more (GL, AP, AR, PO, INV, WIP, HR, FA, CE).
Inventory
INV Cycle Count Planner
br-inv-cycle-count-plannerPlan and steer Oracle EBS cycle counting: analyse count accuracy history, find never-counted and overdue items, recommend count priorities by value/velocity/accuracy (ABC-weighted), and surface the approval and adjustment backlog. Read-only — recommendations feed the customer's own cycle count scheduling in EBS.
INV Exception Triage
br-inv-exception-triageTriage Oracle EBS Inventory exceptions in Excel: have the br-run-reports skill extract negative on-hand balances, stuck interface/error transactions, and cycle counts pending approval, then rank everything by severity with a recommended owner and fix, and build one exception dashboard.
INV Stock Level Optimizer
br-inv-stock-optimizerRecommend min/max quantities, reorder points and safety stock per item and subinventory in Oracle EBS from actual demand history and on-hand position — then, only on explicit user confirmation, apply the approved recommendations back to EBS via the INV Item Subinventory Upload or INV Safety Stock Upload.
Inventory / Costing Period Close Readiness
br-inv-cost-close-readinessAssess Oracle EBS Inventory/Costing period-close readiness in Excel: have the br-run-reports skill extract pending inventory transactions, missing WIP/receiving accounting, and pending cost adjustments, then give a red/amber/green verdict with remediation and build an Inventory close-readiness scorecard.
Manufacturing
BOM Accuracy Validator
br-bom-validatorValidate Oracle EBS bill-of-material accuracy against how the shop floor actually consumes material: compare BOM structures with WIP component requirements and shortages, flag suspect components (never issued, always short, quantity drift), and stage approved BOM corrections via the BOM Bill of Materials Upload — only on explicit user confirmation.
WIP Job & Variance Analysis
br-wip-variance-analysisAnalyze Oracle EBS WIP job health and cost exposure in Excel: have the br-run-reports skill extract job statuses, WIP value, and component shortages, then rank stuck and past-due jobs, surface value concentration and close candidates, and build one WIP analysis dashboard.
Payables
AP Duplicate Invoice Hold Placement
br-ap-duplicate-holdStop payment of suspected duplicate AP invoices from Excel: take the unpaid duplicates a br-ap-duplicate-payments run identified, place a payment-blocking hold on each suspect copy via the "AP Invoice Hold Upload", and record the duplicate evidence in the hold reason — only on the user's explicit confirmation.
AP Duplicate Payment Recovery
br-ap-duplicate-paymentsFind duplicate and overpaid Oracle EBS Accounts Payable invoices/payments in Excel: have the br-run-reports skill extract the AP invoice universe, fuzzy-match it for duplicate-entry patterns (same supplier + amount, re-keyed invoice numbers, transposed digits, duplicate vendor masters, cross-OU double entry), separate recoverable (both paid) from preventable (one still open), and build a ranked recovery worklist with $-at-risk.
AP Intelligence Dashboard
br-ap-intelligenceBuild a live AP intelligence dashboard in Excel from Oracle EBS: run the "AP Cash Requirement" Blitz Report and lay out the five payables KPIs (invoices on hold, total AP outstanding, overdue 30+ days, approved due within 7 days, unapproved due within 15 days), a ranked AI action summary, an AI commentary per KPI, drill-down lists, due-bucket and supplier tables, and answer follow-up questions as new KPI cards.
AP Invoice Hold Release
br-ap-hold-releaseRelease Oracle EBS AP invoice holds from Excel: take the holds that qualify for release, pre-populate the "AP Invoice Hold Upload" grid with the correct release reason per hold, validate it, show the user exactly what will be released, and — only on their explicit confirmation — submit it so Payables releases the holds.
AP Invoice Holds Analysis
br-ap-holds-analysisAnalyze Oracle EBS AP invoice holds in Excel: run the "AP Invoice on Hold" Blitz Report, categorise and age the holds, flag anomalies, build a holds dashboard, flag RELEASE CANDIDATES and offer to hand them to br-ap-hold-release for action.
AP Invoice Upload from documents
br-ap-invoice-uploadCreate Oracle EBS AP invoices from source documents using the BLITZ REPORT ADD-IN (the br_* worksheet functions) — supplier invoices, reimbursement vouchers, freight bills, utility statements, expense receipts — by reading the documents, running the AP Invoice Upload, filling its sheet, then validating against real EBS and self-correcting.
AP Payment Actions
br-ap-payment-actionsAct on a br-ap-payment-optimizer run from Excel: produce the prioritized pay-run list for the invoices to pay now (discount capture), and — on explicit confirmation — place payment-blocking holds via the "AP Invoice Hold Upload" on the invoices the user chooses to defer.
AP Payment-Run Optimizer
br-ap-payment-optimizerOptimize an Oracle EBS Accounts Payable payment run in Excel: have the br-run-reports skill extract the AP cash requirement (due invoices, available early-pay discounts, due dates, payment priority), classify each invoice as capture-discount / pay-to-avoid-late / defer-to-due / priority-must-pay, select the best pay run within a cash constraint by discount ROI, quantify the discount $ captured and DPO impact, and build a payment-run dashboard.
AP Period Close Readiness
br-ap-close-readinessAssess Oracle EBS Accounts Payable period-close readiness in Excel: have the br-run-reports skill extract "AP Period Close Exceptions", summarise the blockers by exception type, give a red/amber/green readiness verdict with the remediation for each blocker, and build an AP close-readiness scorecard.
Period Close
Close Process Monitor
br-close-process-monitorMonitor the Oracle EBS concurrent programs that drive a period close in Excel: have the br-run-reports skill extract recent Create Accounting / Transfer to GL / Cost Manager / Depreciation / Journal Import / AutoInvoice request status, flag errored, stuck, and long-running close jobs, and build a close-process monitor dashboard.
Month-End Close Readiness Orchestrator
br-month-end-readinessOrchestrate a full Oracle EBS month-end close readiness assessment in Excel: run the per-module readiness checks (AP, AR, Inventory/Costing, FA, GL), the close-process monitor, and the subledger-to-GL reconciliation, then assemble one master scorecard with a per-module red/amber/green status, the ranked blockers, and the recommended close sequence.
Subledger-to-GL Reconciliation
br-subledger-gl-reconciliationReconcile Oracle EBS subledgers to the General Ledger in Excel: have the br-run-reports skill extract AP, AR, Inventory and FA control balances and tie each to its GL control account, surfacing the variance per subledger with a red/amber/green verdict.
Purchasing
PO 3-Way Match Exception Triage
br-po-match-exceptionsTriage Oracle EBS 3-way match exceptions — invoices held because PO, receipt and invoice disagree on quantity or price — explain the root cause per hold (not received, over-billed, price change, receipt discrepancy), and route each to the right resolver: receiving, buyer, or AP. Read-only.
PO Period Close Readiness
br-po-close-readinessAssess Oracle EBS Purchasing period-close readiness in Excel: have the br-run-reports skill extract the AP/PO accrual reconciliation, the aged uninvoiced receipts, and the period status, then give a red/amber/green verdict with remediation and build a PO close-readiness scorecard.
Supplier Risk Scoring
br-supplier-risk-scoringScore Oracle EBS suppliers on risk in Excel: have the br-run-reports skill extract spend, holds, price variance and delivery history, then combine dependency, reliability, price stability and anomaly signals into a ranked supplier risk register with a named driver per supplier.
Receivables
AR Collections Note Logging
br-ar-collections-notesLog collection notes into Oracle EBS Advanced Collections from Excel: take the ranked customers and drafted dunning messages a br-ar-collections-worklist run produced, stage one note per customer via the "IEX Collection Note Upload", and — on the user's explicit confirmation — submit them so the collections team sees the worklist as logged activity.
AR Collections Worklist
br-ar-collections-worklistBuild a prioritized Oracle EBS Accounts Receivable collections worklist in Excel: have the br-run-reports skill extract open AR aging, past-due detail and disputes, score each customer by collectible-$-at-risk (aging severity), exclude disputed balances, assign a dunning tier, draft the reminder text per tier, and build a collections dashboard. Payment-behaviour (receipt-history RFM) re-ranking is an add-on that runs only when the user asks for it.
AR Credit Risk & DSO Analysis
br-ar-credit-riskScore customer credit risk and analyse DSO from Oracle EBS Receivables: combine credit limits and utilization, aging severity, payment behaviour and balance trend into a per-customer risk grade with the drivers named, plus a DSO decomposition showing which segments and behaviours move it. Read-only.
AR Period Close Readiness
br-ar-close-readinessAssess Oracle EBS Accounts Receivable period-close readiness in Excel: have the br-run-reports skill extract unaccounted AR transactions, AutoInvoice interface errors, and the AR-to-GL reconciliation, then give a red/amber/green verdict with remediation and build an AR close-readiness scorecard.