Results for “bic_fctv_sr_response”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BIC_FCTV_SR_RESPONSE is a read-only reporting view belonging to the BIC – Customer Intelligence product family within Oracle E-Business Suite. In the ETRM 12.2.2 metadata the object is explicitly flagged as obsolete, and the excerpt notes "Not implemented in this database." This indicates that the view was shipped as part of the Customer Intelligence (BIC) analytics schema yet is no longer created or supported in current installations. Its purpose was to present a flattened, denormalized fact set describing service request (SR) response activity, joining incident header data to the specific incident action that represents the first or recorded response. The name derives from the fact-table nomenclature BIC_FCTV (BIC Fact View) combined with SR_RESPONSE, signalling that it fed a dimensional model where incidents were measured against time and customer dimensions. This places the view firmly in the analytical reporting layer rather than the transactional foundation, and it would have been consumed by Customer Intelligence dashboards, service-response KPIs, and time-period trend reports. Users searching for the underlying table cs_incident_actions would arrive at this view because the join to CS_INCIDENT_ACTIONS is what supplies the RESPONSE_DATE column.
Underlying Base Objects
The ETRM metadata records no separately documented base objects, but the embedded view text reveals the full FROM clause. The view is defined over eight objects:
- CS_INCIDENTS_ALL_B — the incident/service request header (alias INC).
- CS_INCIDENT_ACTIONS — the action history providing the response event (alias CSA); this is the object referenced by the search term
cs_incident_actions. - CS_INCIDENT_STATUSES (STAT), CS_INCIDENT_SEVERITIES (ISEV), and CS_INCIDENT_TYPES (ITYP) — the lookup/validation tables supplying status, severity, and type attributes.
- BIC_DIMV_CUSTOMERS (DC) — the customer dimension view.
- BIC_DIMV_TIME (DT) — the time dimension view mapping action creation dates to accounting periods, quarters, halves, and years.
- JTF_RS_RESOURCE_EXTNS (PF) — the resource extension table joined with an outer join (
(+)) on INCIDENT_OWNER_ID to resolve the owner and active start date.
The critical join is INC.INCIDENT_ID = CSA.INCIDENT_ID, which ties every incident to its action rows, with CSA.CREATION_DATE BETWEEN DT.ACT_PERIOD_START_DATE AND DT.ACT_PERIOD_END_DATE collapsing the response into a time period. Because the action table can hold many rows per incident, the view is effectively at incident-action grain, and consumers must aggregate to obtain a single response per SR.
Key Columns
The column list mixes foreign keys, degenerate dimensions, and descriptive attributes:
- INCIDENT_ID — the SR primary key, the natural grain of the fact.
- INCIDENT_OWNER_FK, INCIDENT_STATUS_FK, INCIDENT_SEVERITY_FK, INCIDENT_TYPE_FK — surrogate keys linking to owner, status, severity, and type dimensions.
- INCIDENT_DATE, CLOSE_DATE, RESPONSE_DATE — the event timestamps; RESPONSE_DATE is sourced from
CS_INCIDENT_ACTIONS.CREATION_DATEand enables response-time calculations. - CLOSE_FLAG — from CS_INCIDENT_STATUSES, allowing open/closed partitioning.
- LAST_NAME, FIRST_NAME, EMPLOYEE_NAME, EMPLOYEE_START_DATE — owner attributes from the resource extension, deliberately projected as NULL in the view text, with the real owner start date carried by EMPLOYEE_START_DATE.
- INCIDENT_SEVERITY, SEVERITY_DESC, INCIDENT_TYPE, INC_TYPE_DESC — denormalized descriptive labels for drill-down reporting.
- PARTY_ID, COUNTRY, CITY, STATE, CUSTOMER_CATEGORY_FK, MARKET_SEGMENT_FK — customer dimension attributes from BIC_DIMV_CUSTOMERS.
- ORG_ID — the multi-org operating unit identifier.
- ACT_PERIOD_NAME, START_DATE, ACT_PERIOD_START_DATE, ACT_PERIOD_END_DATE, ACT_YEAR, ACT_PERIOD_NUM, ACT_QUARTER, ACT_HALF_YEAR — the time-dimension rollups used for period-based trending.
Common Use Cases and Queries
The view supported measuring how quickly service requests received an action, segmented by severity, type, customer, and period. A representative query, adapted to the documented column set, counts responses per accounting period:
- Response volume by period:
SELECT ACT_PERIOD_NAME, COUNT(DISTINCT INCIDENT_ID) responses FROM BIC_FCTV_SR_RESPONSE GROUP BY ACT_PERIOD_NAME ORDER BY ACT_PERIOD_NAME; - Responses by severity and type:
SELECT INCIDENT_SEVERITY, INCIDENT_TYPE, COUNT(*) FROM BIC_FCTV_SR_RESPONSE GROUP BY INCIDENT_SEVERITY, INCIDENT_TYPE; - Response lag:
SELECT INCIDENT_ID, RESPONSE_DATE - INCIDENT_DATE days_to_respond FROM BIC_FCTV_SR_RESPONSE; - Open versus closed mix:
SELECT CLOSE_FLAG, COUNT(*) FROM BIC_FCTV_SR_RESPONSE GROUP BY CLOSE_FLAG;
Because the object is obsolete and not implemented, equivalent analysis in EBS 12.1.1 and 12.2.2 must be built directly against CS_INCIDENTS_ALL_B and CS_INCIDENT_ACTIONS, joining BIC or custom dimensions as required.
-
View: BIC_FCTV_SR_RESPONSE 12.1.1
Not implemented in this database·Explore BIC module →
-
View: BIC_FCTV_SR_RESPONSE 12.2.2
Not implemented in this database·Explore BIC module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2