If the scheduler configuration directory contains duplicate orders (e.g. one of live subfolders have a copy) the execution of the aggregation step ends with the error (Oracle message sample):
Fatal Error:process: java.lang.Exception: updateReportingFromInventory: java.lang.Exception: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
The duplicate orders must be handled correctly by the aggregation step
Skip the step aggregation in the job chain sos/reporting/Reporting. The data will no longer be aggreated but will be available for some reports that do not use of the aggreated data.