Issue Description
We are experiencing consistent failures when attempting to export and import individual pages between different APEX applications, both within the same workspace and across different environments (DEV → HML → PRD). The import process consistently returns an HTTP 400 error with the following database constraint violation when debugging the session:
ORA-02291: integrity constraint (APEX_240200.WWV_FLOW_PLUG_MENU_FK) violated – parent key not found
Environment Details
- Platform: Oracle Cloud Infrastructure (OCI)
- DEV Workspace: DBCS 23AI with APEX 24.2.5
- HML/PRD Workspaces: ATP 23AI with APEX 24.2.6
- Import/Export Method: APEX interface with default export settings
Key Observations
- Full application exports/imports work successfully - the issue occurs only with individual page imports
- Error is consistent even on same workspace
Summary
Successful Imports (✅)
- Empty pages (no content) importing within same environment
- Cross-environment imports of empty pages (DEV → HML → PRD)
Failed Imports (❌)
- Full content pages (real development pages) consistently fail regardless of:
- Page mode (Normal/Modal)
- Source/target environment combination
- Cross-environment imports of full pages show 100% failure rate
- Even simple DEV → DEV imports fail when pages contain substantial content
Pattern identified: Page complexity appears to be the determining factor. Empty pages import successfully, while pages with substantial content (items, regions, components) consistently fail with the constraint violation.
Additional Information
- Complete session debug logs are available if needed for analysis
- Oracle Support Reference: SR 4-0000890469 has been opened for this issue
Any guidance or suggestions from the community would be greatly appreciated. Thank you for your assistance!