Hi guys, we have a major issue exporting single pages from DEV system to LIVE system.
Both system are identical and all worked well on Apex 20.1
After upgrading both enviroments (same patch version 32006852 12 Nov),
when we export from DEV system a single page that has an IG with LOV, it gives a wrong refence ID of the LOV and we get below error during SINGLE PAGE IMPORT.
Execution of the statement was unsuccessful.
ORA-02091: transaction rolled back
begin
wwv_flow_api.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false));
commit;
After investigating, we found that when we used to export a single page that included a LOV, it was created SAME on PROD with same LOV ID.
Now, single pages imports from 20.2 DEV to 20.2 PROD, generates a different LOV ID which is not matching the export page ID, so it creates this issue.
When we export the full APP, it imports well, but we cannot export full app every time.
Please notify your dev team and save people from the frustration we had this weekend.