Results for “completion_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view HXC_BASE_PA_ONLINE_TASKS_V is an APPS-owned database object in the Oracle E-Business Suite Time and Labor Engine (HXC) product family. It exposes project task information from Oracle Projects in a form intended for consumption by the Time and Labor online task validation and entry logic. The view has a documented status of VALID and is referenced within ETRM under both Oracle EBS 12.1.1 and 12.2.2.

The name prefix "HXC_BASE" indicates that this object serves as a foundational (base) definition that feeds higher-level Time and Labor views or PL/SQL logic. The "PA_ONLINE" component signals its role in supporting online (real-time) timecard entry, where a user selects or the system validates a project task against the project configuration. The view itself does not perform joins beyond the selection list defined in its view text; it is a straightforward projection over the PA_TASKS synonym.

Because the Time and Labor Engine must determine whether a task may be charged and/or billed before accepting timecard lines, views of this type provide a stable, product-owned interface that shields Time and Labor code from direct dependence on the underlying Oracle Projects base tables. This separation is significant during upgrades and patching, since Oracle Projects internals can change while the Time and Labor-facing view contract remains fixed.

Underlying Base Objects

The documented view text shows that HXC_BASE_PA_ONLINE_TASKS_V selects exclusively from PA_TASKS, referenced through a synonym in the APPS schema. The ETRM metadata for version 12.2.2 further lists the following referenced base objects:

• PA_TASKS (SYNONYM) — the primary source of task rows, providing task identifiers, names, numbers, and billing/chargeability indicators.
• PA_PROJECTS_ALL (SYNONYM) — the project definition table; typically the parent of tasks and the source of project-level attributes.
• PA_ALTERNATE_TASKS (SYNONYM) — alternate task numbering/name assignments used in some project configurations.
• PA_RBS_ELEMENTS (SYNONYM) — resource breakdown structure elements, which can relate tasks to resource classifications.

While the documented view text for this specific object projects only from PA_TASKS, the broader referenced-object list reflects the Oracle Projects dependency set that the Time and Labor task validation layer draws upon. In practice, other Time and Labor views in the same family join these objects to resolve project, task, and resource context.

Key Columns

The view exposes eight columns, each corresponding to a column on PA_TASKS:

• TASK_ID — the unique system identifier for the task; the primary key used in foreign-key relationships.
• TASK_NUMBER — the user-visible task number within the project.
• TASK_NAME — the descriptive name of the task.
• PROJECT_ID — the identifier of the owning project, linking the task to PA_PROJECTS_ALL.
• BILLABLE_FLAG — indicates whether time charged to the task is billable to the customer. This is the column most directly relevant to searches for "billable_flag," and it is a common filter in timecard and billing reporting.
• CHARGEABLE_FLAG — indicates whether the task accepts chargeable (costed) time. Tasks may be billable, chargeable, both, or neither, and Time and Labor uses this flag to reject invalid timecard entries.
• START_DATE — the date from which the task is effective.
• COMPLETION_DATE — the date on which the task is completed or closed.

Common Use Cases and Queries

The view is typically used to drive task list-of-values, validate entered task numbers against project dates, and report on billable versus chargeable task configuration. Typical queries include:

• List billable tasks for a project: SELECT task_number, task_name FROM hxc_base_pa_online_tasks_v WHERE project_id = :p_project_id AND billable_flag = 'Y';
• List chargeable, open tasks: SELECT task_number, task_name FROM hxc_base_pa_online_tasks_v WHERE chargeable_flag = 'Y' AND (completion_date IS NULL OR completion_date > SYSDATE);
• Audit billable/chargeable combinations: SELECT billable_flag, chargeable_flag, COUNT(*) FROM hxc_base_pa_online_tasks_v GROUP BY billable_flag, chargeable_flag;

These queries support timecard entry validation, project billing analysis, and configuration review, and they illustrate why the BILLABLE_FLAG column is a frequent search target for this object.