Tag

First Day of Current Month 1 SELECT trunc(sysdate) - (to_number(to_char(sysdate,'DD')) - 1) FROM dual Last Day of Current Month 1 SELECT add_months(trunc(sysdate) - (to_number(to_char(sysdate,'DD')) - 1), 1)...

I like seeing Oracle leverage non-Oracle technology, like Adobe Flex and AIR. I hope that trend continues for Oracle…while Microsoft goes off to build things like Silverlight and Apple simply decides to avoid support for Flash altogether on their iPhone and iPad devices. I...

I have been somewhat enamored by Google Apps and its potential. Many enterprises have been happy with Exchange for mail, calendaring, contacts, and more. I have been one of those people. However, I have found Google Apps to be getting better and better for use in the...

We have a family tree. Some people have children, while others do not. We want to sort results by alphabetically listing individuals with children in an initial group, and then those without children in a second group -- also alphabetically. Let’s assume there is not an...

The Challenge

ABC, a publicly traded services and manufacturing organization, has leveraged Oracle E-Business Suite (EBS) to manage a variety of back-office functions, including their suppliers. Suppliers have been provided data from EBS manually by...

While using SSO, in order to create a public connection to Oracle Discoverer for Oracle Applications, I suggest creating a service account (user) in EBS and marking that user for LOCAL authentication (instead of SSO). There may not be many reasons to create a public connection in...

Bringing together many components of the Oracle Fusion Middleware Suite, as well as Oracle Applications (via E-Business Suite), M&S is uniquely positioned to delivery immense value in a short amount of time. M&S is designing and implementing a security, integration, and...