Skip to Main Content

MySQL Database

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!

Issue with Missing Column in Production Database for 12c Report

AJO THOMASSep 23 2025

Hi Team,

In UAT, I created a new column in the relevant table to support a 12c report requirement. However, this column does not exist in the Production instance. As a result, when deploying the .rdf report to Production, it is throwing an “Invalid Identifier” error for that specific column.

Could you please advise if there is a feasible approach to fetch the data from the UAT table (where the column exists) instead of the Production table? Alternatively, should we plan for a schema update in Production to align with UAT before the report is deployed?

Looking forward to your guidance on the best way to proceed.

Thanks & Regards,
Ajo Thomas

Comments
Post Details
Added on Sep 23 2025
0 comments
31 views