Could you please list the detail steps to reproduce your issue so that I could have a check on it?
- right click on application, choose "deploy application"
- select target db -> next
- import options:
Build Status RUN_ONLY
Application ID: my app id, 109 in this case, "Overwrite" is checked.
The import itselft and the deployed application are working. Except for the Public saved Interactive Reports, they dont show up in the target database.
Reports are generated this way:
- Run page with IR in DEV environment.
- select filters, etc , choose "Save Report", save as Named Report, check "Public"
On Export Page, set (under Export Options) the setting Export Public Interactive Reports to yes.
that parameter is set to yes - in the apex development app.
but i tried to deploy the app using sql developer - and not using export/import in apex dev application.
just compared the fxxx.sql file generated by the apex dev app and the temp file generated by sql developer.
there are several wwv_flow_api.create_worksheet_rpt calls missing in the sql developer temp file.
Just remember once I did the export using APEX, import and deploy using SQLDev, it failed. If I export and import using APEX, it just worked.
I have raised a bug for this, developers have not updated on this yet.
Could you try all your steps using APEX to see if the Interactive Report works ?
Works without any problems using Export in APEX and import with sqlplus. Public and Named IR are visible.
So this issue must has been caused by that bug. I will update this thread once there is any update on the bug.