How do Oracle Forms work in R12? What components are involved?? Oracle forms server works based on 3 Tier Architecture. A tier is a logical collection of services running on more than one machine. Client Tier: The client browser connects to the form server using the forms client Applet which is running on the local […]
Oracle
How and Why to Logically Reverse the Star Schema in Oracle BI
Kathryn Watson, Solution Architect at Perficient, presented at KScope14 today about reversing the star schema in Oracle BI logically in the metadata Administration tool of Oracle Business Intelligence. It has long been accepted that classically designed dimensional models provide the foundations for effective Business Intelligence applications. But what about those cases in which the facts […]
Using Crave for Restaurant Operations Analytics
Patrick Abram, Director at Perficient, presented at KScope14 this week about using Oracle products for restaurant operations analytics: Multi-unit, multi-concept restaurant companies face challenging reporting requirements. How should they compare promotion, holiday, and labor performance data across concepts? How should they maximize fraud detection capabilities? How should they arm restaurant operators with the data they need […]
Big Data: Creating both Business and Societal Sea Changes
At Oraclae’s KScope User Group meeting yesterday, I heard a really riveting presentation given by Jake Porway, Founder of DataKind, which made me take pause. It really brought to light Big Data’s capacity to impact all aspects of business *and* human life itself. The point made was that we are at an inflection point in […]
Essbase Application Performance Tuning
Essbasse system and application performance tuning are very important tasks for a successful implementation of Essbase or Hyperion Planning. Good application design and proper system administration include some of following items. 1) Design The Outline Hour Glass Model 2) Defragmentation 3) Database Restructuring 4) Compression Techniques 5) Cache Settings 6) Intelligent Calculation 7) Data Load […]
What are the True Costs of Providing Health Care?
Terie McClintock, Director at Perficient, recently wrote a blog post about the challenge caregivers face in understanding the total costs involved throughout the entire path that a patient travels. If you ask caregivers to determine their current workflow, they don’t really know where the patient and family go before or after each step of their […]
Perficient @ K-Scope
“The smartest people on the planet working in the Oracle stack know that Kscope is the best conference to attend. Kscope offers great content from developers, administrators, architects, and business users.” That is how the Oracle Development Tools User Group describes their forthcoming conference. Two of our own experts in Business Intelligence and OBIEE will […]
Oracle WebADI as “Automation Tool”
Overview WebADI is a web based browser application which helps in integrating the desktop applications MS Word, MS Excel and MS Projects with Oracle E-Business. WebADI increases the productivity as the user need not change the user interface which are familiar to the user. Scope of this blog is to highlight 2 scenarios which helped […]
OAUG Collaborate ’14
What an active week we’ve had here at OAUG Collaborate ’14! We have met a ton of great Oracle users at the Perficient booth, discussing our ERP, EBS, CX and BI capabilities, with over 300 registrants to win an XBOX ONE. We had some great meetings with the leadership of Oracle’s Partner Alliances around Oracle […]
Using @XWrite vs @XRef Functions
The Situation: Planning 11.1.2.1 Client has two Plan types (Finance & FTE) Detail employee data is held in the FTE cube and summary employee data is held in the Finance cube Requirement: Move data from FTE cube to Finance cube at the summary level as efficiently as possible. Solution: The @XWRITE function does just what […]