Getting even the simplest information out is like pulling teeth. I've been working to make a few easy views that show information in a logical, consise way. This has turned out to be a major undertaking, but I've now got a solid reporting infrastructure built. We can now do most of the reporting we need from two views, a customer and an invoice detail view.
Why Oracle doesn't ship with views that do these simple tasks is beyond me. To get total sales for a given time period is a view that takes up a page of code with case statements and whatnot. A view that we created here, and debugged over a period of months to get it to work right with returns and discounts. I asked the Oracle consultants if they had a view like that, and they said no. "You don't? Doesn't everyone need that kind of thing?" Not really, they said. "Come on, I just need to know what we sold, when, and to who... you're telling me people don't ask for that?"
"We've done many implementations, and people don't usually ask for that," was the reply. I'm just stunned.
Experienced Oracle Apps developers I've talked to don't really see this lack of good views in Oracle as a problem. All the people I've talked to just have these informal cut-and-paste libraries of code to do different things they cobble together as needed. I'm stunned that there's not more standardization and simplicity for doing tasks that every business out there would need to do.
I could be missing something, but I think I'm not. I've learned that when I see things differently than 5 other people, that doesn't mean I'm the one that's crazy. More than once I've felt like I'm the crazy one in a room full of people, only to learn later that they're all the ones that are wrong.