- 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"
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.