OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Debugging issues in apps

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Debugging issues in apps [message #524296]

Thu, 22 September 2011 14:57

ngaged
Messages: 3
Registered: September 2011

Junior Member

HI all
I have been facing some issues while i was trying to ship confirm using an api.
But the issues i was facing were related to debugging

I have some question and I will be greatly obliged even if i get answer of some and I m posting these
question only after spending more than 14 hours doing research..

q-1 we use fnd_log_messages to check log messages ...
are these different from debug messages that are genrated and written to server
e.g in api
wsh_interface_grp.Delivery_Action
wsh_debug_sv.log is used to generate .. will go the server in a file

i read the following article to clear my doubts ,
oracle.anilpassi/fnd-debug-log-debugging-oracle-apps-code.html
in this its written that oracle has centralised all these
to single table fnd_log_messages.
doesnt these two statements contradict each other

q-2

DECLARE
	vInHandle  utl_file.file_type;
	BEGIN
	vInHandle := utl_file.fopen('DIR2', 'logs.txt', 'w');
	UTL_FILE.PUT_LINE(vInHandle,'sample text');

	IF utl_file.is_open(vInHandle) 
	THEN
	dbms_output.put_line('The File exists');
	Else
	dbms_output.put_line('The File dosent exists');
	END IF;
	END ;

when i try to run this procedure it says 'The File exists'

actually this dir2 corresponds to /tmp on server and i checked permissions and i have read write execute
permission on this directory
but still no file is generated

q-3 For a particular profile
in
select * from FND_PROFILE_OPTION_VALUES
we have two rows corresponding to different level_id and level_value

for 1st row PROFILE_OPTION_VALUE is /tmp
and the other PROFILE_OPTION_VALUE is /u03/tmp

by logging in to oracle apps as sysadmin i changed the value of profile at site level as /tmp

but even then after fnd_global.apps_initialize with same sysadmin
i m getting value /u03/tmp and i want /tmp

Please refer me some documents i m ready to read any no. documents

Thanks

Report message to a moderator

Re: Debugging issues in apps [message #524528 is a reply to message #524296]

Sat, 24 September 2011 10:50

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

q-1Quote:

that oracle has centralized all these to single table fnd_log_messages.

I don't deny on this statement.
But still some of the logs will go to concurrent log or some other file.
It depends on how developer has coded and the need.

q-2
Try to close the file and crosscheck.

q-3Quote:

we have two rows corresponding to different level_id and level_value

What are they?
The value returned is depending on the level.
Site -> Application -> Responsibility -> User.
Value corresponds to the lowest level overrides the value of above levels.
Here User level is the lowest one.
Check this.

As you are new to the forum, please read the following too.
OraFAQ Forum
Oracle Apps Forum Guide

By
Vamsi

Report message to a moderator

Re: Debugging issues in apps [message #524618 is a reply to message #524528]

Sun, 25 September 2011 11:48

ngaged
Messages: 3
Registered: September 2011

Junior Member

thanks vamsi .. it helped me .. the two links given by u helped me ,,ty

Report message to a moderator

Previous Topic:	Ship Confirm unassigns all the lines from delivery
Next Topic:	attendance of temporary workers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 04 09:46:37 CDT 2025