Skip Navigation
Click here for an update from Oracle on PHP remediation

Search

List of distributed emails do not appear on upgrade site as they do on production
Answer ID 8654   |   Last Review Date 12/18/2018

Why am I not seeing the list of emails in my report on the upgrade site as I do on my production site?

Environment:

Reports that query the mailing_formats table

Upgrade site, Customer Portal

Issue:

On your production site, you are seeing all emails with the "completed" status in your report. However, on your upgrade site you are only seeing one email.

Resolution:

After cutover your site will be associated to the production database again, where this was unchanged. So, you will see the full list of emails again in that report.

Cause:

When an upgrade site is created, a script runs that sets the status_id in the mailing_formats table to 1 (draft). On production, the status_id is 8 (complete).