Oracle session: what is the meaning of ACTION set by SAP BI 7.0 ?

[Former Member]

Hi Experts,

wonder what the ACTION code means?

It's set in the ORACLE session by SAP BI 7.0 using the Oracle dbms_application_info package.

MODULE                                  ACTION
-----------------------------------------------------------------------
CL_SQL_STATEMENT==============CP	383
ZYYYYYYYYY=================CP	303
CL_SQL_STATEMENT==============CP	383
CL_RSODSO_ACTIVATE_REQUESTS===CP	1833
CL_SQL_STATEMENT==============CP	383
CL_SQL_STATEMENT==============CP	383
brconnect@xxxx (TNS V1-V3)	
CL_SQL_STATEMENT==============CP	383

bye

yk

[Former Member]

This looks interesting, i guess this is just a reflection of the ACTION column of the V$SESSION view. It looks like SAP does set certain actions (calling dbms_application_info.set_action). This can be used to simplify tracing and debugging.

I was not aware this is used at all in the SAP world so far.

Cheers Michael

[Former Member]

Looks like it is not only happening in BI, i just called a SE16 in a ERP 6.0 system on table MARC. This is what i get:

SQL> select sid, module, action, client_info from v$session where module like '%MARC%'

  SID MODULE                         ACTION     CLIENT_INFO
----- ------------------------------ ---------- ------------------------------
   74 /1BCDWB/DBMARC                 1182       0

So SAP is setting the module and action, probably somewhere in the opensql interface. If i find time, i will try to get some more information on that.

Cheers Michael