Skip to main content
Question

Column names on Oracle VIEW doesn't show on FME workbench.

  • September 25, 2024
  • 1 reply
  • 43 views
pushpa
Contributor
Forum|alt.badge.img+9

Hi there,

I have placed few VIEWS on Oracle Database changing TABLE column names. 

ie: ID as PLANT_ITEM_ID

When I connect the VIEW via FME 2023.2.1.0 all column names are showing as what is recorded on Oracle Tables. It is ignoring column names I have set up on VIEWs. How do I get around this issue?

I don’t want to use “attribute manager” to change the names. I have already done that on my VIEWs.

Is there a way I can see the Column names on VIEWS through FME?

thanks

Regards,

Pushpa  

1 reply

kailinatsafe
Safer
Forum|alt.badge.img+21
  • kailinatsafeSafer
  • Safer
  • September 30, 2024

Hello @pushpa, are you able to specify the oracle reader in use, as well as the build of FME Form being used? I created a new view, edited a column name to include ‘_X’ and saw this reflected in FME Form 2023.2.1 build 23774 & 2024.1. I might be interpreting incorrectly, are you able to share a screenshot of the view columns and the columns shown on the reader feature type in FME Form? Best, Kailin. 

Reply


Helpful Members This Week

Community Stats

31,073
Posts
117,797
Replies
38,834
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.