Scheduled generation of a CINS file in XML format every hour, may cause any performance issues?
Our current integration requirement involves generating a CINS file in XML format every hour. Each file is expected to contain approximately 40,000 records. This file will be transmitted to an external system through a REST API endpoint.
We would like Oracle Support to confirm if this frequency and data volume could potentially impact the performance or stability of the environment (especially Oracle WMS Cloud or Oracle Integration Cloud, depending on the scope). We are particularly concerned about:
Processing load on the application during file generation
Resource utilization during REST transmission
Potential bottlenecks or delays in concurrent system processes
Recommended best practices or configurations for handling large XML payloads via REST on a scheduled basis