OZF — Trade Management
183 documented tables · 37 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
OZF_FUNDS_ALL_B |
Fund definition master base table. | hub |
OZF_OFFERS |
This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the forei | hub |
OZF_THRESHOLDS_ALL_B |
Holds information on Funds Thresholds. | hub-leaning |
OZF_CLAIMS_ALL |
This table stores the Claim headers | hub |
OZF_REQUEST_HEADERS_ALL_B |
This table stores the request headers information for soft fund and special pricing | hub-leaning |
OZF_WORKSHEET_HEADERS_B |
Table to store the Worksheet header information | hub-leaning |
OZF_NA_RULE_HEADERS_B |
Table To store the Net Accrual Rule sets | hub-leaning |
OZF_REASON_CODES_ALL_B |
This table is used for storing the reasons for a claim | hub |
OZF_CLAIM_TYPES_ALL_B |
This table is used to store Claim Types (Base Table) | hub |
OZF_ACT_METRICS_ALL |
This table stores the value for budget or quota allocation | satellite-leaning |
OZF_OFFER_ADJUSTMENTS_B |
Stores all the adjustments made for an offer | hub-leaning |
OZF_REASONS |
This Table is used to store Reason Codes | satellite-leaning |
OZF_FUNDS_UTILIZED_ALL_B |
Fund utilization details | hub-leaning |
OZF_CHARGEBACK_INT_ALL |
chargeback interface table. | satellite-leaning |
OZF_ACCTNG_EVENTS_ALL |
This table stores accounting events occuring on a Claim | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
OZF_VOLUME_CALCULATION_PUB |
PUB | 16 | 6 packages |
OZF_CLAIM_GRP |
GRP | 8 | 6 packages |
OZF_OFFER_PUB |
PUB | 3 | 5 packages |
OZF_ASSIGNMENT_QUALIFIER_PUB |
PUB | 1 | 1 packages |
OZF_PARTNER_CLAIM_GRP |
GRP | 2 | 1 packages |
OZF_VENDORMERGE_GRP |
GRP | 1 | 1 packages |
OZF_SD_REQUEST_PUB |
PUB | 3 | 1 packages |
OZF_FUNDS_PUB |
PUB | 12 | 1 packages |
OZF_CLAIM_PUB |
PUB | 12 | 1 packages |
OZF_FUND_UTILIZED_PUB |
PUB | 2 | 1 packages |