Journal Referential Integrity

To prevent a referential integrity problem with journals from occurring in the application, Financial Consolidation and Close verifies and prevents the deletion of any metadata member that is referenced in a journal.

The system verifies member deletion from these dimensions for referential integrity:

  • Scenario

  • Account

  • Entity

  • Period

  • Year

  • View

  • Custom

  • When you delete a dimension member from the application (using either the Simplified or Classic Dimension Editor), the system displays a confirmation message asking you to confirm that you want to delete the member.

  • If the member is referenced in a journal, the system displays the following error message and the member is not deleted.

    Failed to delete member XXX because member is referred to in Journal(s) XXX.