April 2015 Oracle Critical Patch Update

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

April 2015 Critical Patch Update Advisory:

Posted on April 16, 2015 by SmartDog Services

Oracle continues to periodically receive reports of malicious exploitation of vulnerabilities for which Oracle has already released fixes. In some instances, it has been reported that malicious attackers have been successful because customers had failed to apply available Oracle patches. Oracle therefore strongly recommends that customers remain on (more...)

You Are Trying To Access a Page That Is No Longer Active.The Referring Page May Have Come From a Previous Session. Please Select Home To Proceed

Shahed pinged me about this error.  It was coming after logging in.  This R12.1.3 instance had just migrated from an old server to a new one. Once you logged in this error would be displayed:

You Are Trying To Access a Page That Is No Longer Active.The Referring Page May Have Come From a Previous Session. Please Select Home To Proceed

The hits on support.oracle.com were not helpful, but a (more...)

Chrome and E-Business Suite

Dhananjay came to me today.  He said that his users were complaining about forms not launching after upgrading to the latest version of Chrome. On launching forms they got this error:

/dev60cgi/oracle forms engine Main was not found on this server

I recalled that Google Chrome team had announced that they would not support java going forward. Googling with keywords chrome java brought this page:

https://java.com/en/download/faq/chrome.xml#npapichrome

It states that:

NPAPI support by Chrome

Faster Download of PeopleSoft Images

With the advent of Selective Adoption, many more people will be downloading the huge PeopleSoft Images every 10 weeks or so. They’re large (circa 35GB) and that’s going to take a while even with a decent connection.

What makes matters worse is that the default method (clicking the Download All button) runs the downloads in serial. Even on a 1MB/sec connection that’s going to take ~10 hours to download all 35GB.

Download All

In addition, the download (more...)

Cedar’s exciting new office

Today I got my first glimpse of Cedar’s new UK head-quarters in use. I’d seen it during the renovations, however now the work is complete and we’ve started to move in properly it’s really exciting to see people actually using it for real.

Main Office(Travis, Pete, Hardik and Kirti making themselves at home)

I’m particularly pleased that we’ve managed to purchase an office that’s still got the same great location as our previous premises, but is ours (more...)

You May be Facing a Financial Ticking Time Bomb with Your Oracle E-Business Suite Implementation

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

When you first purchased Oracle E-Business Suite, it was understandably a huge financial commitment—but that commitment did not end when you installed the last module and paid the bill.

Unfortunately, too many IT leaders ignore this fact, creating a huge financial risk for their enterprises. ERP software is expensive and a huge business asset. But few organizations are familiar with the terms (more...)

Good News On The EBS Front

Most people who know me professionally know about my enthusiasm for enterprise applications delivered via the SaaS model.  In terms of adoption and agility, SaaS is a winner.  But, at the same time, I also recognized that SaaS is not for everybody.  Those who customize heavily and those who want to retain a higher level of control are probably better off with on-premise enterprise applications.

So I was happy to hear about Cliff Godwin, Oracle's (more...)

Forms Tables

I’ve been doing some work with the Enterprise Component Forms in HCM, and it is helpful to know the tables in the backend.  Here are the tables that I have found so far…

Note: One issue I have with the forms is that I haven’t found a way to edit someone else’s form.  If a functional consultant mock’s up a form, I can’t get access to the form to take over development and finish (more...)

opatch hangs on /sbin/fuser oracle

Pipu pinged me today about opatch hanging. The opatch log showed this:

[Apr 11, 2015 5:24:13 PM]    Start fuser command /sbin/fuser $ORACLE_HOME/bin/oracle at Sat Apr 11 17:24:13 EDT 2015

I had faced this issue once before, but was not able to recall what was the solution.  So I started fresh.

As oracle user:

/sbin/fuser $ORACLE_HOME/bin/oracle hung

As root user

/sbin/fuser $ORACLE_HOME/bin/oracle hung

As root user

lsof hung.

Google searches about it brought up a lot (more...)

How to Best Deploy the Oracle Order Management Sales Order Status Tracking and Interpretation

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

Many people new to Order Management and Shipping initially think that the statuses on the order header and order line are the only tools available for tracking the order process. In actuality, there are more options.

Posted on April 10, 2015 by Gene Gysin

Depending on what Oracle E-Business Suite (EBS) modules are installed, you can see order line status and movement (more...)

Oracle Forms and 12c

Past few weeks I received some questions on Oracle Forms and 12c.
Well, two types of question, first on the future of Forms and the next version, 12c that is, and on Oracle Forms combined with the Oracle 12c database.
 

How to Manage Rebuildable Assets in Oracle eAM

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

There are many reasons for having high-value parts sitting on shelves in your maintenance shop. The parts may be critical to the production line or are part of configurations that allow you to produce multiple lines or sizes of product from the same machine. They might even be essential parts that are no longer produced by the machine maker and have no (more...)

Nephophobia

They say that these are not the best of times
But they're the only times I've ever known
And I believe there is a time for meditation
In cathedrals of our own

Now I have seen that sad surrender in my mother's eyes
I can only stand apart and sympathize
For we are always what our situations hand us
Its either sadness or euphoria

                      (more...)

EBS 12.2 do not ignore the database patches on top of AD Delta 5 and TXK Delta 5

Make sure all the recommended patches are in place as a part of the bundle patch. Your EBS 12.2 ADOP cycle could go unstable with out the database patches.

adoafmctl.sh hangs

Rajesh and Shahed called me about this error where after a reboot of the servers, adoafmctl.sh wouldn't start.  It gave errors like these:

You are running adoafmctl.sh version 120.6.12000000.3 
Starting OPMN managed OAFM OC4J instance ... 
adoafmctl.sh: exiting with status 152 
adoafmctl.sh: check the logfile 
$INST_TOP/logs/appl/admin/log/adoafmctl.txt for more information

adoafmctl.txt showing:
ias-component/process-type/process-set:
default_group/oafm/default_group/
Error
--> Process (index=1,uid=349189076,pid=15039)
time out while waiting for a managed process to (more...)

Collecting Data for Planning on a Nightly Basis is Good Enough

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

Without fail, I am asked the same question every time I give a training session on the Oracle Advanced Supply Chain Planning (ASCP) application.

In explaining how ASCP uses data collections, I share a planning data collection summary based on yesterday’s information that was collected overnight. Then I pause and wait for it… Within 60 seconds I always hear the question: (more...)

A command-line alternative to PeopleSoft SendMaster

If you are familiar with PeopleSoft Integration Broker, I'm sure you have dealt with SendMaster to some degree. This is a very simple but yet useful tool to perform unit tests of the Integration Broker incoming service operations using plain XML (if I'm dealing with SOAP Web Services, I normally use SoapUI, for which there is a very good article on PeopleSoft Wiki).

Most of the time it's enough with SendMaster, but today I (more...)

Do You Know the Terms of Your Oracle E-Business Suite Licenses? You Can’t Afford Not To.

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

How many years ago did you purchase Oracle E-Business Suite? Have you upgraded lately or bought a new server? Are you about to pull the trigger to move to a hosting solution? Well if you make any changes to your architecture you may inadvertently create a huge financial risk for your organization because any one of these events can impact the terms (more...)

5 Steps to Winning Top to Bottom Support for Reliability-Based Maintenance

Oracle Is Easy, a blog written by <a href="http://www.smartdogservices.com" SmartDog Services

Regardless of the industry, company executives are always watching the bottom line. They want equipment up and running at full capacity to meet output goals – even if it means pushing the equipment beyond designed capacities and on an ever-shrinking maintenance budget. You know a reliability-based maintenance management approach is the solution; you have read articles (and BLOGS) about equipment failure pattern (more...)

R12.2 Documentation link in html format

This link has the R12.2 documentation in HTML format:

https://docs.oracle.com/cd/E26401_01/index.htm