Flexible Aggregate Reporting - Database Objects

Installing the Oracle Argus Safety database prompts for the creation of the BIP Owner schema. This schema contains all database objects needed for Oracle Analytics Publisher Flexible Reporting. It also has access to some Oracle Argus Safety schema objects through synonyms.

Note:

You cannot update case data from the BIP Publisher Owner schema. You can only update the Periodic Report status related tables such as CMN_REG_REPORTS, PER_REPORT_QUEUE and PER_REPORT_STS. The system updates the CASE_REG_REPORTS table for final reports. The system accesses the report blob tables from the BIP Owner to store the report output in Oracle Argus Safety.

The schema name is configurable at the time of creation. The system makes an entry in the Common Profile switches to store this schema name for reference by Oracle Argus Mart.

For report generation, this schema holds:

• Tables
• Views
• The unzip utility function
• A Java object
• Packages
• Database links
• Database jobs