Results for “bim_fctv_orders”

4 results




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

Overview

BIM_FCTV_ORDERS is a reporting view belonging to the BIM (Marketing Intelligence) product family, a legacy Oracle E-Business Suite module now classified as obsolete. The view is documented as being "used by the concurrent programs to load the summary tables," which establishes its role as an intermediate extraction layer within the BIM marketing analytics pipeline rather than as an operational or transactional object. In EBS 12.1.1 and 12.2.2, the view is not implemented in the database by default; ETRM explicitly records "Not implemented in this database," meaning it must be created by the BIM installation or patching process before any dependent concurrent program can execute successfully.

The view flattens order header data from the order capture schema into a denormalized fact structure suitable for loading marketing summary tables. It enriches each qualifying order with geography, campaign source, and market segment attributes, positioning it conceptually between operational order data and the BIM fact tables.

Underlying Base Objects

The ETRM metadata lists no documented base objects, but the embedded view text reveals the operative dependencies:

Key Columns

Common Use Cases and Queries

The view is consumed primarily by BIM concurrent programs loading summary tables, and secondarily by ad hoc marketing analytics that require booked, non-cancelled, non-return orders with attribution dimensions. The defining filters are ORDER_CATEGORY_CODE <> 'RETURN', BOOKED_FLAG = 'Y', and NVL(CANCELLED_FLAG,'N') = 'N'.

A typical query isolating exchange rate type is:

  • SELECT header_id, order_number, transaction_currency, exchange_rate, exchange_type_code FROM bim_fctv_orders WHERE exchange_type_code IS NOT NULL AND ordered_date >= :p_start_date AND ordered_date < :p_end_date ORDER BY ordered_date;
  • SELECT exchange_type_code, transaction_currency, COUNT(*) order_count, SUM(exchange_rate) rate_sum FROM bim_fctv_orders GROUP BY exchange_type_code, transaction_currency;

Because of the outer joins and the -999 defaults, consumers should treat -999 as "unknown" rather than a valid dimension member. Administrators must also confirm the view exists in the target instance, since ETRM documents it as not implemented by default and as Oracle-proprietary, confidential material.