How to track User activity in Oracle Application - EBS R12 / Query to audit user activity on Oracle Forms

 

Track User activity in #Oracle Application - #EBS R12 / Query to #Audit user activity on #Oracle #Forms


How to Audit User Activity in Oracle Database

*---------------------------------------------------------------*

Pre-requisite:

Set the Profile option "Sign-On:Audit Level" = 'Form'

This profile option can be enabled at Site level or any specific user.

It will populate the data in below tables:

FND_LOGINS

FND_LOGIN_RESPONSIBILITIES

FND_LOGIN_RESP_FORMS

SQL Query

Run below #SQL query to extract the user activity details on #ERP application:

"SELECT frtl.RESPONSIBILITY_NAME , fft.USER_FORM_NAME , flf.START_TIME, flf.END_TIME

  FROM FND_LOGIN_RESP_FORMS flf,

       FND_LOGINS fl,

       FND_LOGIN_RESPONSIBILITIES flr,

       FND_RESPONSIBILITY_TL FRTL,

       FND_FORM_TL fft

 WHERE     FLf.LOGIN_ID = FL.LOGIN_ID

       and FLR.LOGIN_ID = FL.LOGIN_ID

       and FLR.LOGIN_ID = FLF.LOGIN_ID

       and FLF.FORM_ID = FFT.FORM_ID

       and flf.LOGIN_RESP_ID = flr.LOGIN_RESP_ID

AND FLR.RESPONSIBILITY_ID = FRTL.RESPONSIBILITY_ID

       AND FL.USER_ID = 6199

       and FLF.LOGIN_ID = 35313895"

*----------------------------------------------------*

#Oracle #EBS # R12 #ERP

Comments

Post a Comment

Popular posts from this blog

How to restrict user to create Purchase Order (PO) without Purchase Requisition (PR) in Oracle / Auto Create PO in Oracle EBS R12

Image
Restrict Creation of #PO without a #P R Sometimes Businesses do not allow a #PO to be created manually. There are several ways through which we can restrict the creation of #PO without a requisition in #Oracle #EBS #R12. The blog discusses two different methods to achieve this goal. Introduction:  At times, businesses necessitate a requisition as a prerequisite for generating a #Purchase_Order (#PO). This blog will enlighten you on the procedure to prevent users from creating a #PO without a corresponding requisition. In #Oracle Purchasing, there are two methods for #PO creation: • Manual creation via the #Purchase #Order form. • Automatic creation from a requisition through the Autocreate function. There are instances where manual creation of a PO is not permissible. In #Oracle #EBS, there are two distinct approaches to enforce the restriction on creating a #PO without a linked requisition: Option 1 Employing form personalization on the #Oracle Purchasing form, speci...
Read more

Oracle Fusion Smart View Setup Guide — Install, Configure & Run Ad Hoc Analysis in Excel

Image
  How to Configure Oracle Fusion Smart View in Excel — Step-by-Step If your organization uses  Oracle Fusion Cloud  and you want powerful ad hoc reporting inside Excel,  Oracle Smart View  is the recommended add-in. This guide walks through installation, configuration, connection, and performing Ad Hoc Analysis with Smart View — with actionable screenshots and the exact  Smart View URL  pattern to use. Why use Smart View? (Benefits) Work with  real-time Oracle Fusion data  directly in Excel. Create flexible  Ad Hoc Analysis  and financial reports without manual exports. Seamless drill-down to Oracle Essbase and Cloud ERP data for fast decision making. Prerequisites Valid Oracle Fusion Cloud credentials with access to reporting tools. Microsoft Excel (supported version for Smart View add-in). Network access to your Oracle Fusion instance endpoint. Step 1 — Download Smart View from Oracle Fusion Log in to Oracle Fusion Cloud as an adm...
Read more