Create Customer Statements – Generate Log

Hi all,

We’re on Oracle Fusion Receivables and are seeing a performance issue with Create Customer Statements for one of our business units.

What happens:

• When this BU runs Create Customer Statements for its full customer set, the child job Create Customer Statements: Generate Log (StatementGenerationReport, seeded report /Financials/Receivables/Receivables Balances/StatementGeneration.xdo) runs for 3–5 hours, and often ends in Error or Warning.
• While it runs, Create Customer Statements jobs submitted by other BUs stay in Wait status until it finishes. Some waited over 8 hours. Once they start, they complete in 1–2 minutes.
• When the same BU splits the run into smaller batches, each batch completes in 1–2 minutes.