Search Results get_price_list

Overview

APPS.OTA_FINANCE is the core financial integration package within the Oracle E-Business Suite Training and Events (formerly OTA/ETRM) module. Its primary business function is to create, maintain, and reconcile finance lines that represent the monetary obligations associated with bookings, resource bookings, resource allocations, and booking deals. In Oracle EBS 12.1.1 and 12.2.2, the OTA schema handles event management, resource scheduling, and delegate enrollment, and OTA_FINANCE serves as the bridge between those operational records and the financial tables that track revenue, cost, and transfer status.

The package body declares a private global identifier, g_package, used consistently for hr_utility.set_location tracing, which reflects Oracle's standard instrumentation convention in OTA packages. The excerpt shown demonstrates the create_finance_line private procedure, which determines a line type based on the source of the request: 'V' for resource bookings, 'R' for resource allocations, 'E' for bookings, and 'P' for booking deals.

Key Procedures and Functions

• MAINTAIN_FINANCE_LINE — This is the principal public entry point for creating and updating finance line records. It encapsulates the logic required to persist monetary amounts, currency codes, standard/unitary/money amounts, transfer status, and cancellation flags against a finance header. Callers invoke this procedure to synchronize financial detail with booking and resource activity.
• GET_DEAL_UNIT_BASED — This function returns unit-based pricing or quantity information associated with a booking deal. It is used to derive the per-unit financial basis required when constructing finance lines, particularly for deals that are priced on a unit rather than a lump-sum basis. Notably, this is the procedure most closely related to the user's search term get_price_list, since price list data is the underlying source for unit-based pricing.

Both procedures fit an "OTHER" API classification, meaning they are internal supporting APIs rather than formally published, versioned interfaces. Custom code referencing them should be treated as a dependency on non-guaranteed internals.

Tables Accessed

• OTA_FINANCE_HEADERS — The parent financial record. Finance lines are inserted or updated with a foreign key reference to a header, which groups related lines and carries header-level currency and totals.
• OTA_BOOKING_DEALS — Provides deal-level context, including deal identifiers and types, used in determining line type and in the unit-based pricing lookup performed by GET_DEAL_UNIT_BASED.
• OTA_PRICE_LISTS — Supplies price list definitions and rates. This table underpins unit-based and standard amount calculations, making it directly relevant to the get_price_list search.

Usage Notes

OTA_FINANCE is typically invoked from OTA forms, from concurrent programs that process bookings and enrollments, and from other OTA packages — the metadata indicates it is referenced by four other packages. Because MAINTAIN_FINANCE_LINE and GET_DEAL_UNIT_BASED are classified as OTHER APIs, direct invocation from custom code is possible but unsupported. Developers integrating with ETRM finance data should prefer the documented public APIs where available and treat OTA_FINANCE as a component driven indirectly through standard booking and enrollment flows. Callers relying on price-list-derived amounts should validate that OTA_PRICE_LISTS records exist for the applicable deal and currency before invoking maintenance logic, since unit-based computation depends on that data.