Search Results ozf_funds_all_b




Overview
Explore in AI Chat

Overview

The OZF_FUNDS_ALL_B table is the fundamental master data table for fund definitions within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for all fund entities, which are monetary budgets or pools of money allocated for specific trade promotions, marketing activities, or channel programs. This table is critical for the financial control and allocation of funds across various marketing and sales initiatives, enabling organizations to plan, track, and manage their trade spending. Its multi-org structure, indicated by the "_ALL_" suffix, allows it to store data for multiple operating units, a core design principle of Oracle EBS.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal the core data attributes. The table's primary key is FUND_ID, which uniquely identifies each fund record. Key relational columns include PARENT_FUND_ID, which enables hierarchical fund structures where a parent fund can have multiple child funds. The SET_OF_BOOKS_ID links the fund to its associated general ledger, ensuring financial integration. The THRESHOLD_ID connects to the OZF_THRESHOLDS_ALL_B table, allowing for the definition of spending limits or control rules on the fund. Other typical columns in such a base table would include fields for fund name, status, currency, start and end dates, total budget amount, and various system control columns like CREATION_DATE and LAST_UPDATE_DATE.

Common Use Cases and Queries

This table is central to financial reporting and operational processes in Trade Management. Common use cases include generating fund utilization reports, validating available budget before creating new claims or offers, and managing fund hierarchies for top-down budget allocation. A fundamental query involves joining the table with its translated descriptive flexfield (TL) table to retrieve fund names in a specific language. For example, to list active funds for a specific operating unit, a query might be: SELECT f.FUND_ID, t.NAME, f.STATUS FROM OZF_FUNDS_ALL_B f, OZF_FUNDS_ALL_TL t WHERE f.FUND_ID = t.FUND_ID AND f.ORG_ID = :org_id AND f.STATUS = 'ACTIVE' AND t.LANGUAGE = USERENV('LANG');. Another critical pattern is querying parent-child relationships to analyze budget roll-ups using a self-join on PARENT_FUND_ID.

Related Objects

The OZF_FUNDS_ALL_B table has extensive relationships, acting as a hub for financial data across the Trade Management and Marketing modules. Key documented relationships include: