Purge Non-Critical Data

Follow

Comments

11 comments

  • Rebecca Ralls

    Will zero balance budget cubes be purged in this process, too?  Because i have some zero balance budget cubes that had a balance, but now do not, and they are not going away. Can i delete them manually?

    0
    Comment actions Permalink
  • Ryan Faulkingham

    Hi Rebecca,

    If you go to the financial cubes tab, then you will be able to delete these. 

    0
    Comment actions Permalink
  • Rebecca Ralls

    Different question - Does the purge function remove current year or retained earnings cube types?

    I have a client that is trying to delete an old Accounting variable.  They went back to the beginning of time and changed the 2 journal entry lines that hit the GLAV. closed the periods - all the cubes were set to zero opening balance and zero current month activity.  but the current year earnings and the retained earnings cubes remain after the purge - in fact they were newly created when they closed up all the periods. 

    Any way of getting rid of them?  They won't let me delete them manually.

    0
    Comment actions Permalink
  • Pedro Morales

    Is anyone experiencing issues when attempting to purge Financial Report Results?  The Apex batch job fails with the following error.  I have a client that has accumulated a significant amount of data that needs to be deleted.  Is manual deletion of the child data the only option here? 

    First error: Delete failed. First exception on row 0 with id a2T0e00000144vTEAQ; first error: DELETE_OPERATION_TOO_LARGE, Cascade deleting too many records: occurring when cascading to Financial Statement Result Value records: []

     

    0
    Comment actions Permalink
  • Tony

    Pedro,

    Please log a ticket if this issue persists. You can also navigate to the Financial Report results tab and purge the data records directly from here.

    Thanks,

    Tony

    0
    Comment actions Permalink
  • Pedro Morales

    Thanks, Tony.  I manually deleted them with data loader using small batch sizes to avoid the DELETE_OPERATION_TOO_LARGE error.

    0
    Comment actions Permalink
  • Jeanae Remala

    I have had varying results.  Sometimes I've been able to delete as many as 50 results at a time without getting the error message, but most times the max is 10-20.

    0
    Comment actions Permalink
  • Ryan Faulkingham

    Hi Jeanae,

    We are working on improving this functionality in our Echinacea release. 

    Thank you,

    Ryan

    0
    Comment actions Permalink
  • Jackie Southon

    Is there a way to delete a specific Financial Report Result generated, rather than purge all financial reports via Accounting Settings?

    0
    Comment actions Permalink
  • Bao Do

    Hi Jackie,

    Yes you can delete a specific FRR file by showing All Tabs and then selecting Financial Statement Results.  From there you can select specific FRR files to delete.

    Thank you,
    Bao

    0
    Comment actions Permalink
  • Jackie Southon

    Great, thank you!

    0
    Comment actions Permalink

Article is closed for comments.