Wednesday, 10 August 2016

Changing Standard Oracle Message

http://receivablesar.blogspot.com/2016/08/changing-standard-oracle-message.html






  • goal: How to generate messages?
  • fact: FNDMDMSG - Define Messages
  • fact: FNDMDGEN - Generate Messages
fix: Responsibility: System Administrator Submit the concurrent process : Generate Messages Afterwards restart Oracle Application. OR Run from command line. Syntax is : $ FNDMDGEN APPS/APPS 0 Y DB_TO_RUNTIME < application shortname> .msb


+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDMDGEN: Generate Messages
+---------------------------------------------------------------------------+

Current system time is 10-AUG-2016 15:51:10

+---------------------------------------------------------------------------+

Writing file /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US648412.tmp
Moving file /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US.msb to /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US648412.old.
Moving file /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US648412.tmp to /apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/mesg/US.msb.
Processed a total of 7060 messages
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size:
0

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 10-AUG-2016 15:51:11

+---------------------------------------------------------------------------+


Bounce the Application Tier to see Changes



Why does concurrent program FNDMDGEN: Generate Messages only create message files on the Concurrent Manager tier?

SOLUTION

As per the development guide:
Make a copy of the resulting file (which is on the server side), and transfer the copy to the appropriate mesg directory for your application on other machines as needed (concurrent processing servers, forms server machines). The file should have the same name (such as US.msb) in each location.

The program was never intended to create the message files on all tiers as such manual copying of the files are required as per the guide.

No comments:

Post a Comment