For Oracle Applications tracing User/forms to database trace files in user_dump_dest (udump): System Admin > Profile > System At User level set profile option: Initialization SQL Statement - Custom Value:
BEGIN FND_CTL.FND_SESS_CTL('','','TRUE','TRUE','',''); END;
Or if you also want to have the user name in the file name (replace OPERATIONS with your username):
BEGIN FND_CTL.FND_SESS_CTL('','','TRUE','TRUE','','ALTER SESSION SET TRACEFILE_IDENTIFIER = OPERATIONS MAX_DUMP_FILE_SIZE = 5000000 EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'||'''');END;
Voila!
2 comments:
Great! Thanks for sharing! Let me try this query. I hope that it will work great for me..Thanks Gareth!
sap test
INCREDIBLE! It seems like informative blog. I can see there is quite informative topics. I will certainly go for it.
oracle r12 documentation
Post a Comment