Oracle Applications DBA 基础（第二期）Week 06 exercise

本文主要是介绍Oracle Applications DBA 基础（第二期）Week 06 exercise，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

1。尝试创建一个 responsibility ，　可以参考 "system administrator" 这个responsibility 的定义。
用SQL 语句列出你创建的responsibility的名字。

SQL> col RESPONSIBILITY_NAME for a50
SQL> select RESPONSIBILITY_NAME,CREATION_DATE from fnd_responsibility_vl where RESPONSIBILITY_KEY='XX_SYSTEM_ADMINISTRATOR';

RESPONSIBILITY_NAME CREATION_
-------------------------------------------------- ---------
XX System Administrator 17-MAR-14

SQL>

--EOF--

2。"Viewer:text" user profile option 是控制什么的？当前值是什么？　
在Oracle Applications 里面怎么查看？在数据库里面怎么查看？
试改动这个值看影响什么。

"Viewer: Text"控制使用浏览器还是内置的report viewer来查看报表.

在Oracle Applications里面可通过N:System Administrator - Profile > System/Personal来查看.

数据库里可过fnd_profile.value函数或者SQL查看:

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

FND_PROFILE.VALUE('EDITOR_CHAR')
--------------------------------------------------------------------
browser

SQL> SELECT fpov.LEVEL_ID
2        ,fpov.LEVEL_VALUE
3        ,fpov.profile_option_value
4        ,fpo.PROFILE_OPTION_NAME
5 FROM   fnd_profile_option_values fpov
6        ,fnd_profile_options fpo
7 WHERE      fpov.PROFILE_OPTION_ID = fpo.PROFILE_OPTION_ID
8         AND fpov.LEVEL_ID = 10001 --site
9         AND fpo.PROFILE_OPTION_NAME = 'EDITOR_CHAR';

LEVEL_ID LEVEL_VALUE PROFILE_OPTION_VALUE                               PROFILE_OPTION_NAME
---------- ----------- -------------------------------------------------- ----------------------
     10001           0 browser                                            EDITOR_CHAR

SQL>

如果把这个值为"text",则点击"View Output"或者"View Log"后,将启动内置的form窗口(report viewer)来查看内容,但仍可以通过Tools->Copy File来显示到浏览器.

参考:

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

--EOF--

３.　在 gl_code_combinations 表中，那些域是可用作 key flexfield, 那些域是 Oracle applications 表都会有的？

SEGMENT1 ~ SEGMENT30可作key flexfield.

LAST_UPDATE_DATE,LAST_UPDATED_BY是Oracle applications表都会有的.

KFF:

The key flexfield columns in this table include thirty SEGMENTn columns, the CODE_COMBINATION_ID column, and the CHART_OF_ACCOUNTS_ID column (structure column).

WHO Column:
LAST_UPDATE_DATE and LAST_UPDATED_BY columns provide information for the Who feature.

DFF:
The ATTRIBUTEn and CONTEXT columns belong to a descriptive flexfield

Special FF:
and the SEGMENT_ ATTRIBUTEn columns belong to a special flexfield used by the Oracle Public Sector Financials products

参考：

Key Flexfield Views Examples
http://docs.oracle.com/cd/A60725_05/html/comnls/us/fnd/flexvi07.htm

--EOF--

这篇关于Oracle Applications DBA 基础（第二期）Week 06 exercise的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！