Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - BIX Tables and Views

TABLE - BIX.BIX_INTERACTIONS
TABLE - BIX.BIX_INTERACTIONS_INF
TABLE - BIX.BIX_SERVER_CP
TABLE - BIX.BIX_SERVER_IB
TABLE - BIX.BIX_SERVER_MCM
TABLE - BIX.BIX_SERVER_SUM_CP
TABLE - BIX.BIX_SERVER_SUM_IB
TABLE - BIX.BIX_SUM_AGENT
TABLE - BIX.BIX_SUM_AGT_CLS
TABLE - BIX.BIX_SUM_AGT_PRD
TABLE - BIX.BIX_SUM_GRP_CLS
TABLE - BIX.BIX_SUM_GRP_CLS_INQ
TABLE - BIX.BIX_SUM_GRP_CLS_TRN
TABLE - BIX.BIX_SUM_GRP_PRD_OUT
TABLE - BIX.BIX_SUM_INFO
TABLE - BIX.BIX_SUM_INFO_CONFIG
TABLE - BIX.BIX_TIME
VIEW - APPS.BIX_AGENT_V
VIEW - APPS.BIX_AK_DUMMY_V
VIEW - APPS.BIX_CALL_CENTER_V
VIEW - APPS.BIX_CENTER_V
VIEW - APPS.BIX_GROUP_V
VIEW - APPS.BIX_INT_CLASSIFICATIONS_V
VIEW - APPS.BIX_RESOURCE_BASE_V
VIEW - APPS.BIX_RESOURCE_LOV_V
VIEW - APPS.BIX_TOTAL_CALL_AGENT_V

Table: BIX_INTERACTIONS

Description: Repository for all interaction data that we get from UWQ (Oracle Universal Work Queue)
Primary Key: BIX_INTERACTIONS_PK
  1. INTERACTIONS_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIX_INTERACTIONS_INF.INTERACTIONS_ID BIX_INTERACTIONS

[top of page]

BIX.BIX_INTERACTIONS does not reference any database object

BIX.BIX_INTERACTIONS is referenced by following:

APPS
SYNONYM - BIX_INTERACTIONS

[top of page]

Table: BIX_INTERACTIONS_INF

Description: Contains Sales data broken up by Product Group and Resource Group
Primary Key: BIX_INTERACTIONS_INF_PK
  1. INTERACTIONS_INF_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIX_INTERACTIONS_INF.INTERACTIONS_ID BIX_INTERACTIONS

[top of page]

BIX.BIX_INTERACTIONS_INF does not reference any database object

BIX.BIX_INTERACTIONS_INF is referenced by following:

APPS
SYNONYM - BIX_INTERACTIONS_INF

[top of page]

Table: BIX_SERVER_CP

Description: Derived from "Advanced Outbound CCI Data"
Primary Key: BIX_SERVER_CP_PK
  1. SERVER_CP_ID

[top of page]

BIX.BIX_SERVER_CP does not reference any database object

BIX.BIX_SERVER_CP is referenced by following:

APPS
SYNONYM - BIX_SERVER_CP

[top of page]

Table: BIX_SERVER_IB

Description: Derived from "Interaction Blending CCI Data"
Primary Key: BIX_SERVER_IB_PK
  1. SERVER_IB_ID

[top of page]

BIX.BIX_SERVER_IB does not reference any database object

BIX.BIX_SERVER_IB is referenced by following:

APPS
SYNONYM - BIX_SERVER_IB

[top of page]

Table: BIX_SERVER_MCM

Description: Records data from the MCM, grouped by interaction classification
Primary Key: BIX_SERVER_MCM_PK
  1. SERVER_MCM_ID

[top of page]

BIX.BIX_SERVER_MCM does not reference any database object

BIX.BIX_SERVER_MCM is referenced by following:

APPS
SYNONYM - BIX_SERVER_MCM

[top of page]

Table: BIX_SERVER_SUM_CP

Description: BIX_SERVER_CP data summarized to the day
Primary Key: BIX_SERVER_SUM_CP_PK
  1. SERVER_SUM_CP_ID

[top of page]

BIX.BIX_SERVER_SUM_CP does not reference any database object

BIX.BIX_SERVER_SUM_CP is referenced by following:

APPS
SYNONYM - BIX_SERVER_SUM_CP

[top of page]

Table: BIX_SERVER_SUM_IB

Description: BIX_SERVER_IB data summarized to the day
Primary Key: BIX_SERVER_SUM_IB_PK
  1. SERVER_SUM_IB_ID

[top of page]

BIX.BIX_SERVER_SUM_IB does not reference any database object

BIX.BIX_SERVER_SUM_IB is referenced by following:

APPS
SYNONYM - BIX_SERVER_SUM_IB

[top of page]

Table: BIX_SUM_AGENT

Description:

[top of page]

BIX.BIX_SUM_AGENT does not reference any database object

BIX.BIX_SUM_AGENT is referenced by following:

APPS
SYNONYM - BIX_SUM_AGENT

[top of page]

Table: BIX_SUM_AGT_CLS

Description: Summarizes BIX_INTERACTIONS data to the day along the dimensions of time, agent, call center, campaign and interaction classification
Primary Key: BIX_SUM_AGT_CLS_PK
  1. SUM_AGT_CLS_ID
Primary Key: BIX_SUM_AGT_CLS_UK
  1. HOUR
  2. RESOURCE_ID
  3. CAMPAIGN_ID
  4. INTERACTION_CLASSIFICATION

[top of page]

BIX.BIX_SUM_AGT_CLS does not reference any database object

BIX.BIX_SUM_AGT_CLS is referenced by following:

APPS
SYNONYM - BIX_SUM_AGT_CLS

[top of page]

Table: BIX_SUM_AGT_PRD

Description: Summarizes BIX_INTERACTIONS to the day along the dimensions of time, agent, campaign and interaction classification
Primary Key: BIX_SUM_AGT_PRD_PK
  1. SUM_AGT_PRD_ID
Primary Key: BIX_SUM_AGT_PRD_UK
  1. HOUR
  2. RESOURCE_ID
  3. CAMPAIGN_ID
  4. INTERACTION_CLASSIFICATION

[top of page]

BIX.BIX_SUM_AGT_PRD does not reference any database object

BIX.BIX_SUM_AGT_PRD is referenced by following:

APPS
SYNONYM - BIX_SUM_AGT_PRD

[top of page]

Table: BIX_SUM_GRP_CLS

Description: Summarizes BIX_INTERACTIONS to the day the dimension of time, agent group, call center, campaign and interaction classification
Primary Key: BIX_SUM_GRP_CLS_PK
  1. SUM_GRP_CLS_ID
Primary Key: BIX_SUM_GRP_CLS_UK
  1. HOUR
  2. RESOURCE_GROUP_ID
  3. INTERACTION_CENTER_ID
  4. CAMPAIGN_ID
  5. INTERACTION_CLASSIFICATION

[top of page]

BIX.BIX_SUM_GRP_CLS does not reference any database object

BIX.BIX_SUM_GRP_CLS is referenced by following:

APPS
SYNONYM - BIX_SUM_GRP_CLS

[top of page]

Table: BIX_SUM_GRP_CLS_INQ

Description: Summarizes BIX_INTERACTIONS data to the day along the dimesions of time, agent group, call center, campaign and interaction classification
Primary Key: BIX_SUM_GRP_CLS_INQ_PK
  1. SUM_GRP_CLS_INQ_ID
Primary Key: BIX_SUM_GRP_CLS_INQ_UK
  1. HOUR
  2. RESOURCE_GROUP_ID
  3. INTERACTION_CENTER_ID
  4. CAMPAIGN_ID
  5. INTERACTION_CLASSIFICATION

[top of page]

BIX.BIX_SUM_GRP_CLS_INQ does not reference any database object

BIX.BIX_SUM_GRP_CLS_INQ is referenced by following:

APPS
SYNONYM - BIX_SUM_GRP_CLS_INQ

[top of page]

Table: BIX_SUM_GRP_CLS_TRN

Description: Summarizes BIX_INTERACTIONS data to the day along the dimensions of time, agent group, call center, campaign and interaction classification
Primary Key: BIX_SUM_GRP_CLS_TRN_PK
  1. SUM_GRP_CLS_TRN_ID
Primary Key: BIX_SUM_GRP_CLS_TRN_UK
  1. HOUR
  2. RESOURCE_GROUP_ID
  3. INTERACTION_CENTER_ID
  4. CAMPAIGN_ID
  5. INTERACTION_CLASSIFICATION

[top of page]

BIX.BIX_SUM_GRP_CLS_TRN does not reference any database object

BIX.BIX_SUM_GRP_CLS_TRN is referenced by following:

APPS
SYNONYM - BIX_SUM_GRP_CLS_TRN

[top of page]

Table: BIX_SUM_GRP_PRD_OUT

Description: Summarizes BIX_INTERACTIONS data to the day along the dimensions of time, agent, group, call center, campaign and product group
Primary Key: BIX_SUM_GRP_PRD_OUT_PK
  1. SUM_GRP_PRD_OUT_ID
Primary Key: BIX_SUM_GRP_PRD_OUT_UK
  1. HOUR
  2. RESOURCE_GROUP_ID
  3. INTERACTION_CENTER_ID
  4. CAMPAIGN_ID
  5. PRODUCT_GROUP_ID

[top of page]

BIX.BIX_SUM_GRP_PRD_OUT does not reference any database object

BIX.BIX_SUM_GRP_PRD_OUT is referenced by following:

APPS
SYNONYM - BIX_SUM_GRP_PRD_OUT

[top of page]

Table: BIX_SUM_INFO

Description: Table for 3rd party applications to send data to be summarized along a certain number of dimensions
Primary Key: BIX_SUM_INFO_PK
  1. SUM_INFO_ID

[top of page]

BIX.BIX_SUM_INFO does not reference any database object

BIX.BIX_SUM_INFO is referenced by following:

APPS
SYNONYM - BIX_SUM_INFO

[top of page]

Table: BIX_SUM_INFO_CONFIG

Description: Specifies the dimensions that a particular application will use for summarizing into BIX_SUM_INFO
Primary Key: BIX_SUM_INFO_CONFIG_PK
  1. SUM_INFO_CONFIG_ID
Primary Key: BIX_SUM_INFO_CONFIG_UK
  1. HANDLER_ID

[top of page]

BIX.BIX_SUM_INFO_CONFIG does not reference any database object

BIX.BIX_SUM_INFO_CONFIG is referenced by following:

APPS
SYNONYM - BIX_SUM_INFO_CONFIG

[top of page]

Table: BIX_TIME

Description:
Primary Key: BIX_TIME_PK
  1. HOUR

[top of page]

BIX.BIX_TIME does not reference any database object

BIX.BIX_TIME is referenced by following:

APPS
SYNONYM - BIX_TIME

[top of page]

View: BIX_AGENT_V

[top of page]

APPS.BIX_AGENT_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - JTF_RS_RESOURCE_EXTNS
VIEW - PER_PEOPLE_F

APPS.BIX_AGENT_V is not referenced by any database object

[top of page]

View: BIX_AK_DUMMY_V

[top of page]

APPS.BIX_AK_DUMMY_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.BIX_AK_DUMMY_V is not referenced by any database object

[top of page]

View: BIX_CALL_CENTER_V

[top of page]

APPS.BIX_CALL_CENTER_V references the following:

APPS
SYNONYM - IEO_SVR_GROUPS
APPS.BIX_CALL_CENTER_V is referenced by following:

APPS
PACKAGE BODY - BIX_ALERT

[top of page]

View: BIX_CENTER_V

[top of page]

APPS.BIX_CENTER_V references the following:

APPS
SYNONYM - IEO_SVR_GROUPS

APPS.BIX_CENTER_V is not referenced by any database object

[top of page]

View: BIX_GROUP_V

[top of page]

APPS.BIX_GROUP_V references the following:

APPS
VIEW - JTF_RS_GROUPS_VL

APPS.BIX_GROUP_V is not referenced by any database object

[top of page]

View: BIX_INT_CLASSIFICATIONS_V

[top of page]

APPS.BIX_INT_CLASSIFICATIONS_V references the following:

APPS
SYNONYM - CCT_CLASSIFICATIONS

APPS.BIX_INT_CLASSIFICATIONS_V is not referenced by any database object

[top of page]

View: BIX_RESOURCE_BASE_V

[top of page]

APPS.BIX_RESOURCE_BASE_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - JTF_RS_RESOURCE_EXTNS
VIEW - PER_PEOPLE_F

APPS.BIX_RESOURCE_BASE_V is not referenced by any database object

[top of page]

View: BIX_RESOURCE_LOV_V

[top of page]

APPS.BIX_RESOURCE_LOV_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - JTF_RS_RESOURCE_EXTNS
VIEW - PER_PEOPLE_F

APPS.BIX_RESOURCE_LOV_V is not referenced by any database object

[top of page]

View: BIX_TOTAL_CALL_AGENT_V

[top of page]

APPS.BIX_TOTAL_CALL_AGENT_V references the following:

APPS
VIEW - BISBV_DIMENSION_LEVELS

APPS.BIX_TOTAL_CALL_AGENT_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract