Any idea for this Flow error?

Question

RVohra · Answer

@Stefano_Mazzocca ,

Please refer following youtube video provided by Oracle Analytics Team

Manage Data Flows: Common Challenges and Mitigation

Basically, Source dataset in a data flow should only show visible columns. It should not have hidden columns.

Workaround for this is deselecting the columns that are hidden in preparation phase of the data flow or make them visible (not hidden).

Also check the following documentation on how to hide / unhide a column: Hide or Delete a Column

Hope it helps!

Thanks

Rajesh

Bhaskar Konar · Answer

Hi @Stefano_Mazzocca,

'ORA-00904' means Oracle SQL is trying to reference a column that does not exist in the result set at that stage of the query.

From the SQL visible in the screenshot, I can see something like:

avg("AddColumns_0"."Total Compensation Paid")
    as "Total Compensation Paid Aggregate"

and later the outer query references:

"FTE_TOTAL_COMPENSATION_PAID"

Can you please check if there is a mismatch between:

* The Original Column Name 
* The alias created in Add Columns or Aggregate and 
* The Column referenced later in the Data Flow.

Hope this help.

Thank you.