FNDLOAD: Unable to overwrite pre-existing message (Doc ID 785081.1)

Last updated on NOVEMBER 01, 2015

Applies to:

Oracle Grants Accounting - Version 11.5.10.2 and later
Information in this document applies to any platform.
FNDLOAD, GMS_INS_REPORT_EXIST, FND_NEW_MESSAGES, gmsmessg.ldt

***Checked for relevance on 26-MAY-2014***

Symptoms

 

Oracle Grants Accounting <patch 7680779> contains changed message text for message tag GMS_INS_REPORT_EXIST. Successful patch application still shows old message in FND_NEW_MESSAGES table.

  

Command used to load the message from worker log was -

FNDLOAD &ui_apps 0 Y UPLOAD @FND:patch/115/import/afmdmsg.lct @GMS:patch/115/import/US/gmsmessg.ldt

Changes

LAST_UPDATED_BY column in FND_NEW_MESSAGES table contains USER_ID as -1 for message tag GMS_INS_REPORT_EXIST however, datafile entity gmsmessg.ldt contains OWNER as ORACLE i.e. USER_ID=2. This is causing patch not to overwrite pre-existing message which is updated or customized.

Cause

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