Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP Cloud

Summary:

Hi Team,

We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the daily delivery of this report to the Business, ensuring checks surpassing the 180-day threshold are flagged. We're considering an incremental run approach, using the report job's run date, but are open to alternative suggestions. Additionally, we want to avoid resending letters if they were already sent in a previous run. We're particularly interested in SaaS-based solutions or options for OIC-based orchestration.

Thanks,

Abhilash

Content (please ensure you mask any confidential information):

Stale Dated Checks (outdated checks)