FND Document Categories – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Document categories used by document sequence assignments.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Application
Oracle EBS Tables Used
fnd_application_vl, fnd_doc_sequence_categories
Report Categories
Related Reports
GL Account Analysis, AP Invoice and Payment Audit by Voucher Number, GL Account Distribution Analysis, PO Approved Supplier List Upload, AP Invoices and Lines, AP Invoice Upload
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Document Categories 24-May-2025 134602.xlsx |
| Blitz Report™ XML Import | FND_Document_Categories.xml |
| SQL Source | FND Document Categories.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-document-categories/ |
Executive Summary
The FND Document Categories report lists the categories used to classify documents for sequential numbering. In Oracle EBS, a “Category” is the logical bucket that gets assigned a specific sequence.
Business Challenge
- Voucher Numbering: Verifying that all necessary document types (Invoices, Journals, Payments) have a category defined for sequential numbering.
- Audit Compliance: Ensuring that document categories align with legal reporting requirements (e.g., VAT registers).
The Solution
This Blitz Report lists the defined categories:
- Category Name: The internal code and user-friendly name.
- Table Name: The table associated with the category (e.g.,
AP_INVOICES_ALL). - Description: The purpose of the category.
Technical Architecture
The report queries FND_DOC_SEQUENCE_CATEGORIES.
Parameters & Filtering
- Application: Filter by module (e.g., “Payables”, “General Ledger”).
Performance & Optimization
- Simple List: This is a lightweight configuration report.
FAQ
- Q: How do I assign a sequence to a category?
- A: Use the “FND Document Sequence Assignments” report to see the linkage between Categories, Ledgers, and Sequences.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH