activate trace on a request

[latifa]

Hi Erman,

Can we activate trace on a request when there is a trigger on it.


Regards,
Latifa

NB: I hope you took a good rest duriing your vacation :)

[ErmanArslansOracleBlog]

Thanks Latifa :) It was a good long weekend :)

What you mean by trigger? Trigger on where?
What kind of trigger? (DDL, DML?)

For concurrent-specific db level problems, apps DBAs can use the
Enable Trace check box present in the Concurrent Program definition form (navigation: Concurrent ➤
Program).

[latifa]

Hi Erman,

Thank you for your reply.

That's what I asked the user to do: look for the program and check the box: enable trace. But when the user want to do it, a message came back saying that there is Trigger on that program !! I'll ask the user to take a screenshot.

Regards,
Latifa

[ErmanArslansOracleBlog]

Okay send me that screenshot once you get it..

[latifa]

Hi Erman,

Here you are the screenshot.

RErrorMessage.docxegards
Latifa

[ErmanArslansOracleBlog]

Please send it as a Picture. (JPEG or png)

[latifa]

please find the file

error.png

Thanks in advance,
Regards,

[ErmanArslansOracleBlog]

Recompile the forms (related form I mean) and retest.. But it is better to make it in a clean way.
This is a form level trigger bytheway.

You can take the following actions and retry..

1)stop apps tier
2)stop db tier
3)start db tier
4)recompile FND_CONCURRENT_PROGRAMS_PKG
5)recompile problematic form
6)start apps tier
7)retest