Sasank's PeopleSoft Log: DIY - PeopleSoft on the Cloud - Part 1

Sasank's PeopleSoft Log: DIY - PeopleSoft on the Cloud - Part 1: There has been tremendous improvements in PeopleTools 8.55 - which we have seen over the past year - specifically involving changes that ma...

Sasank's PeopleSoft Log: DIY - PeopleSoft on the Cloud - Part 2

Sasank's PeopleSoft Log: DIY - PeopleSoft on the Cloud - Part 2: Now that we have the PeopleSoft PUM Image (DEMO environment) up and running on the Oracle Compute Cloud, we can move on and dive deeper int...

Sasank's PeopleSoft Log: DIY - PeopleSoft on the Cloud - Part 3

Sasank's PeopleSoft Log: DIY - PeopleSoft on the Cloud - Part 3: In this third and final part, I will demonstrate how to access the demo instance (PUM image on OPC) via SQL Developer and App Designer from...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 2 : Convert AdminManaged DB...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 2 : Convert AdminManaged DB...: I have an AdminManaged Database in my (2node) RAC Cluster. How do I convert it to PolicyManaged ? (Yes, let me admit :  It makes no sen...

berxblog: interconnect fragmentation kills the cluster

berxblog: interconnect fragmentation kills the cluster: On a particular Oracle 2 node cluster (12.1) we faced random instances failing. Servicerequests at Oracle were open with limited result, as ...

berxblog: interconnect fragmentation kills the cluster

berxblog: interconnect fragmentation kills the cluster: On a particular Oracle 2 node cluster (12.1) we faced random instances failing. Servicerequests at Oracle were open with limited result, as ...

Hyperion Error of the Day: EPMVirt: Oracle Hyperion 11.1.2.4 Virtual Environm...

Hyperion Error of the Day: EPMVirt: Oracle Hyperion 11.1.2.4 Virtual Environm...: Oracle Hyperion 11.1.2.4 Virtual Environment I have been working on a small project to provide the ability to create a Oracle EPM virtua...

Hyperion Error of the Day: EPMVirt: Oracle Hyperion 11.1.2.4 Virtual Environm...

Hyperion Error of the Day: EPMVirt: Oracle Hyperion 11.1.2.4 Virtual Environm...: Oracle Hyperion 11.1.2.4 Virtual Environment I have been working on a small project to provide the ability to create a Oracle EPM virtua...

Hyperion Error of the Day: EPMVirt Debugging

Hyperion Error of the Day: EPMVirt Debugging: For anyone needing assistance debugging the EPMvirt installation please run the following script to gather some debug info Please run as ...

External Table: IPython/Jupyter Notebooks for Oracle

External Table: IPython/Jupyter Notebooks for Oracle: Topic:  In this short post you can find examples of how to use IPython/Jupyter notebooks for running SQL on Oracle. IPython/Jupyter notebo...

Hemant's Oracle DBA Blog: Flashback Database -- 3 : Purging (older) Flas...

Hemant's Oracle DBA Blog: Flashback Database -- 3 : Purging (older) Flas...: As demonstrated earlier , Oracle may maintain Flashback Logs for a duration that is longer than the Flashback Retention Target.  This can h...

Hemant's Oracle DBA Blog: Flashback Database Logs can exceed the Retention T...

Hemant's Oracle DBA Blog: Flashback Database Logs can exceed the Retention T...: The documentation on the Flashback Retention Target in 11.2 and 1 2.1 states that this parameter specifies an upper limit on how far the ...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 1 : Grid Infrastructure Ins...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 1 : Grid Infrastructure Ins...: Just as I had posted 11gR2 RAC Posts in 2014  ( listed here ), I plan to post some 12cR1 RAC (GI, ASM) posts over the next few weeks. Her...

Osama Mustafa Oracle Blog: When the last time the password has been changed ?...

Osama Mustafa Oracle Blog: When the last time the password has been changed ?...: Do you want to know what is the last time the DBA or developers change the password ? Using the below table :- Name ...

Hemant's Oracle DBA Blog: Flashback Database -- 3 : Purging (older) Flas...

Hemant's Oracle DBA Blog: Flashback Database -- 3 : Purging (older) Flas...: As demonstrated earlier , Oracle may maintain Flashback Logs for a duration that is longer than the Flashback Retention Target.  This can h...

Hemant's Oracle DBA Blog: Flashback Database -- 3 : Purging (older) Flas...

Hemant's Oracle DBA Blog: Flashback Database -- 3 : Purging (older) Flas...: As demonstrated earlier , Oracle may maintain Flashback Logs for a duration that is longer than the Flashback Retention Target.  This can h...

Hyperion Error of the Day: EPMVirt Debugging

Hyperion Error of the Day: EPMVirt Debugging: For anyone needing assistance debugging the EPMvirt installation please run the following script to gather some debug info Please run as ...

Cameron's Blog For Essbase Hackers: Passing 300

Cameron's Blog For Essbase Hackers: Passing 300: It all began one summer It seems so long ago (2,770 days or 396 weeks or 91 months or 7.6 years – but who’s counting?) that I first put p...

Cameron's Blog For Essbase Hackers: This blog's introduction

Cameron's Blog For Essbase Hackers: This blog's introduction: History I’ve worked with (and enjoyed, usually) Essbase since it was running on OS/2 on a Pentium 66 MHz Compaq underneath my desk with 256...

Hyperion Error of the Day: Keep Your Hyperion Platform Secure by Patching Web...

Hyperion Error of the Day: Keep Your Hyperion Platform Secure by Patching Web...: One of the Hyperion Administration tasks often overlooked is the need to patch the underlying components such as WebLogic. If you subscribe ...

Hyperion Error of the Day: Hyperion Auditing - In Practice vs. Theory

Hyperion Error of the Day: Hyperion Auditing - In Practice vs. Theory: At first glance the Shared Services audit features in Hyperion seem complete. However, in practice, the user interface seems to be clunky an...

Hyperion Error of the Day: Oracle Learning Library - Hidden Gems

Hyperion Error of the Day: Oracle Learning Library - Hidden Gems: The Oracle Learning Library has a myriad of tutorials on Hyperion and related technologies. They are often overlooked as the interface is fi...

Hyperion Error of the Day: EPMVirt: Oracle Hyperion 11.1.2.4 Virtual Environm...

Hyperion Error of the Day: EPMVirt: Oracle Hyperion 11.1.2.4 Virtual Environm...: Oracle Hyperion 11.1.2.4 Virtual Environment I have been working on a small project to provide the ability to create a Oracle EPM virtua...

Hyperion Error of the Day: EPMVirt 11.1.2.4 now with HFM

Hyperion Error of the Day: EPMVirt 11.1.2.4 now with HFM: It has taken a bit longer than expected, but I am now releasing EPMVirt which includes HFM 11.1.2.4. The two main issues were getting the co...

Hyperion Error of the Day: Useful Administrative Tools in Windows

Hyperion Error of the Day: Useful Administrative Tools in Windows: Do you work with Hyperion in Windows and feel like your hands are tied? Like a fish out of water? OK, maybe this is an exaggeration for most...

Hyperion Error of the Day: Linux Tips - Beyond the Basics (Part 1)

Hyperion Error of the Day: Linux Tips - Beyond the Basics (Part 1): As a lot of recent posts have focused on Windows tips, a coworker of mine suggested writing up some Unix tips. Many day to day operations in...

Hyperion Error of the Day: Linux Tips - Beyond the Basics (Part 2)

Hyperion Error of the Day: Linux Tips - Beyond the Basics (Part 2): Find log files in / last modified within 1 day This is great when you are on an unfamiliar system or don’t know which log file you need t...

Hyperion Error of the Day: Linux Tips - Beyond the Basics (Part 1)

Hyperion Error of the Day: Linux Tips - Beyond the Basics (Part 1): As a lot of recent posts have focused on Windows tips, a coworker of mine suggested writing up some Unix tips. Many day to day operations in...

Hemant's Oracle DBA Blog: Services -- 2 : Starting and Connecting to Ser...

Hemant's Oracle DBA Blog: Services -- 2 : Starting and Connecting to Ser...: Continuing with the 12.1.0.2 non-RAC MultiTenant environment and two services demonstrated earlier , I have restarted the environment to...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...: It is generally accepted that service definition is required in RAC environments. However, the concept of Services was made available in ...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...: It is generally accepted that service definition is required in RAC environments. However, the concept of Services was made available in ...

Hemant's Oracle DBA Blog: Services -- 4 : Using the SERVICE_NAMES parame...

Hemant's Oracle DBA Blog: Services -- 4 : Using the SERVICE_NAMES parame...: In my previous blog post, I have demonstrated using DBMS_SERVICE to create and start services. But there is another way.  Using the SERV...

Hemant's Oracle DBA Blog: Services -- 3 : Monitoring Usage of Custom Ser...

Hemant's Oracle DBA Blog: Services -- 3 : Monitoring Usage of Custom Ser...: In my previous blog post, I had demonstrated a few custom services created and started with DBMS_SERVICE. Let's look at a couple of ...

Hemant's Oracle DBA Blog: Services -- 2 : Starting and Connecting to Ser...

Hemant's Oracle DBA Blog: Services -- 2 : Starting and Connecting to Ser...: Continuing with the 12.1.0.2 non-RAC MultiTenant environment and two services demonstrated earlier , I have restarted the environment to...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...

Hemant's Oracle DBA Blog: Services -- 1 : Services in non-RAC 12c MultiT...: It is generally accepted that service definition is required in RAC environments. However, the concept of Services was made available in ...

Jaffar's (Mr RAC) Oracle blog: Wanna become an OCM? Go on read out Kamran's new O...

Jaffar's (Mr RAC) Oracle blog: Wanna become an OCM? Go on read out Kamran's new O...: When I first heard about Kamran's new book, OCM practical guide, I said wow, because I was thinking on the same line a few years back, ...

Hooked On Hyperion: Descriptive Statistics And Clustering With Data Mi...

Hooked On Hyperion: Descriptive Statistics And Clustering With Data Mi...: Ok, this is my third post in a series of predictive analytics for Essbase/Planning.  In the first one, “ Essbase Meets R ”, I described...

Hemant's Oracle DBA Blog: TRUNCATEing a Table makes an UNUSABLE Index VALID ...

Hemant's Oracle DBA Blog: TRUNCATEing a Table makes an UNUSABLE Index VALID ...: Here's something I learned from Jonathan Lewis sometime ago. If you set an Index to be UNUSABLE but later issue a TRUNCATE TABLE, the...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 17 -- Lice...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 17 -- Lice...: This is never a fun topic, is it? With the caveat that IANAL nor am I the guy that actually signs the contract nor do I work for Oracle,...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 17 -- Lice...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 17 -- Lice...: This is never a fun topic, is it? With the caveat that IANAL nor am I the guy that actually signs the contract nor do I work for Oracle,...

Hemant's Oracle DBA Blog: SQL*Net Message Waits

Hemant's Oracle DBA Blog: SQL*Net Message Waits: Here are some extracts from an 11.2.0.4 AWR Report  I ran a simulated workload on this server for about 40minutes and generated this report...

Hemant's Oracle DBA Blog: Undo and Redo

Hemant's Oracle DBA Blog: Undo and Redo: Quick and Rough Notes : Undo and Redo Undo is where Oracle logs how to reverse a transaction (one or more DMLs in a transaction) Red...

Hemant's Oracle DBA Blog: Obj# and DataObj# in 12c AWR

Hemant's Oracle DBA Blog: Obj# and DataObj# in 12c AWR: The 12c AWR Report section on Segment Statistics now reports both Obj# (OBJECT_ID) and DataObj# (DATA_OBJECT_ID).  This is useful informati...

Hooked On Hyperion: Descriptive Statistics And Clustering With Data Mi...

Hooked On Hyperion: Descriptive Statistics And Clustering With Data Mi...: Ok, this is my third post in a series of predictive analytics for Essbase/Planning.  In the first one, “ Essbase Meets R ”, I described...

Steven Feuerstein on Oracle PL/SQL: "Give me a project I can work on, Steven!" OK, her...

Steven Feuerstein on Oracle PL/SQL: "Give me a project I can work on, Steven!" OK, her...: Probably once a month, I receive an email from a programmer who either wants to tune up their Oracle Database programming skills (SQL and PL...

Andrejus Baranovskis Blog: Oracle JET and ADF BC REST Security Integration Ap...

Andrejus Baranovskis Blog: Oracle JET and ADF BC REST Security Integration Ap...: I have promised to atendee of my OOW'16 session (Building Enterprise-Grade Mobile Apps with Oracle JET and Cordova [CON5731]) to post a...

Look Smarter Than You Are: Learn About Hyperion & Oracle BI... 5 Minutes at a...

Look Smarter Than You Are: Learn About Hyperion & Oracle BI... 5 Minutes at a...: Since early 2015, we've been trying to figure out how to help educate more people around the world on Oracle BI and Oracle EPM. Back in ...

Hooked On Hyperion: Essbase Scrambler User Guide

Hooked On Hyperion: Essbase Scrambler User Guide: Summary Preparations Download Extract Copy Objects And Data On Windows On Linux Updating XML parameters On Windows On L...

Glenn Schwartzberg's Essbase Blog: A quick tip for Dataexport

Glenn Schwartzberg's Essbase Blog: A quick tip for Dataexport: I love the dataexport function in calc scripts. I tend to use it a lot for both writing data to flat files and to relational databases. I’ve...

Glenn Schwartzberg's Essbase Blog: Essbase Config file changes

Glenn Schwartzberg's Essbase Blog: Essbase Config file changes: Throughout time, I have come up with a list of Essbase configuration file settings that I typically use in my implementations. As the versio...

Tim Tow's Hyperion Blog: Smart View Internals: Exploring the Plumbing of Sm...

Tim Tow's Hyperion Blog: Smart View Internals: Exploring the Plumbing of Sm...: Ever wonder how Smart View stores the information it needs inside an Excel file?  I thought I would take a look to see what I could learn.  ...

Hooked On Hyperion: Hyperion Testing Methodologies

Hooked On Hyperion: Hyperion Testing Methodologies: Summary In this post I try to apply some of quality management methodologies to Hyperion development processes. Information quality (I...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 12, PBCS a...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 12, PBCS a...: I have spared you Gallia est omnis divisa in partes tres .  Are you grateful? After my last bout of dead language infatuation , the answe...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS No. 13, LCM aka...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS No. 13, LCM aka...: Danger 5 I have been accused of being somewhat conservative in my consulting career:  taking the simple approach over the clever even whe...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS No 14, Chris Ro...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS No 14, Chris Ro...: Introduction Yes, another Compleat Idiot post, and yes another one not written by yr. obt. svt.  Aren’t you glad? This time round we h...

Look Smarter Than You Are: 7 Signs Your EPM is Lagging Behind Your Competitio...

Look Smarter Than You Are: 7 Signs Your EPM is Lagging Behind Your Competitio...: Regardless of industry, regardless of size, regardless of duration, all companies have similar issues in their financial analysis, plannin...

Cameron's Blog For Essbase Hackers: Hybrid Essbase, Oracle, Kscope16, and you

Cameron's Blog For Essbase Hackers: Hybrid Essbase, Oracle, Kscope16, and you: Surveying the Hybrid landscape If you read this blog, you know that Hybrid is the future of Essbase.  If you don’t agree with that you s...

Cameron's Blog For Essbase Hackers: Taking the Oracle Enterprise Planning Cloud Survey...

Cameron's Blog For Essbase Hackers: Taking the Oracle Enterprise Planning Cloud Survey...: Surveying the EPM Cloud landscape NB – The below is a somewhat humorous repeat of what I wrote about the Hybrid survey.  This is in part...

Cameron's Blog For Essbase Hackers: Stupid Programming Tricks No. 29 -- Dynamic Load R...

Cameron's Blog For Essbase Hackers: Stupid Programming Tricks No. 29 -- Dynamic Load R...: Preface This was originally going to be one ginormous post on Stupid Essbase Load Rule Tricks but once I got to page 12 and realized I wa...

Tim Tow's Hyperion Blog: Cool Essbase MDX Stuff – Dimension Properties Edit...

Tim Tow's Hyperion Blog: Cool Essbase MDX Stuff – Dimension Properties Edit...: I have always liked MDX as it exposes very powerful operations for creating member sets.  It has this amazing ability to take a set of membe...

Cameron's Blog For Essbase Hackers: Yup, another South Florida EPM meetup and the best...

Cameron's Blog For Essbase Hackers: Yup, another South Florida EPM meetup and the best...: Yup, another one and the best yet I just attended my sixth (I think it was the sixth but it’s all beginning to blur a bit.  Fifth?  Fourt...

Cameron's Blog For Essbase Hackers: Tim and Cameron's most excellent 00W 16 EPM meetup...

Cameron's Blog For Essbase Hackers: Tim and Cameron's most excellent 00W 16 EPM meetup...: Un insanity Un insanity?  Why not?  After all, un likely, un wieldly, and un desirable are all words in good old American (or, if you’re ...

Hooked On Hyperion: Automated Essbase Optimization, Testing, Monitorin...

Hooked On Hyperion: Automated Essbase Optimization, Testing, Monitorin...: Dmitry Kryuk <hookmax@gmail.com> Creation Date:  May 20, 2015 Last updated: May 20, 2015 Version: 1.0 Abstract Framework...

Hooked On Hyperion: Automate EPMA-Studio Integration

Hooked On Hyperion: Automate EPMA-Studio Integration: Overview In the next several posts i’m going to show how to automate extracts from EPMA into relational database, integration with Essbas...

Look Smarter Than You Are: Learn About Hyperion & Oracle BI... 5 Minutes at a...

Look Smarter Than You Are: Learn About Hyperion & Oracle BI... 5 Minutes at a...: Since early 2015, we've been trying to figure out how to help educate more people around the world on Oracle BI and Oracle EPM. Back in ...

Glenn Schwartzberg's Essbase Blog: A Guest Post Reviewing Developing Essbase Applica...

Glenn Schwartzberg's Essbase Blog: A Guest Post Reviewing Developing Essbase Applica...: OK, I’m just the middleman here. Tracy McMullen asked me to post her review of Developing Essbase Application: Hybrid Techniques and Practi...

Glenn Schwartzberg's Essbase Blog: A Guest Post Reviewing Developing Essbase Applica...

Glenn Schwartzberg's Essbase Blog: A Guest Post Reviewing Developing Essbase Applica...: OK, I’m just the middleman here. Tracy McMullen asked me to post her review of Developing Essbase Application: Hybrid Techniques and Practi...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 5 -- Migra...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 5 -- Migra...: Wrong Way Corrigan There are plenty of blog posts , videos , and Oracle documentation on how to go from on-premises Planning to PBCS.  ...

Cameron's Blog For Essbase Hackers: Stupid Programming Tricks No. 28 -- LCM, 7z, and P...

Cameron's Blog For Essbase Hackers: Stupid Programming Tricks No. 28 -- LCM, 7z, and P...: How long can Yr. Obt. Svt. be wrong? The answer to that question is apparently indefinitely.  And the task so trivial.  Sigh. The prob...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 5 -- Migra...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 5 -- Migra...: Wrong Way Corrigan There are plenty of blog posts , videos , and Oracle documentation on how to go from on-premises Planning to PBCS.  ...

Hooked On Hyperion: Testing Hyperion Planning with LoadRunner and ALM ...

Hooked On Hyperion: Testing Hyperion Planning with LoadRunner and ALM ...: Dmitry Kryuk <hookmax@gmail.com> Creation Date: May 16, 2014 Last updated: May 21, 2014 Version: 1.0 Overview Workflo...

Hooked On Hyperion: Essbase CDF Workshop Part I

Hooked On Hyperion: Essbase CDF Workshop Part I: Introduction I decided to write a series of posts on a topic that is as old as essbase itself (maybe not - but it’s pretty old). But, in ...

Hooked On Hyperion: Automate EPMA-Studio Integration

Hooked On Hyperion: Automate EPMA-Studio Integration: Overview In the next several posts i’m going to show how to automate extracts from EPMA into relational database, integration with Essbas...

Javier's PeopleSoft blog: PeopleSoft Update Image as a Service - Proof of Co...

Javier's PeopleSoft blog: PeopleSoft Update Image as a Service - Proof of Co...: Together with PeopleSoft 9.2, Oracle announced the new Continuous Delivery model for delivering patches, based on PeopleSoft Update Manager...

Javier's PeopleSoft blog: Oracle Open World 2016 from a PeopleSofter point o...

Javier's PeopleSoft blog: Oracle Open World 2016 from a PeopleSofter point o...: In every crisis there is an opportunity. This is what I thought as I woke up for the second day in a row before 2.30am due to my jet lag ...

Oracle related stuff: DBMS_STATS - Gather statistics on tables with many...

Oracle related stuff: DBMS_STATS - Gather statistics on tables with many...: This is just a short 12c update on my post about gathering statistics on tables with many columns from some time ago. I'm currently i...

Kris' blog: SDSQL - Pre and Post Commands

Kris' blog: SDSQL - Pre and Post Commands:   This is in the process of evolving but should be enough for anyone to give it a whirl.  The idea is that for any given statement you may w...

Kris' blog: SDSQL - Pre and Post Commands

Kris' blog: SDSQL - Pre and Post Commands:   This is in the process of evolving but should be enough for anyone to give it a whirl.  The idea is that for any given statement you may w...