Search Results eam_work_order_bills




Overview
Explore in AI Chat

Overview

EAM.EAM_WORK_ORDER_BILLS is the Enterprise Asset Management table that stores work order billing information in Oracle E-Business Suite 12.1.1 and 12.2.2. It records how completed or in-progress maintenance work orders are priced and invoiced to customers, capturing the commercial dimensions of an EAM work order alongside the cost and labor detail held elsewhere in the EAM and Work in Process schemas. Each row represents a billing line tied to a work order, an operation, and a billable item, enabling organizations that perform maintenance as a chargeable service to generate receivables from their asset management activity.

From a dimensional modeling perspective, the mined foreign-key structure suggests this table behaves as a satellite-leaning entity: it hangs off core transactional hubs such as WIP_EAM_WORK_REQUESTS and reference entities such as MTL_SYSTEM_ITEMS_B and CST_COST_TYPES, carrying descriptive billing attributes rather than acting as an independent hub or a pure many-to-many link. This classification is a heuristic modeling suggestion, not a declared Oracle construct.

Key Information Stored

The table contains 39 documented columns. The most operationally significant are:

Audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) follow standard EBS conventions. No surrogate primary key is documented in the supplied metadata; the unique business key is most likely the composite of ORGANIZATION_ID, WIP_ENTITY_ID, OPERATION_SEQ_NUM, and BILLED_INVENTORY_ITEM_ID.

Common Use Cases and Queries

Typical reporting includes billable work order value by customer, cost-versus-list-price analysis, and reconciliation of EAM billing lines to receivable invoices.

  • Summarizing charges: SELECT  CUSTOMER_ID, SUM(BILLED_AMOUNT) FROM EAM_WORK_ORDER_BILLS GROUP BY CUSTOMER_ID;
  • Joining to work requests to attribute billing: SELECT b.WIP_ENTITY_ID, b.BILLED_AMOUNT, r.* FROM EAM_WORK_ORDER_BILLS b, WIP_EAM_WORK_REQUESTS r WHERE b.WORK_REQUEST_ID = r.WORK_REQUEST_ID;
  • Verifying billing basis: filter on BILLING_BASIS and COST_OR_LISTPRICE to explain variances between modeled cost and invoiced amount.
  • Multicurrency analysis using CURRENCY_CODE and CONVERSION_RATE for translated reporting.

Related Objects

  • WIP_EAM_WORK_REQUESTS — joined via WORK_REQUEST_ID; the parent work request driving the maintenance activity.
  • MTL_SYSTEM_ITEMS_B — joined via BILLED_INVENTORY_ITEM_ID and ORGANIZATION_ID; source of billable item definitions.
  • CST_COST_TYPES — joined via COST_TYPE_ID; defines the cost basis used in pricing.
  • WIP entities (e.g., WIP_DISCRETE_JOBS / WIP_ENTITIES) — keyed by WIP_ENTITY_ID for operation context.
  • Receivables (AR) invoice tables — referenced through INVOICE_TRX_NUMBER and INVOICE_LINE_NUMBER.
  • Project Accounting objects (PA events, projects, tasks) — linked via PROJECT_ID, TASK_ID, and PA_EVENT_ID.
  • FND / audit views — standard EBS audit joins on LAST_UPDATED_BY and LAST_UPDATE_DATE.