Scheduled report to create package stopped working after upgrade from 7.5 to 9.12
We have a report that runs daily that creates & submits a package. After we upgraded to 9.12 it stopped working. Its creating the package, but it never submits. Its stays in status 'NEW'. In the Report Type, we have a command called 'run_dlv_interface' that runs the attached sql. I believe this creates the package line but not 100% sure. Then we run scripts/kdlv_package_interface.sql. Anyone know how to fix this? I'm guessing the status_code is not being updated?