trace code in R12
Hi,
Considering the case when in a trace file generated for a form contains a certain SQL statement that it would be useful to know where it comes from. What are the ways, if any, to track it to the application code ?
Or at least is there a way to determine if the code is application native or custom code?
For example:
Release: R12.1.3
RDBMS : Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
Traced form : APXINWKB
SQL statement : UPDATE XLA_EVENTS SET EVENT_STATUS_CODE = :B9 ,PROCESS_STATUS_CODE = :B8 ,
LAST_UPDATE_DATE = SYSDATE ,LAST_UPDATED_BY = :B7 ,LAST_UPDATE_LOGIN = :B6 ,
Considering the case when in a trace file generated for a form contains a certain SQL statement that it would be useful to know where it comes from. What are the ways, if any, to track it to the application code ?
Or at least is there a way to determine if the code is application native or custom code?
For example:
Release: R12.1.3
RDBMS : Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
Traced form : APXINWKB
SQL statement : UPDATE XLA_EVENTS SET EVENT_STATUS_CODE = :B9 ,PROCESS_STATUS_CODE = :B8 ,
LAST_UPDATE_DATE = SYSDATE ,LAST_UPDATED_BY = :B7 ,LAST_UPDATE_LOGIN = :B6 ,
0