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

Last updated on AUGUST 16, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.