Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 04, 2009 at 12:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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