Below is the info you were looking for....a describe in PL/SQL developer did the job.

One thing to note that I successfully hooked up a pivot table directly to the Oracle...

Thank you, Jo!

The driver/Provider for my linked server is "Oracle Provider for OLE DB".

I thought I would share the answer, although I am still left with questions.

Someone on another forum suggested the following to get more insight into what is happening:

...

I can query the SQL view in Mgt. Studio and see all of the numbers.

Excel Pivot Tables work for views that are not using linked servers pointing to Oracle...

It is probably something that Excel should handle. It seems like a UniCode issue, but the source data-type is just Number. I thought there was also a possiblity...

Thank you Paul! I am new here. I couldn't figure out how to delete a post after I found I had posted in the wrong place. Do...