JDE tools 9.1 New Features- EnterproseOne Pages

JD Edwards EnterproseOne tools 9.1 -- new features

How to add the EnterpriseOne Pages:

1.download templates from P982400 .

2.use html designer tools to edit.

3.zip the file to .zip type.

4.Program: P982400 add and upload the file to  Importing.

5.P982405 can setting the user, role, environmental to access the page.

Official docs:

http://docs.oracle.com/cd/E24705_01/doc.91/e24262/admin_design_eone_pages.htm


Official video:

JDE TOOLS 9.1 Creating Tab Pages

OBIEE 11.1.1.6 released & new futures

Oracle BIEE released a new version 11.1.1.6. can download from edelivery.

view the new futures from:http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/whatsnew.htm#CJAEEGJH

also reference
1:http://www.rittmanmead.com/2012/02/obiee-11-1-1-6-now-available-for-download-release-highlights/

2:http://www.peakindicators.com/index.php/knowledge-base/110-new-features-with-obiee-11116


- Support for new browsers: IE9, Chrome 12, and Firefox 6 

Unable to View Log File in OBIEE 11.1.1.5.0 + BI APPS 7.9.6.3

After Install OBIEE 11.1.1.5 + BI APPS 7.9.6.3 , Useing Setting user log level with this site:
http://prasadmadhasi.wordpress.com/2011/12/01/unable-to-view-log-file-in-obiee-11-1-1-5-0/

but when i clicking link "view log" in manager session, obtain this message:  No log found.

check the user session in RPD(Admin tools menu -->manager -->session), the variable:loglevel value is zero, change this variable value set to 2,the log can view.

logging levels Description

Logging Levels	Logging Level Information That Is Logged
Level 0	No logging
Level 1	Logs the SQL statement issued from the client application
	Logs elapsed times for query compilation, query execution, query cache processing, and back-end database processing
	Logs the query status (success, failure, termination, or timeout). Logs the user ID, session ID, and request ID for each query
Level 2	Logs everything logged in Level 1
	Additionally, for each query, logs the repository name, business model name, presentation catalog (called Subject Area in Answers) name, SQLfor the queries issued against physical databases, queries issued against the cache, number of rows returned from each query against a physical database and from queries issued against the cache, and the number of rows returned to the client application
Level 3	Logs everything logged in Level 2
	Additionally, adds a log entry for the logical query plan, when a query  that was supposed to seed the cache was not inserted into the cache, when existing cache entries are purged to make room for the current query, and when the attempt to update the exact match hit detector fails
Level 4	Logs everything logged in Level 3
	Additionally, logs the query execution plan.
Level 5	Logs everything logged in Level 4
	Additionally, logs intermediate row counts at various points in the execution plan.

OBIEE 11g security : users not showing in RPD

When open administration tools , click menu Manage --> Identity , not showing the user created in weblogic server.
search the OTN , find a answer:
on Identity Manager window click menu:action --> set online user filter...  input your user id and ok , the user will showing up.

By the way, create user and group in weblogic console can reference this web address: http://docs.oracle.com/cd/E14571_01/bi.1111/e10543/authentication.htm#CHDEDHEF

HOW TO SUPPORTED THE FIREFOX 10 WITH OBIEE 11G(11.1.1.5)

The firefox browser released new version:10.0 recently, the OBIEE 11G can't display the login page, and prompt: your browser is not supported by oracle bi presentation services.

search the SUPPORT.ORACLE.COM, oracle had released a  patch#12877995 to repair the problem.
DOC ID: OBIEE 11g: Error: "Your browser is not supported by Oracle BI Presentation Services" When Using Firefox 10 Browser [ID 1407163.1]
 
PATCH:12877995 - BROWSERS WITH VERSION GREATER THAN 10 REPORTED AS NOT SUPPORTED

 Also you can use following step with Michal Novy posted a solution on Christians Blog:
 
1. type "about:config" into an address bar
2. right click anywhere and choose New / String
3. name it "general.useragent.override"
4. put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0"
5. refresh OBIEE login screen

Oracle BI Apps 7.9.6.3 and JDE standalone

There are screen snap for BI AND JDE console.

1. BIEE 11g (11.1.5.0) login :

   Port:7001/analytics

 2.BIEE 11g BI APPS DASHBOARD:

3.Enterprise Manager 11g Fusion Middleware control console:
   port:7001/em

4. Oracle Weblogic Server 11g administration console login
   port:7001/console

5.Oracle Weblogic server 11g conslole main

6.JDE EnterpriseOne standalone Menu screen:
PORT:8888/jde

7.Informatica Administrator log in 

port:6007/administrator

8.Informatica Administrator services:

9.Database control Console
prot:1158/em

My JDE AND OBIEE Environmen

This is environmen on my laptop:
My laptop: Toshiba T210
OS: Windows 7 Ultimate 64 bit
Memory:4G
JDE: EnterpriseOne Standalone 9.0
BIEE: Oracle BIEE 11.1.5 (64bit) With BI APPS 7.9.6.3
WEBLOGIC: 10.3.5.0
DB:Oracle 11.2.0.2 (32 bit)
Informatic:9.0.1 hotfix2(32 bit)
DAC:Oracle BI Data Warehouse Administration Console Dac Build AN 10.1.3.4.1.20090415.0146
 A Complete JDE 9.0 Full ETL was successfull. Total tasks is 314.

View JOB's Data Select Sql Script

If check the JOB’s data select  on db server ， you can use following SQL script：
   
    SELECT A.JCUSER,A.JCJOBNBR, JDAUDINFO,B.JCPID,B.JCVERS,A.JCJOBSTS,
     A.JCENHV,A.JCFNDFUF2,B. JCSTDTIM,B.JCETDTIM,
     JDEXEHOST,JDJOBNBR FROM    SVM900.F986110 A
     left join SVM900.F986114 B ON A.JCJOBNBR=B.JCJOBNBR
     LEFT JOIN SVM900.F986114A C ON A.JCJOBNBR=C.JDJOBNBR
     WHERE
     JDEXEHOST = 'JDEDB' AND JDJOBNBR = 5296.000000 AND JDAUDTYP = '02'  ;

Note:

 1. the db of owner ：SVM900， is my JDE environment, you can replace your.

 2. on the WHERE the JDJOBNBR is the JOB number.

 3. JDAUDTYP=’02‘ mean the JOB's data select,  '01':Processing Options , '03':Sorting, '04':Report Interconnect Structure,'05':SQL Scripts

 4. You can use the PL/Sql Developer to run the script , click the column:JDAUDINFO value to see the detail, because the field data type is NCLOB.