Skip to main content

Create and Manage Public View Objects (PVOs)

To create Public View Objects (PVOs), sign in to Angles Hub and perform the following:

  2. Select Connection Manager. The Connections page is displayed.
  3. Select the dropdown icon next to the Oracle Cloud Applications (OCA) connection for which you want to add a PVO, and select Manage PVOs. The Manage PVOs page is displayed.

  4. Select Actions and select one of the following options:

    1. Add PVO: To add a single PVO, select Add PVO, provide the following details, and select Extract Metadata.

      1. Data Store Name: Enter the name of the subject area or analytics module as it appears in your Oracle Cloud Applications (OCA) environment. For example, Oracle Financial Analytics or Business Analytics.

      2. Table Name: Enter the name of the specific table within the data store that you want to extract and replicate to the target. This is the actual table name as it exists in the OCA environment. For example, Customer Account or Customer Name.

      3. Prefix: Enter an optional prefix to be added to the table name in the target database. This Manage PVOs is useful to differentiate or categorize tables when they are replicated to the target schema. For example, AP (Accounts Payable) or GL (General Ledger).

      4. Offerings: Select the specific subset or product within the selected module from which you want to extract PVOs.

      5. Modules: Select the functional area or category within Oracle Cloud Applications from which you want to extract PVOs.

      6. Schema: Select the schema where the data needs to be stored.

      Clicking Extract Metadata retrieves the PVO metadata from BICC (Business Intelligence Cloud Connector) and stores it in the Hub. The PVO details are persisted in the PublicViewObject table and column metadata in the PublicViewColumn table of the OCA Data Management service.

    2. Add Bulk PVO: To add multiple PVOs at once, select Add Bulk PVO, provide the following details and select Extract Metadata.

      1. Offering: Select the specific subset or product within the selected module from which you want to extract PVOs.

      2. Ship Content: When Ship Content is selected, the shipped (default) PVO metadata without any customizations is extracted from BICC for all PVOs in the selected offering. When unchecked, the customized PVO metadata—including custom columns, modified primary keys, and other BICC-level customizations—is extracted for all PVOs in the selected offering.

    3. Bulk Upload: To bulk upload the customized PVOs, select the required PVO configurations from the list, then click the Actions dropdown menu and select Bulk Upload to export and sync them to BICC in one operation. This operation uploads customized PVO metadata for multiple PVOs from Angles Hub to BICC.

    4. Bulk Refesh: To bulk refresh the PVOs, select the required PVO configurations from the list, then click the Actions dropdown menu and select Bulk Refresh to reload and update them from the source data model in one operation.

      This operation retrieves the shipped PVO metadata from BICC for multiple PVOs and updates the corresponding metadata in Angles Hub.

Modify PVOs

To create Public View Objects (PVOs), sign in to Angles Hub and perform the following:

  2. Select Connection Manager. The Connections page is displayed.
  3. Select the dropdown icon next to the OCA connection for which you want to add a PVO, and select Manage PVOs. The Manage PVOs page is displayed.
  4. Under Actions, select the edit icon of the PVO you want to edit. A page with the following options is displayed:
    1. Overview: Make the required changes and select Save.

      • Table Name: Indicates the name of the PVO being configured.

      • Schema: Indicates which database schema contains the PVO.

      • DataStoreName: Indicates the complete path/location of the PVO in the data model.

      • Description: Indicates what the PVO is used for (documentation/purpose).

      • Prefix: Indicates an optional prefix to be added to PVO field names.

      • IsEffectiveDateDisabled: Indicates whether date-based versioning of PVO records is turned on or off.

      • PVOType: Indicates the type of PVO, such as Standard, Custom, or Extended.

      • Modules: Indicates which functional modules, such as XLA, GL, or AP, this PVO applies to.

      • Offerings: Indicates which product offering, such as FIN, HCM, or SCM, this PVO belongs to.

      • Grouping: Indicates which ledger level, such as XL1 or XL2, this PVO is grouped under.

      • Customization Type: Indicates whether the PVO has custom modifications applied, such as None, Custom, or Extended.

      Click the Upload button to export the customized PVO configurations to OCA.

    2. Columns: Use the Columns tab to view and manage the fields in the PVO. The tab displays a list of all columns with their name, description, and data type. For each column, you can designate its role in the PVO.

      Select Primary Key to mark a column as a primary key, or select Exclude Column to prevent a column from being processed during PVO operations.

      Click Save after making the required changes.

      Click the Upload button to export the customized PVO configurations to OCA.

Edit, Upload, Refresh, and Delete PVOs

To edit, upload, refresh, and delete a PVO, sign in to Angles Hub and perform the following:

  1. Select Connection Manager. The Connections page is displayed.

  2. Select the dropdown icon next to the Oracle Cloud Applications (OCA) connection for which you want to manage a PVO, and select Manage PVOs. The Manage PVOs page is displayed.

  3. To edit a PVO, select the required PVO and select the Edit icon in the Actions column.

  4. To upload a customized PVO to OCA, select the required PVO from the list and select the Upload icon in the Actions column. This uploads the customized PVO metadata from Angles Hub to BICC and updates the corresponding PVO definition in Oracle Cloud. For example, if a PVO initially contains 50 columns with 1 primary key, and you customize it in Angles Hub by excluding 10 columns and modifying the primary key configuration, clicking Upload will push these customizations to BICC, ensuring the PVO metadata in Oracle Cloud remains synchronized with your changes in Angles Hub.

  5. To refresh a PVO and reflect the latest changes from the source data model, select the required PVO and select the Refresh icon in the Actions column. Clicking Refresh icon retrieves the shipped PVO metadata from BICC and updates the corresponding PVO metadata in Angles Hub, replacing any previous customizations with the default definition. This is useful when you need to restore a PVO to its original state.

  6. To remove a PVO from Angles Hub, select the required PVO and select the Delete icon in the Actions column.

Was this article helpful?

We're sorry to hear that.