<<Oracle Applications DBA 基础（第二期）>>Week 09 exercise

1. 下载 Oracle workflow client 2.6.3.5, 设计一个简单的 workflow process 并上载到 ＥＢＳ上运行。
并在 sqlplus 上列出 你的 workflow process 运行过 的记录 ( hint:　相关的WF_ 表）

Download wf client from :

Oracle Workflow Client Release 2.6.3.5 for Microsoft Windows
http://www.oracle.com/technetwork/database/options/winclient-101059.html

wf运行记录:
-bash-3.2$  cd $FND_TOP/sql
-bash-3.2$ sqlplus apps/apps @wfstatus.sql

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Mar 26 19:17:13 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Enter value for 1: MYWFDEMO
Enter value for 2: MYWFDEMO_001
**** WorkFlow Item

Item Type  Item Key        Begin Date         End Date           Activity
---------- --------------- ------------------ ------------------ ---------------------------------------------
MYWFDEMO   MYWFDEMO_001    26-MAR-14 19:09:02 26-MAR-14 19:09:02 MYWFPROCESS

**** Activity Statuses

Begin Date         Activity                                      Status   Result          User
------------------ --------------------------------------------- -------- --------------- ---------------
26-MAR-14 19:09:02 ROOT/my wf process                            COMPLETE #NULL
26-MAR-14 19:09:02 my wf process/Start                           COMPLETE #NULL
26-MAR-14 19:09:02 my wf process/End                             COMPLETE #NULL

**** Errored Activities

no rows selected

*** Error Process Activity Statuses

no rows selected

**** Error Process Errored Activities

no rows selected

**** Attribute Values

Attribute Name                 Value
------------------------------ ------------------------------
#SCHEMA                        APPS
.ADMIN_KEY                     191093547499382052000840334587
                               289665058

.MONITOR_KEY                   118322016317057695135788844168
                               293191100



Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-bash-3.2$

--EOF--

2. 对应你的 EBS 版本 （12.1.1 或 12.1.3) , 下载相应的 Jdeveloper ,安装并做一个 简单的 OA HTML page 并发布到 EBS 上去运行。
如果你不熟悉 Java 语言的话， 可以不用修改 与 controller 相关的 method。
请列出你的程序发布到 $JAVA_TOP 上的目录的内容 。 请在 sqlplus 上列出 你发布到 数据库 MDS 上的 XML page 的内容。
（hint： 参考课程资源中的 Demo create R12 OAF program.txt 和 联机帮助 file:///C:/jdevoaf/jdevdoc/WebHelp/toolbox/toolbox.htm 中的Hello World例子）

$JAVA_TOP目录下的内容:

[appldev@oel57dev webui]$ pwd
/u01/apps/apps_st/comn/java/classes/oracle/apps/ak/hello/webui
[appldev@oel57dev webui]$ ls -l
total 8
-rw-r--r-- 1 root root 1325 Apr 10 22:41 HelloWordPG.xml
-rw-r--r-- 1 root root 1734 Apr 10 22:41 HelloWorldMainCO.class
[appldev@oel57dev webui]$

数据库MDS上的XML page内容:

SQL> exec JDR_UTILS.listContents('/oracle/apps/ak/hello',true);
Printing contents of /oracle/apps/ak/hello recursively
/oracle/apps/ak/hello/webui/HelloWordPG

PL/SQL procedure successfully completed.

SQL> exec JDR_UTILS.listContents('/oracle/apps/ak/hello/webui/',true);
Printing contents of /oracle/apps/ak/hello/webui/ recursively
/oracle/apps/ak/hello/webui/HelloWordPG

PL/SQL procedure successfully completed.

SQL> exec JDR_UTILS.printDocument('/oracle/apps/ak/hello/webui/HelloWordPG');
<?xml version='1.0' encoding='UTF-8'?>
<page xmlns:jrad="http://xmlns.oracle.com/jrad"
xmlns:oa="http://xmlns.oracle.com/oa" xmlns:ui="http://xmlns.oracle.com/uix/ui"
version="10.1.3_1268" xml:lang="en-US"
xmlns:user="http://xmlns.oracle.com/jrad/user"
xmlns="http://xmlns.oracle.com/jrad"
file-version="$Header$">
<content>
<oa:pageLayout id="PageLayoutRN" windowTitle="My OAF Window" title="My OAF
Title"
amDefName="oracle.apps.fnd.framework.toolbox.tutorial.server.HelloWorldAM"
controllerClass="oracle.apps.ak.hello.webui.HelloWorldMainCO">
<ui:corporateBranding>
<oa:image id="corporateBrandingImage" source="/OA_MEDIA/FNDSSCORP.gif"/>
</ui:corporateBranding>
<ui:contents>
<oa:contentContainer id="MainRN">
<ui:contents>
<oa:messageTextInput id="HelloName" prompt="Please enter your name" columns="20"
maximumLength="50"/>
<oa:contentContainer id="ButtonLayout">
<ui:contents>
<oa:submitButton id="Go" text="Go" prompt="Go"/>
</ui:contents>
                  </oa:contentContainer>


</ui:contents>
            </oa:contentContainer>
         </ui:contents>


</oa:pageLayout>
   </content>
</page>



PL/SQL procedure successfully completed.

SQL>


测试页面, 部署在R12.1.1上:

--EOF--

3. "ICX:Session Timeout" profile setting 是控制什么的？default value 是什么 ？
试修改以证明你的意见。 有人说，这个profile 设得过大，会占用过多 JVM resources ，导致 ‘out of memory’ errors ？

请根据这周的内容 发表你的看法 ( hint: State Architecture PPT)．

ICX: Session Timeout作用:
This profile option determines the length of time (in minutes) of inactivity in a user's session before the session is disabled. If the user does not perform any operation in Oracle E-Business Suite for longer than this value, the session is disabled. The user is provided the opportunity to re-authenticate and re-enable a timed-out session. If re-authentication is successful, the session is re-enabled and no work is lost. Otherwise, Oracle E-Business Suite ends the session without saving pending work. 

http://docs.oracle.com/cd/E18727_01/doc.121/e12894/T202991T202995.htm

ICX: Session Timeout default value:

SQL> select fnd_profile.value('ICX_SESSION_TIMEOUT') from dual;

FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')
--------------------------------------------------------------------------------
30

SQL>

ICX: Session Timeout 过大会不会导致OOM错误:

ICX: Session TImeout 过大不一定导致OOM错误, 如果系统能承载足够多的用户数, 即可以承担所有人同时登录的负载, 那么ICX: Session TImeout 再大也无所谓;

反之,如果用户数过多,系统只能承载其中一部分,那么适时timeout一部分idle用户有利于减轻负载,这种情况下ICX: Session TImeout 过大可能会导致OOM错误.

--EOF--