Oracle EBS PO Table Names and Description :-
PO_ACTION_HISTORY :- Document approval and control action history table, It stores records for each action (approval, rejection, etc.), linking to the document, user, action type, and date, making it crucial for understanding a document's journey.
PO_AGENTS :- The central table for buyer/purchasing manager details, linking to human resources.Stores buyer ID (AGENT_ID), defaults (category, ship-to), and links to FND_USER and HR_EMPLOYEES.
PO_DISTRIBUTIONS_ALL :- Purchase order distributions
PO_HEADERS_ALL :- Document headers (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINES_ALL :- Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINE_LOCATIONS_ALL :- Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
PO_RELEASES_ALL :- Purchase order releases
PO_LINES_ARCHIVE_ALL :- Archived purchase order lines
PO_LINE_LOCATIONS_ARCHIVE_ALL :- Archived purchase order shipments
PO_HEADERS_ARCHIVE_ALL :- Archived purchase orders
PO_LINE_TYPES_B :- Line types
PO_RELEASES_ARCHIVE_ALL :- Archived releases
PO_REQUISITION_HEADERS_ALL :- Requisition headers
PO_REQUISITION_LINES_ALL :- Requisition lines
PO_REQ_DISTRIBUTIONS_ALL :- Requisition distributions
RCV_TRANSACTIONS :- Receiving transactions
RCV_SHIPMENT_HEADERS :- Shipment and receipt header information
RCV_SHIPMENT_LINES :- Receiving shipment line information
Oracle EBS Inventory Table Names and Description :-
MTL_CATEGORIES_B :- Code combinations table for Item Category, the core base table for item categories, storing category definitions and linking items to them within Category Sets
MTL_CATEGORY_SETS_B :- is the base table defining Category Sets, which are grouping schemes (like "Purchasing Categories," "Inventory Categories") for items, linked to flexfield structures and controlled at item or item/org levels
MTL_CUSTOMER_ITEMS :- Customer item Information
MTL_CUSTOMER_ITEM_XREFS :- Relationships between customer items and inventory items
MTL_DEMAND :- Sales order demand and reservations
MTL_DEMAND_HISTORIES :- Sales order demand and reservations
MTL_ITEM_LOCATIONS :- Definitions for stock locators
MTL_ITEM_REVISIONS_B :- Item revisions
MTL_ITEM_TEMPLATES_B :- Item template definitions
MTL_ITEM_TEMPL_ATTRIBUTES :- Item attributes and attribute values for a template
MTL_LOT_NUMBERS :- Lot number definitions
MTL_MATERIAL_TRANSACTIONS :- Material transaction table
MTL_MATERIAL_TRANSACTIONS_TEMP :- Temporary table for processing material transactions
MTL_ONHAND_QUANTITIES_DETAIL :- FIFO quantities by control level and receipt,it is a core Inventory table storing detailed, real-time, stack-based on-hand quantities per item, organization, subinventory, locator, and lot, acting as a running log for receipts and issues, allowing accurate availability checks by summing quantities for matching criteria
MTL_PARAMETERS :- It stores organization-level parameters that govern the operational behavior and default settings for each specific inventory organization. It contains records only for organizations classified as Inventory Organizations.
MTL_RESERVATIONS :- Reservations
MTL_SECONDARY_INVENTORIES :- Subinventory definitions
MTL_SECONDARY_LOCATORS :- Item-subinventory-locator assignments
MTL_SERIAL_NUMBERS :- is the core table storing definitions and current status for every unique serial number, linking to item details in MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_B :- is the core base table for item master definitions, storing key attributes for inventory, engineering, and purchasing items across different organizations
MTL_TRANSACTION_ACCOUNTS :- Material transaction distributions
MTL_TRANSACTION_TYPES :- Inventory Transaction Types Table
MTL_TXN_REQUEST_HEADERS :- Move Order headers table
MTL_TXN_REQUEST_LINES :- Move order lines table
MTL_UNIT_TRANSACTIONS :- Serial number transactions
Oracle EBS General Ledger Table Names and Description :-
GL_CODE_COMBINATIONS :- is the core table storing valid, unique Accounting Flexfield (Chart of Accounts) combinations, identified by CODE_COMBINATION_ID, linking segments (like Company, Account, Cost Center) to specific ledger IDs, and holding flags for enablement, budget/posting, and account type, crucial for joining GL data with subledgers like AP, AR, and PO
GL_SETS_OF_BOOKS :- (from 11i) is largely replaced by GL_LEDGERS, which stores ledger information like currency, chart of accounts, and calendar, but GL_SETS_OF_BOOKS still exists for legacy support and reference, linked to key tables like GL_CODE_COMBINATIONS, GL_JE_HEADERS, and GL_BALANCES to define financial structures. Understanding these tables helps in querying account balances, journal entries, and set up details in Oracle General Ledger.
GL_IMPORT_REFERENCES :- Stores individual transactions from subledgers
GL_DAILY_RATES :- Stores the daily conversion rates for foreign currency Transactions
GL_PERIODS :- The core table holding definitions for each accounting period (e.g., 'JAN-24') within a specific calendar, including START_DATE, END_DATE, PERIOD_TYPE, and fiscal year info.
GL_JE_BATCHES :- Stores journal entry batches
GL_BALANCES :- Stores actual, budget, and encumbrance balances for detail and summary accounts
GL_BUDGETS :- Stores Budget definitions
GL_BUDGET_INTERFACE :- Upload budget data from external sources
GL_DAILY_RATES_INTERFACE :- Import daily conversion rates
GL_PERIOD_SETS :- Defines the accounting calendars (like 'Corporate Calendar'), linking to GL_PERIODS, established in the Accounting Calendar form.
GL_PERIOD_STATUSES :- Tracks the open/closed/future status (CLOSING_STATUS) for periods, often tied to specific applications/ledgers.
GL_PERIOD_TYPES :- Stores period types (e.g., 'Monthly', 'Quarterly') used in calendars, defined via the Period Types form.
GL_JE_HEADERS :- Holds header info for journal entries (batches, categories, sources).
GL_JE_LINES :- Contains the detailed debit/credit lines for journal entries.
GL_INTERFACE :- A staging table for data imported from external systems before Journal Import processes it into GL.
Oracle EBS XLA-Subledger Accounting Table Names and Description :-
XLA_EVENTS :- The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE.
XLA_TRANSACTION_ENTITIES :- The table XLA_ENTITIES contains information about sub-ledger document or transactions.
XLA_AE_HEADERS :- The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry headers.
XLA_AE_LINES :- The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines.
XLA_DISTRIBUTION_LINKS :- The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines.
XLA_ACCOUNTING_ERRORS :- The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program.
XLA_ACCTG_METHODS_B :- The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of accounts specific. Enabled SLAMs are assigned to ledgers.
XLA_EVENT_TYPES_B :- The XLA_EVENT_TYPES_B table stores all event types that belong to an event class.
XLA_GL_LEDGERS :- This table contains ledger information used by subledger accounting.
Oracle EBS CE - Cash Management Table Names and Description :-
CE_BANK_ACCOUNTS :- This table contains bank account information. Each bank account must be affiliated with one bank branch.
CE_BANK_ACCT_BALANCES :- This table stores the internal bank account balances
CE_BANK_ACCT_USES_ALL :- This table stores information about your bank account uses.
CE_STATEMENT_HEADERS :- Bank statements
CE_STATEMENT_LINES :- Bank statement lines
CE_STATEMENT_HEADERS_INT :- Open interface for bank statements
CE_STATEMENT_LINES_INTERFACE :- Open interface for bank statement lines
CE_TRANSACTION_CODES :- Bank transaction codes
