Getting Lucky

Every once in awhile, I get lucky.  Out of the clear blue sky, life tosses me a bone…or a gold nugget…or a diamond.  We’re speaking figuratively, of course. I’m not much for bones unless it’s in the middle I’m BBQing.  Gold and diamonds…yeah, I’m not THAT lucky.  But I digress.

Aidan Duffy recently sent me an e-copy of his book, “The Oracle Opportunity: The Blueprint To Succeeding As An Oracle EBusiness (more...)

Datafication of Compensation Distribution

Is your data science providing you enough indications that challenge your existing compensation strategy?  Does it reveal that the art of compensation distribution performed by your managers is not in accordance with your compensation strategy? Old habits die-hard, so you need to make sure that your plan for data-driven decision-making is not getting overridden by compensation managers’ belief system and they are not ignoring data science recommendations.

DataficationofCompensationDistributionEven today challenge is to effectively distribute (more...)

Product Restrictions during R12.2 online patching

This information is from page 75 of Oracle® E-Business Suite Maintenance Guide Release 12.2 Part No. E22954-13, published in July 2013 available here

For patches that have manual steps, the patch readme file instructs you to use Oracle Patch Application Assistant (PAA) to create customized instructions for your system. PAA consolidates and displays only the relevant manual steps for all the patches you want to apply, including steps that you (more...)

Ben Admin Snapshot Error

I ran into this error with the Ben Admin Snapshot process. It was the second time I ran into it, so I thought that I had better make sure that I got this in my notes so I would remember it.

Here’s the error…

Costs Not Found For Pgm/Plan/Optn: <benefit program>/<plan type>/<option code>.
Application Program Failed
 In Pgm Section  : MOVE-TO-PDEFN                                                                                                                                               

Application Program Failed
 In Pgm Section  : TABLE-ACCESS(PSPBATBL)                                                                                                                                      
Application Program Failed
 In Pgm Section   (more...)

Oracle eBusiness Suite R12.2 released for Windows x64

Oracle has released eBusiness Suite R12.2 for Windows x64 communicated through Steven Chan blog. We can download media from Oracle Software Delivery Cloud including documents and patches. Whoever is going to install must refer Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Microsoft Windows x64 (64-bit) (My Oracle Support Document ID: 1330706.1) The following editions of […]

The post Oracle eBusiness Suite R12.2 released for Windows x64 appeared first on ORAERP.COM - Blogs.

Great Link: PSChrome Extension

The other day, I ran across this nice Chrome Extension called PSChrome.

I had an old TamperMonkey script that I had used, and I was wondering if an extension might make more sense. When I looked to see if one already exists, I found PSChrome.

PSChrome Extension in the Google Chrome Store

One of the big features is that it displays a list of environments on the sign on page. That allows you to jump (more...)

R12.2 upgrade – icxr12pd.sql takes a very long time

During an R12.2 upgrade, the worker icxr12pd.sql takes very long time.  This is document in My Oracle Support Article ICXR12PD.Sql Runs Slowly During Upgrade to 12.1.1 (Doc ID 864898.1)
Cause: The pre-upgrade steps for iProcurement were not implemented as documented in the upgrade guide
Though this article talks about R12.1.1, it also applies to R12.2.  If you read the 11i to R12.2 (more...)

Implementing Deferred Segment Creation After an Upgrade

I have written previously about Deferred Segment Creation. Each empty table and its indexes use only 64Kb (assuming an 8Kb blocksize and locally managed tablespaces), but in a PeopleSoft there can be be tens of thousands of such tables and that adds up to a saving worth making.

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...)

Speaking during Collaborate 2014

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 […]

The post Speaking during Collaborate 2014 appeared first on ORAERP.COM - Blogs.

WebCenter LDAP Filters Explained!

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...)

Optional Prompting in PS Query

If you don't fill in a prompt when running a PS Query, the query usually returns no row. If you want the query to still fetch data (ignoring the condition), this post is for you.

You Don’t Have to Write PeopleCode to Create an XML / BI Publisher Report using PS Query!

This post will help you create your first XML Publisher report using Query as a data source. If you are a business user trying to learn this reporting tool, you have come to the right place.

Could Oracle Cloud Trump Amazon Web Services?

OK, we all read or heard it recently in one form or another.  Oracle has told Amazon that it’s “game on” for leadership in the “commodity” Infrastructure as a Service (“IaaS”) market.  In other words, “we’ll beat you on price”.  Lots have folks have called the declaration crazy - Oracle can’t compete with Amazon on the basis of commodity pricing and never will.  Funny thing is, I think Oracle could actually (more...)

Installation of Oracle EBS 12.2

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 Installation of Oracle eBS R12.2.0 You can download from this is a base installation, will cover how to install […]

The post Installation of Oracle EBS 12.2 appeared first on ORAERP.COM - Blogs.

Pre-install checks on RHEL Linux 6.3 failed

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 […]

The post Pre-install checks on RHEL Linux 6.3 failed appeared first on ORAERP.COM - Blogs. The persistent file store "WLS_DIAGNOSTICS" canno t open file WLS_DIAGNOSTICS000000.DAT

After bouncing an EBS R12.2 VM, weblogic adminserver wouldn't start up.

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: [Store:280105]The persistent file store "WLS_DIAGNOSTICS" cannot open file WLS_DIAGNOSTICS000000.DAT. [Store:280105]The persistent file store "WLS_DIAGNOSTICS" cannot open file WLS_DIAGNOSTICS000000.DAT.
        at (more...)

Xprtly – Extreme Coolness

Something cool happened today…something extremely cool.  Xprtly was released into public beta.

What in the heck is Xprtly?  The best way to describe it is a cloud-based support platform, with a mobile application and a web interface for administration.  The idea is to connect users with support personnel who can respond to issues as they arise.  Xprtly also allows for data collection of both user and support personnel behavior, plus analytics (more...)

Fusion Applications: Some Suggested Reading

I just finished a really nifty book:  Oracle Fusion Applications Development and Extensibility Handbook.  Required reading for anyone working with Fusion Applications.

The organization of the book is one of the reasons I highly recommend it.  The first four chapters lay out a foundation of knowledge need by anyone working with Fusion Applications in a functional or technical role.  The remaining 11 chapters provide deep detail (including instructions with pictures) on personalizing, (more...)

Getting Ready to Generate XML / BI Publisher Reports

Looking to learn XML / BI Publisher? This is the first post in the XML / BI Publisher tutorial series and will help get the ground work done before you start using this powerful reporting tool.

Date to Timestamp Conversion during PeopleTools Upgrade

This document describes a script to convert Oracle date columns to Timestamps as used from PeopleTools 8.50 but only rebilding those indexes that reference those columns, rather than drop and recreate every index in the system, thus producing a significant saving of time during the upgrade.
(A longer (more...)