XML Publisher in EBS 12.1.3 - is there an XDODTEXE log generated - troubleshooting performance
I have created a concurrent program with executable XDODTEXE to generate XML for a custom process. I can run the data definition query in under a minute using PL/SQL Developer and it returns 30,000 records. When I run it as a concurrent request, it is taking 30 minutes for the request to finish. My DBA looked at the stats for my SID and said the query finished in 17 seconds.
Is there a log somewhere that will tell me what the XDODTEXE is doing for 30 minutes? It is not going to the OPP because I am not applying a template. I just want the raw XML.