Home » SQL & PL/SQL » SQL & PL/SQL » Disable FND_FILE.PUT_LINE(FND_FILE.LOG (12.0.1.2)
Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676146] Thu, 16 May 2019 07:15 Go to next message
vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad
Member
Hello All,

Is there a way to disable the below function for a specific package:

FND_FILE.PUT_LINE(FND_FILE.LOG,'XYZ');

Thanks,
Vaibhav
Re: Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676147 is a reply to message #676146] Thu, 16 May 2019 07:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
vaibhav15211 wrote on Thu, 16 May 2019 05:15
Hello All,

Is there a way to disable the below function for a specific package:

FND_FILE.PUT_LINE(FND_FILE.LOG,'XYZ');

Thanks,
Vaibhav

just remove the line from the package
Re: Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676148 is a reply to message #676147] Thu, 16 May 2019 08:11 Go to previous messageGo to next message
vaibhav15211
Messages: 38
Registered: August 2012
Location: Hyderabad
Member
There are almost 500 utterances of this statement across 5 custom packages and 2 Oracle APIs and it is generating more than 200k lines of log which is increasing the execution time of concurrent program exponentially. Now I know it is unfortunate and a bad coding practice but here is where I am stuck. The codes have been written way back a decade ago and now performance is the issue.

Thus I am looking for a way to disable this FND_FILE.PUT_LINE(FND_FILE.LOG,'XYZ')statement if there is any.
Re: Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676149 is a reply to message #676148] Thu, 16 May 2019 08:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
vaibhav15211 wrote on Thu, 16 May 2019 06:11
There are almost 500 utterances of this statement across 5 custom packages and 2 Oracle APIs and it is generating more than 200k lines of log which is increasing the execution time of concurrent program exponentially. Now I know it is unfortunate and a bad coding practice but here is where I am stuck. The codes have been written way back a decade ago and now performance is the issue.

Thus I am looking for a way to disable this FND_FILE.PUT_LINE(FND_FILE.LOG,'XYZ')statement if there is any.

a quick EDIT of the 5 packages should be able to comment out this line in under 10 minutes at 2 minutes per package.

I assume that simply returning NULL from the function is not acceptable since it is likely used in other packages.

The choice is yours. Pick your poison.
Re: Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676150 is a reply to message #676146] Thu, 16 May 2019 08:36 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
FND_FILE is I believe an oracle supplied package that comes with oracle apps.

To have it not run from certain places you would probably have to hack the package code so that it does a call stack check.
Hacking the package code probably isn't even possible.

You'll be far better off just changing the calling package to remove the calls to fnd_file.
Re: Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676151 is a reply to message #676149] Thu, 16 May 2019 10:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
a quick EDIT of the 5 packages should be able to comment out this line in under 10 minutes at 2 minutes per package.
Using a simple "sed" command it can be done in less than a single minute. Smile

Re: Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676160 is a reply to message #676151] Fri, 17 May 2019 15:08 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
Michel Cadot wrote on Thu, 16 May 2019 11:57

Using a simple "sed" command it can be done in less than a single minute. Smile

Unless package is wrapped as most Oracle supplied packages are Smile

SY.
Re: Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676161 is a reply to message #676160] Fri, 17 May 2019 15:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Solomon Yakobson wrote on Fri, 17 May 2019 13:08
Michel Cadot wrote on Thu, 16 May 2019 11:57

Using a simple "sed" command it can be done in less than a single minute. Smile

Unless package is wrapped as most Oracle supplied packages are Smile

SY.
OP said, "There are almost 500 utterances of this statement across 5 custom packages"
They are NOT Oracle supplied code.
Re: Disable FND_FILE.PUT_LINE(FND_FILE.LOG [message #676164 is a reply to message #676160] Sat, 18 May 2019 00:33 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Solomon Yakobson wrote on Fri, 17 May 2019 22:08
Michel Cadot wrote on Thu, 16 May 2019 11:57

Using a simple "sed" command it can be done in less than a single minute. Smile

Unless package is wrapped as most Oracle supplied packages are Smile

SY.
McUnwrap Wink

Previous Topic: write to the file from PL SQL
Next Topic: Error: ORA-00980: synonym translation is no longer valid
Goto Forum:
  


Current Time: Thu Mar 28 12:39:38 CDT 2024