How To Fix FINS_ML_DB006 - Uncompacted extract records for &1 prevent archiving

FINS_ML_DB006 - Overview

• Message type: E = Error

• Message class: FINS_ML_DB - Messages for package FINS_ML_DB

• Message number: 006

• Message text: Uncompacted extract records for &1 prevent archiving

What causes this issue?

Material ledger extract records for &V2& &V1& are not compacted for
years up to &V3&.

System Response

Extract data for &V2& &V1& are not written to archive.

How to fix this error?

First compact material ledger extract records using report
FML_ACDOCA_M_EXTRACT_PRECOMP.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FINS_ML_DB006 - Uncompacted extract records for &1 prevent archiving ?

  The SAP error message FINS_ML_DB006 indicates that there are uncompacted extract records for a specific entity (denoted by &1) that are preventing the archiving process from proceeding. This typically occurs in the context of the SAP Financials module, particularly when dealing with the Management Ledger (ML) and its data management processes.
  
  Cause:
  The error arises when there are extract records in the database that have not been compacted. In SAP, data extraction processes can create temporary records that need to be compacted (i.e., consolidated or summarized) before archiving can take place. If these records remain uncompacted, the system will not allow archiving to ensure data integrity and consistency.
  
  Solution:
  To resolve the error, you need to compact the extract records. Here are the steps you can follow:
  
  
  Identify the Uncompacted Records:
  
  Use transaction codes such as FAGL_ML_EXTRACT or FAGL_ML_COMPRESS to check for uncompacted records related to the Management Ledger.
  
  
  
  Compact the Extract Records:
  
  Execute the compaction process using