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.
  • Data Maintenance Interface
  • Data Verification
    The Data Verification UI helps you to verify the data that is loaded from the source systems to the Cloud Service’s stage and processing tables, make minor corrections/adjustment to the data, and add new data directly into the tables. This UI allows you to add one record at a time and is not recommended for high volume additions as entering data is a lengthy process.
  • Balance Reconciliation
    The Profitability and Balance Sheet Management Cloud Service's 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
  • 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.
  • Data Redaction
    PBSMCS is enhanced to enable masking of sensitive data and Personal Identification Information (PII) to adhere to Regulations and Privacy Policies.
  • Rules Framework
    The Rules Framework provides a user-friendly interface for creating, managing, and executing business rules without requiring direct SQL knowledge. It enables you to define rule logic using datasets, conditions, hierarchies, and expressions, and preview the impact before execution.
  • Data Retention
    Data Retention enables you to view policies that manage data lifecycle by archiving or deleting data based on retention criteria, and to monitor execution history. Retention policies visible on screen depends on the type of environment - Production, Non-Production - as different policies apply to them.
  • Data Foundation Integration
    This chapter is applicable if you have subscribed to Data Foundation Cloud Service (DFCS) along with Profitability and Balance Sheet Management Cloud Service (PBSMCS) and you want to bring data into PBSMCS from DFCS. Below topics are covered here: