JDE Last time user logged in successful

SQL -

select t1.SHUSER User_Name, MAX(t1.SHUPMJ) LastLogin_Date from SY910.F9312 t1, SY910.F98OWSEC t2 where t1.SHEVTYP = '01' and t1.SHEVSTAT = '01' and t2.SCEUSER='01' and t1.SHUSER=t2.SCUSER

GROUP BY t1.SHUSER

Migrate OneView Reporting Repository

Step 1 - Login to current OVR BI Server and gather information -

http://localhost:7001/em

Navigate to Business Intelligence –> coreapplication and click on Scheduler tab here you can find the DataSource and User id for old schemas

 I have taken following notes

Username –> PROD_BIPLATFORM

Password ->  Extract from your notes.

http://localhost:7001/console

Go to Services – Data Source

 

Click on bip_datasource - > Configuration -> Connection Pool

Note down URL.

Repeats same for mds-owsm

 

Step 2 – Run RCU on new Environment

Download  Repository Creation Utility (RCU) from the below link.
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html

Extract and navigate to rcuHome\BIN and double click on rcu.bat and create Schemas