The Duplicate column name error is issued when attempting to convert an Access query to Oracle that selects one or more like named fields from different tables.
For example, the following query refers to Customers.CompanyName and Shippers.CompanyName:
When converting this query to Oracle, Scriptoria will assign qualified aliases to these names. In this case, the aliases Customers_CompanyName and Shippers_CompanyName will be assigned, respectively. These arbitrary assignments will cause any form and report references to Customers.CompanyName and Shippers.CompanyName to become invalid.
To work around this problem, manually assign aliases to Customers.CompanyName and Shippers.CompanyName. Be sure to assign aliases that conform to Oracle naming conventions.
Save the query and then use Scriptoria to recreate the View, NORTHWIND.INVOICES in this case.
Then modify any forms and reports that include the query. Substitute the new aliases for all occurrences of the renamed fields; e.g., Customers.CompanyName. is replaced by Customer_Company.