How to Undo Management Ledger Allocations Using FISCAL_MONTH and FISCAL_YEAR for Performance Improvement (Doc ID 2734534.1)

Last updated on MAY 08, 2023

Applies to:

Goal

You experience slow performance when running an Undo of Management Ledger Allocations against millions of records.  Your partitioning of FSI_D_MANAGEMENT_LEDGER uses FISCAL_MONTH and FISCAL_YEAR.  However, the Undo 'delete' statement is using AS_OF_DATE in the "where" clause.  Is there a way to get the Undo process to use FISCAL_MONTH and FISCAL_YEAR instead of AS_OF_DATE?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.