Search Results per_letter_request_lines




Overview
Explore in AI Chat

Overview

The PER_LETTER_REQUEST_LINES table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER product family. It serves as the transactional repository for the detailed components of a letter generation request. While the parent table, PER_LETTER_REQUESTS, defines the overall request parameters, this table stores the granular details for each individual letter to be produced. Its primary role is to manage the execution and tracking of mass or individual correspondence, such as employment verification letters, promotion notifications, or other HR-related documents, for one or more employees or assignments.

Key Information Stored

The table's structure is designed to link a letter request to specific entities and capture their processing status. The primary key, LETTER_REQUEST_LINE_ID, uniquely identifies each line. Critical foreign key columns establish essential relationships: the LETTER_REQUEST_ID links the line to its parent request in PER_LETTER_REQUESTS; the BUSINESS_GROUP_ID associates the line with a specific organizational unit via HR_ALL_ORGANIZATION_UNITS; and the ASSIGNMENT_STATUS_TYPE_ID connects to a valid assignment status in PER_ASSIGNMENT_STATUS_TYPES. Additional columns typically store identifiers for the specific person or assignment targeted by the letter, the output content or a reference to it, and status flags indicating whether the line has been processed, printed, or encountered an error.

Common Use Cases and Queries

This table is central to reporting on and troubleshooting the letter generation process. Common operational queries involve checking the status of letters for a specific batch request or identifying failed items. For instance, to find all unprocessed letter lines for a given request, a query would filter on the parent request ID and a relevant status column. Another frequent use case is generating an audit report of all letters produced for an employee over time, which requires joining PER_LETTER_REQUEST_LINES to PER_LETTER_REQUESTS and filtering by person identifier. Administrators may also query this table to clean up or retry letter lines that failed due to system errors, using the line-level details to diagnose the issue.

Related Objects

As indicated by the foreign key metadata, PER_LETTER_REQUEST_LINES has direct dependencies on several key HR tables. Its primary relationship is with the parent table PER_LETTER_REQUESTS. It also references HR_ALL_ORGANIZATION_UNITS for business group validation and PER_ASSIGNMENT_STATUS_TYPES for assignment status validation. The table is likely referenced by standard Oracle HR APIs and concurrent programs that manage the letter generation workflow. While not listed in the provided metadata, it may also be the base for key HRMS letter generation forms and is essential for any custom integrations or reports that need to access the detailed results of an HR letter request.