Oracle E-Business Suite Objects Mapping Between 11i and R12

Oracle E-Business Suite Objects Mapping Between 11i and R12

You can download the Oracle E-Business Suite Objects Mapping Between 11i and R12 files from the following link:

Oracle_E-Business_Suite_Objects_Mapping_Between_11i_and_R12_(11.5.10.2_12.1.3).rar

 

 

 

 

 

 

Advertisements

How to Get Oracle E-Bussiness Suite Tables list

You can use the following select statement to get the Oracle E-Bussiness Suite Tables List for each application:

SELECT A.APPLICATION_ID,
       A.APPLICATION_NAME,
       A.APPLICATION_SHORT_NAME,
       A.DESCRIPTION APPLICATION_DESCRIPTION,
       A.BASEPATH,
       A.PRODUCT_CODE,
       P.TABLE_NAME,
       P.USER_TABLE_NAME,
       P.DESCRIPTION
  FROM FND_TABLES P,
       FND_APPLICATION_VL A
 WHERE A.APPLICATION_ID = P.APPLICATION_ID

Oracle E-Business Suite Show Active Database Sessions Details (Machine, Program, Module, Username, Action,…… )

You can use the following SQL statement to get the full session information (SID, Serial#, Machine, Program, Module, Username, Responsibility,……….).

SELECT S.AUDSID        "AUDSID"  ,
       S.SID           "SID"     ,
       S.SERIAL#       "SERIAL#" ,
       I.INSTANCE_NAME "Instance",
       S.MACHINE       "Machine" ,
       S.TERMINAL      "Terminal",
       S.PROGRAM       "Program" ,
       S.MODULE        "Module"  ,
       S.USERNAME      "Username",
       S.ACTION        "Action"  ,
       S.OSUSER        "OS User" ,       
       S.PROCESS       "Process" ,
       S.STATUS        "Status",
       S.LOGON_TIME    "Logon Time"
  FROM GV$SESSION  S,
       GV$INSTANCE I
 WHERE S.AUDSID > 0
   AND S.INST_ID = I.INST_ID;