Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX5, how to change parsing scheme - invalid column

PaavoMay 4 2015 — edited May 4 2015

Hi

Application Express 5.0.0.00.31

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

Theme 25

I have challenge due wrong parsing schema for application classic report columns imported from other schema 'someschema' and upgraded to Apex5.

From Apex workspace with applications parsing schema 'someschema' --> To Apex workspace with 'otherschema' as parsing schema.

So for Classic Reports --> Columns there are INVALID definitions.

UI Defaults --> Table Owner --> someschema INVALID

UI Defaults --> Table Name --> sometable

UI Defaults --> Column --> somecolumn INVALID

The application works but when trying to change the Table Owner "someschema" to "Parsing Schema" then the freehand generated SQL columns "Table Name" and "Column" gets resetted.

UI Defaults --> Table Owner --> PARSING SCHEMA

UI Defaults --> Table Name -->

UI Defaults --> Column -->

Is there way to globally toggle the UI Defaults 'Parsing Schema' so it is not necessary to go numerous columns one by one?

In the Applications list the Parsing schema shows correctly for the application as 'otherschema'.

Rgrds Paavo

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 1 2015
Added on May 4 2015
#apex-discussions, #column, #schema
0 comments
483 views