EAGenSCDocFromDocWithFieldsMapWithoutFlush

This document was generated using Claude.ai

Overview

Generates supply chain documents from other documents using configurable field mapping and line filtering, but without automatic database flushing during the process. This is identical to EAGenSCDocFromDocWithFieldsMap but defers database commits until the end for better performance with large datasets.

When This Action Runs

Manual execution to generate related documents from source documents when database performance is critical, typically for bulk document generation operations where multiple documents are created in sequence.

How It Works

  1. Executes finder SQL - Finds or create target document using SQL query
  2. Applies field mapping - Copies header fields from source to target using mapping rules
  3. Filters lines - Selects which lines to copy based on criteria or SQL queries
  4. Groups lines - Optionally groups lines by specified fields creating multiple documents
  5. Copies document lines - Transfers filtered lines with field transformations
  6. Handles workflow - Manages approval processes and draft status
  7. Inverse mapping - Copies fields back from generated document to source
  8. Cleanup - Deletes empty documents or orphaned records
  9. Deferred flush - Commits all changes at the end instead of during processing

Parameters

Parameter 1: Target Type (Required) - Entity type of document to generate

Parameter 2: Finder SQL (Required) - SQL to find/create target document

select id from SalesOrder where ref5Id={id}

Parameter 3: Field Map (Required) - Mapping between source and target fields

code=code
fromDoc=$this
ref5=$this

Parameter 4: After Copy Lines Map (Optional) - Additional field mapping after line copying

Parameter 5: Inverse Copy (Optional) - Copy fields from generated back to source

ref5=$this
description5=n1

Parameter 6: Handle Approval (Optional) - true/false to manage approval workflow

Parameter 7: Save as Draft (Optional) - true/false to save as draft

Parameter 8: Conditional Execution (Optional) - Only run if condition returns non-zero

select case when {details.item.item.code} in ('a','b','c') then 1 else 0 end

Parameter 9: Line Criteria Filter (Optional) - Criteria definition code for line filtering

Parameter 10: Line Query Filter (Optional) - SQL query for line filtering

select case when {details.item.item.code} in ('a','b','c') then 1 else 0 end

Parameter 11: Group Lines By (Optional) - Field(s) to group lines creating multiple documents

Parameter 12: Cleanup Query (Optional) - SQL to identify documents for deletion when grouping

Database Tables Affected

  • Target Document Tables - Creates or updates generated documents
  • Source Document Tables - Reads data for mapping (read-only)
  • Document Line Tables - Copies and transforms line items

Important Warnings

⚠️ No Auto-Flush Behavior

  • Database changes are not committed until the end of processing
  • Better performance for bulk operations but higher memory usage
  • Failed operations may leave partial data in memory
  • Use when processing multiple documents sequentially

⚠️ Memory Usage Considerations

  • Keeps all changes in memory until final commit
  • Large document generation may consume significant memory
  • Monitor system resources during bulk operations
  • Consider breaking large batches into smaller chunks

⚠️ Transaction Rollback Risk

  • All changes roll back if any part of the operation fails
  • More vulnerable to timeout issues with large datasets
  • Errors late in processing lose all work done
  • Test thoroughly with representative data volumes

⚠️ SQL Query Validation

  • Finder SQL must return valid document IDs or be empty for new documents
  • Line filter queries affect which lines are copied
  • Invalid SQL causes generation failures

⚠️ Field Mapping Syntax

  • Field mappings must use exact field paths
  • Use $this to reference current document
  • Invalid mappings cause silent failures or errors

⚠️ Performance vs Reliability Trade-off

  • Better performance but less fault tolerance than auto-flush version
  • Choose based on operation size and reliability requirements
  • Use EAGenSCDocFromDocWithFieldsMap for small operations requiring immediate commits

Module: supplychain

Full Class Name: com.namasoft.modules.supplychain.domain.utils.plugnplay.EAGenSCDocFromDocWithFieldsMapWithoutFlush

Parent Class: EAGenSCDocFromDocWithFieldsMap

Related Actions: