Search Results financde_header_id

Overview

APPS.OTFV_COST_TRANSFER is a reporting view within the Oracle E-Business Suite (EBS) Oracle Training Administration (OTA) module, part of the Enterprise Training Resource Management (ETRM) footprint. The view presents a consolidated, denormalized picture of cost transfer transactions — that is, the movement of training costs from one general ledger account or cost center to another. Its defining characteristic is the filter tfh.type = 'CT', which restricts the result set to finance headers of type "Cost Transfer".

The view joins header-level finance records, individual finance lines, delegate bookings, event and offering definitions, class metadata, student person records, booking statuses, and organization units. Because it resolves surrogate identifiers into descriptive names and decodes lookup values into readable status text, OTFV_COST_TRANSFER is well suited to reporting, reconciliation, and downstream integration feeds rather than transactional data entry. It exposes the financde_header_id alias (a documented spelling variant of the underlying OTA_FINANCE_HEADERS.finance_header_id column) that users frequently search for when tracing cost transfer headers back to their source records.

Underlying Base Objects

The documented base objects underlying the view are:

• OTA_FINANCE_HEADERS — the driving table, filtered to type = 'CT'.
• OTA_FINANCE_LINES — joined on finance_header_id, supplying line-level billing, transfer, and money amounts.
• OTA_DELEGATE_BOOKINGS — joined on booking_id, providing the student, booking date, and booking status linkage.
• OTA_EVENTS and OTA_EVENTS_TL — class/event definitions, including start and end dates and the training center.
• OTA_OFFERINGS, OTA_ACTIVITY_VERSIONS, and OTA_ACTIVITY_VERSIONS_TL — offering and course version context.
• OTA_BOOKING_STATUS_TYPES and OTA_BOOKING_STATUS_TYPES_TL — booking status name resolution.
• OTA_CATEGORY_USAGES and OTA_CATEGORY_USAGES_TL — category name resolution.
• PER_ALL_PEOPLE_F — delegate (student) full name and employee number.
• HR_ALL_ORGANIZATION_UNITS_TL — business group and training center (class center) names.
• GL_CODE_COMBINATIONS — the transfer-from code combination, joined via tfh.transfer_from_cc_id.
• HR_BIS (PACKAGE) — used to decode the GL transfer status lookup.
• OTA_GENERAL (PACKAGE) — supporting OTA logic.

Most joins to the _TL translation tables and to the code combination are outer joins, so transactions are not silently dropped when optional descriptive attributes are absent.

Key Columns

• business_group_name — the HR business group owning the record.
• paying_cost_center — cost center bearing the training cost.
• class_title / class_type / category_name / course_name — descriptive classification of the training.
• class_start_date / class_end_date / training_duration_days — event timing and computed duration.
• class_center — training center organization name.
• student_name / employee_number / person_id — delegate identity.
• booking_status / booking_date / booking_status_type_id — booking lifecycle information.
• billing_date / currency / enrollment_amount — financial charge details from the finance line.
• transfer_date / transfer_status — the date of cost transfer and its decoded GL transfer status (via HR_BIS.BIS_DECODE_LOOKUP('GL_TRANSFER_STATUS', ...)).
• finance_line_id / financde_header_id — primary keys linking back to OTA_FINANCE_LINES and OTA_FINANCE_HEADERS; the latter is the column frequently sought by the search term "financde_header_id".
• business_group_id / training_center_id / offering_id / rco_id — operative identifiers useful for joins and drill-downs.
• The literal '_KF:SQLGL:GL#:gcc' is emitted to support flexfield/GL descriptive context for the code combination.

Common Use Cases and Queries

Typical scenarios include reconciling cost transfers posted to the general ledger, auditing transfer status and amounts by cost center, and building extracts for financial reporting. A representative query grouping transfer amounts by cost center and status is:

SELECT paying_cost_center,
       transfer_status,
       currency,
       SUM(enrollment_amount) total_amount
FROM   apps.otfv_cost_transfer
WHERE  transfer_date BETWEEN :p_from AND :p_to
GROUP  BY paying_cost_center, transfer_status, currency
ORDER  BY paying_cost_center;

To trace a specific transfer header and its lines, filtering on the documented alias works as expected:

SELECT financde_header_id,
       finance_line_id,
       student_name,
       transfer_date,
       transfer_status,
       enrollment_amount
FROM   apps.otfv_cost_transfer
WHERE  financde_header_id = :header_id;

Because all columns are read-only projections, the view is safe for concurrent reporting. For performance on large volumes, filter by business_group_id, transfer_date, or training_center_id where possible, since the underlying joins across the OTA translation and finance tables are extensive.