I was working on a instance that went live recently.
The environment works with a 10.1.2.0.2 Application server and uses the BI forms engine.
it creates a session at the database on every log in.
On go live, the business folks had a request that was asked to me for the first time.
I was asked to determine all the users who have never logged on to the front end even once after 1 month of go live.
It was a strange request -- how ever, there was a simple query-- here it goes!!
select username from dba_users where user_id not in (select distinct USER_ID from GV_$ACTIVE_SESSION_HISTORY where MODULE like 'frmweb%');
Welcome to my blog
· I have extensively worked on the following technologies/Implementation projects
| · Oracle EBS R12, 11.5.10.2, 11.5.9 o Oracle Applications DBA (AD) o Oracle Financials o Order Management
| · Oracle Retail Suite V12, V13 o Retail Merchandizing system RMS o Invoice matching ReIM o Retail Integration Bus RIB o Retail price manager RPM o Store Inventory Manager SIM o Retail Demand Forecasting RDF o Retail data warehousing RDW o Oracle Internet Directory OID |
| · Oracle SOA Suite o BPEL process manager o Enterprise Service Bus | · Oracle Hyperion Suite o Shared services OSS o Workspace o Planning o Essbase o Enterprise performance management EPM o Financial reporting, Web analysis |
| · Enterprise Batch Scheduler Uc4 Appworx | · Oracle Business intelligence Suite o Answers o Interactive dashboards o BI publisher |
· I am responsible for several Implementations that use the following Oracle middleware products
| · Oracle Weblogic Fusion Middleware web application | · Oracle Weblogic Forms and Reports Server |
| · Oracle Weblogic SOA Suite o BPEL process manager o Oracle Service Bus o Oracle B2B server | · Oracle Business intelligence Suite o BI publisher o Oracle Discoverer 10g |
| · Enterprise Batch Scheduler Active Batch | · Oracle Internet Directory OID |
| · Oracle Connection Manager | · Several Custom applications deployed in Oracle 10g Application servers |
My interest is to make this an arena to share my experiences.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment