This isn’t best practice, but I found a way to switch out a record in a query without redoing the criteria. Here’s the situation: I have a query in which the row-level security is causing problems. It is slowing down the query and also eliminating future-dated rows from the results. So, I created a view of the table which would select all of the rows from the original table. It was basically a copy with (more...)
Just the other day, I needed to set a Date to null or blank, and I couldn’t remember how to do it. Here’s my notes so that I can remember next time. Javier’s blog came to the rescue:
The short version is: use the Date(0) function:
Local Date &hireDate; &hireDate = Date(0);
Here’s some more information to explore a little more in depth…
The Date() function (more...)
If you are upgrading your database to 11gR2 , you might want to make sure that you are using it. Deferred segment creation was introduced in (more...)
Time is passing very quickly ……I’m just recalling year 2012 and I was at Collaborate 2012 in Las Vegas and now year 2014…. & Collaborate 2014 is on !!! This year during Collaborate 14, I am pleased to share I have been selected to present at COLLABORATE 14: Technology and Applications Forum for the Oracle Community […]
We recently has a client with some LDAP performance issues, and had a need to tune how WebLogic was querying their LDAP repository. In WebLogic, the simplest way to do this is with their LDAP Filters. While trying to explain how to do this, I was struck by the lack of clear documentation on what exactly these filters are and why on earth you would need them... The best documentation was in the WebCenter guide (more...)
Every year all of the social media sites mail out “your top posts/tweets/pages/slideshares/whatever for the year” summaries. I expect that you’ve had some of these too.
I thought it’d be interesting to put mine in one place to see if there’s any correlation or trend in what you all find worth reading.
The PeopleSoft Weekly Newsletter
This is the free weekly email newsletter that we send out. More details here.
During 2013 we sent out (more...)
In this ebook, I am covering installation of Oracle EBS 12.2 with following: Redhat Linux, you can refer earlier ebook EBS R12.1.1 installation Pre-requisite for Installation of R12.2 Preparation of stage from media downloaded from e-delivery.oracle.com Installation of Oracle eBS R12.2.0 You can download from http://www.oraerp.com/Thread-eBook-Installation-of-Oracle-EBS-12-2 this is a base installation, will cover how to install […]
Last week, I received my annual report from WordPress/Jetpack. I have always enjoyed these reports, so I thought I would make it public.
For the complete report, view it here: PSST0101 – 2013 Year in Blogging
Here’s a couple of excerpts:
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 78,000 times in 2013. If it were an exhibit at the Louvre Museum, it would take about 3 days (more...)
Oracle e-business suite installation - pre-install checks on RHEL Linux 6.3 failed I was doing installation of Oracle EBS 12.2 and stuck on error during pre-install check. Web Server Install Prerequisites failed. After checking the detail from log file, strange to see this message as it is showing that RHEL 6.3 is not certified platform […]
weblogic.store.PersistentStoreFatalException: The persistent file store "WLS_DIAGNOSTICS" canno t open file WLS_DIAGNOSTICS000000.DAT
I examined $EBS_DOMAIN_HOME/servers/AdminServer/logs/AdminServer.log and found this error:
BEA-280060 - The persistent store "WLS_DIAGNOSTICS" encountered a fatal error, and it must be shut down: weblogic.store.PersistentStoreFatalException: [Store:280105]The persistent file store "WLS_DIAGNOSTICS" cannot open file WLS_DIAGNOSTICS000000.DAT.
weblogic.store.PersistentStoreFatalException: [Store:280105]The persistent file store "WLS_DIAGNOSTICS" cannot open file WLS_DIAGNOSTICS000000.DAT.
at weblogic.store. (more...)
(A longer (more...)
WARNING: PSAPPSRV, PSSAMSRV, PSQRYSRV, PSQCKSRV, PSPPMSRV and PSANALYTICSRV are configured with Min instance (more...)