Search Results oe_retrobill_requests




Overview
Explore in AI Chat

Overview

The OE_RETROBILL_REQUESTS table is a core configuration and control object within the Oracle Order Management (ONT) product of Oracle E-Business Suite. It stores the definitions of retro-bill requests, which are used to apply price, promotion, or agreement adjustments to orders that have already been booked or invoiced. In Oracle EBS, retro-billing enables organizations to capture backdated pricing changes — for example when a customer-specific agreement, freight term, or discount is negotiated after the original order was entered — and to propagate those changes through the order and billing lifecycle. The table therefore acts as the master record of "what retro-bill action should be performed, against which items and customers, and when."

Because the table stores request definitions that are executed and referenced by downstream processes, and which are scoped by attributes such as order type, inventory item, and sold-to organization, the metadata classifies it heuristically as a standalone object within a Data Vault model. In practice this suggests modeling the table as its own hub-like entity keyed by RETROBILL_REQUEST_ID, with descriptive attributes (name, description, execution mode, dates, flags) carried as satellites, and the ORDER_TYPE_ID foreign key represented as a link to the order type reference data. This classification reflects that the table is neither a pure transaction link nor a dependent child of a larger parent, but a self-contained definition object.

Key Information Stored

The table contains 34 documented columns. The most significant are:

The fifteen ATTRIBUTE1–ATTRIBUTE15 columns provide the usual flexible descriptive-flexfield extension capability for customer-specific data.

Common Use Cases and Queries

The table is most commonly queried to inspect which retro-bill requests are defined, to audit their execution status, and to join them to order types, items, and customers for reporting. A typical lookup resolves the order type name and the request definition:

  • List active requests with their order type:
    SELECT r.retrobill_request_id, r.name, r.execution_mode, t.name order_type
    FROM ont.oe_retrobill_requests r, ont.so_order_types_115_all t
    WHERE r.order_type_id = t.order_type_id;
  • Find item-specific requests for a given organization:
    SELECT * FROM ont.oe_retrobill_requests WHERE inventory_item_id = :item AND sold_to_org_id = :cust;
  • Audit requests by concurrent program / last run:
    SELECT name, execution_date, program_id, program_updated_date
    FROM ont.oe_retrobill_requests WHERE program_updated_date > SYSDATE - 30;

These queries support pricing reconciliation, promotion auditing, and troubleshooting of retro-billing schedules.

Related Objects