Getting ORA-43912 whilst trying to create a page as a copy on Apex using 23ai
Summary:
I've created a new 23ai Apex instance and imported three applications from an Apex instance running on 21c. When trying to copy a page between two of these applications on the 23ai instance I get the following error…
report error:
ORA-43912: invalid collation specified for a CLOB or NCLOB value
This happens at the point the copy a page flow attempts to map templates from the source application to the target application. Whilst it is possible to proceed beyond this step in the copy a page flow the resulting page that is created is invalid. For example the page being copied contains an Interactive Grid region which is based on the Interactive Report template. However on the copied page in the target application the template field for that region just shows as a long number.