![pl sql developer 11.0.3 pl sql developer 11.0.3](https://s3.studylib.net/store/data/006670572_1-287b47e0ad9b85c7499995c1ab052264-768x994.png)
To View Spawned Concurrent Program Source CodeĪll I wanted to know is, how the spawned program-BMCOIN is fetching data, processing it, and inserting into interface tables? Enable trace on the concurrent program. I got the file from server and opened it in note pad. Where do I get techno-functional guide/material for BOM? (Not only for BOM, for any other module.) All I can see is some ASCII characters.Īll I wanted to know is, how the spawned program-BMCOIN is fetching data, processing it, and inserting into interface tables? I would like to analyze an executable (BMCOIN) type "Spawned".
#Pl sql developer 11.0.3 code
It would be great to see the PLSQL code you are using for this concurrent program.Īnalyse/trace a spawned type executable. Ram Can you copy the exception handler code and if possible answer the following questions?ġ.Do you print log messages in the log file, using fnd_file.put_line?Ģ.Do you explicitly set the retcode to 2 somewhere in the code? We are trying to enable tracing on this request, but the request does not fail always. The output file shows the tables being updated and nothing else. It updates certain AR tables and then generates a file that is sent out to external customers via EDI. Shailendra This is a custom program, type : PL/SQL. Hussein can you let us know more about the concurrent jobs like the following detailsġ. Was this working properly before? If yes, what changes have been done recently?ĭid you try to relink the concurrent program executable file and see if this helps? Also, you could enable trace/debug and submit the request again and see if more details are collected in the logs - See (Note: 296559.1 - FAQ: Common Tracing Techniques within the Oracle Applications 11i/R12). Is this a custom or standard concurrent program? Is there anyway to see why this happens ( to see error message somewhere else - like FND tables ?). We have a concurrent program which errors out sometimes without any error message in log file or anywhere else. Concurrent Program ends in Error without any error message - Apps 11.0.3 - General EBS Discussion Hi,