Why Is The Geocode Upgrade Manager Providing Different Results When Viewing The Output Vs The Log File? (Doc ID 2180876.1)

Last updated on NOVEMBER 16, 2016

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Reviewing the Geocode Upgrade Manager, see that the results are different between viewing the output vs viewing the log file.

 

Geocode Upgrade Manager ( DEBUG mode )

LOG:

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
GEOCODE_ANNUAL_2001 2001
GEOCODE_ANNUAL_2002 2002
GEOCODE_ANNUAL_2003 2003
GEOCODE_ANNUAL_2004 2004
GEOCODE_ANNUAL_2005 2005
GEOCODE_ANNUAL_2006 2006
GEOCODE_ANNUAL_2007 2007
GEOCODE_ANNUAL_2008 2008
GEOCODE_ANNUAL_2009 2009
GEOCODE_ANNUAL_2010 2010
GEOCODE_ANNUAL_2011 2011
GEOCODE_ANNUAL_2012 2012
GEOCODE_ANNUAL_2013 2013
GEOCODE_ANNUAL_2014 2014
GEOCODE_ANNUAL_2015 2015
GEOCODE_ANNUAL_2016 2016

Skipped calling child concurrent program "Geocode Upgrade Concurrent Program" as there are no impacted Assignments Skipped Patch Name : GEOCODE_ANNUAL_2016 completion status = C

OUTPUT:

Process Mode : DEBUG

Status of Geocode Upgrade Run
Patch Name Year Status
GEOCODE_ANNUAL_2001 2001 C
GEOCODE_ANNUAL_2002 2002 C
GEOCODE_ANNUAL_2003 2003 C
GEOCODE_ANNUAL_2004 2004 C
GEOCODE_ANNUAL_2005 2005 C
GEOCODE_ANNUAL_2006 2006 C
GEOCODE_ANNUAL_2007 2007 C
GEOCODE_ANNUAL_2008 2008 C
GEOCODE_ANNUAL_2009 2009 C
GEOCODE_ANNUAL_2010 2010 C
GEOCODE_ANNUAL_2011 2011 C
GEOCODE_ANNUAL_2012 2012 C
GEOCODE_ANNUAL_2013 2013 C
GEOCODE_ANNUAL_2014 2014 C
GEOCODE_ANNUAL_2015 2015 C
GEOCODE_ANNUAL_2016 2016 N    <===================== This is the concern

 

To further clarify this issue in customer's instance, generate the following: 

1.  Execute the process in UPGRADE mode, and then execute the following query to confirm that there are 2 entries for the Geocode 2016 patch, one for the DEBUG mode and the other for the UPGRADE mode, and both should have a Status of 'C'.

select patch_name, patch_number, phase, status, applied_date, description
from pay_patch_status
where patch_name like '%GEO%'
order by applied_date;

Sample entry for 2016:

4228
DEBUG_GEOCODE_ANNUAL_2016
1111111 C 25-AUG-16

4230
GEOCODE_ANNUAL_2016
1111111 C 25-AUG-16

 

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms