1. Profitability Analytics Cloud Service User Guide
  2. Data Management Tools

5 Data Management Tools

This chapter introduces the Balance Reconciliation and Data Verification topics.

Data Management Topics:

  • Data Maintenance Interface: Data Maintenance Interface (DMI) helps to design a Data Form in a user-specified format. Further, it allows to perform maintenance activities using the Designed Form.
  • Balance Reconciliation: Balance Reconciliation module helps you to Reconcile the selected processing/instrument/account balances against the Management Ledger. If any differences are found, you will have the flexibility to choose significant differences and create plug entries for those in the Ledger_Instruments table.
  • Data Housekeeping: The Data Housekeeping UI helps you to delete data, drop partitions and truncate sub-partitions, and archive the data from selected tables.
  • Data Level Security: This topic describes how the data administrators can restrict access to the users to instrument and management ledger tables based on specific dimensions.
  • Redaction Framework: Oracle Data Redaction provides selective, on-the-fly redaction of sensitive data in database query results prior to display by applications.