EXCEL VLOOKUP 函数

2. SQL NOT IN 函数

REF:

D51WKDMP.EXE CAUSE MEM_BAD_POINTER ERROR

EUL(end user layer)是什么：

• 提供了一个为了方便最终用户对数据进行展现、分析而准备的直观的、基于业务内容的表示层，使得数据的物理存储对于最终用户来说是透明的不需考虑的；
• 是一种元数据，其内容包含了一或多个业务区域(business area)，每个业务区域，都是一个反映最终用户特定方面(主题)的业务需求的一系列表/视图的组合。在业务区域里，按folder/item形式来组织；
• 通过discoverer administrator来创建和维护；

初玩oracle discoverer 的一系列产品，没有搞清楚他们之间的关系。

想浏览awm建立的aw时，下了一个discoverer desktop，结果怎么都弄不好，仔细看了下文档，才发现是搞错了。于是理了理这些产品及之间联系。

Oracle Discoverer架构有2层和3层之分
2层：DB+Discoverer admin/Desktop
3层：DB+Discoverer Service ＋Discoverer 4iPlus/Viewer如果学习，可以采用2层架构，安装比较方便，服务器端基本上不用设置，在本地安装Discoverer admin和Desktop就能可以了。不过如果要通过Oracle APP方式使用Discoverer，需要升级倒 V4.1.45 ,Patch Number(2635824).

10g在功能上与4i差不多. oracle ERP系统一般选择discover4i的原因, 是ERP应用层本身就有discover 4i服务, 直接启用就可以使用 discover plus(Web访问) , 不需要再安装一个oracle AS10g

到目录: .../app/testora/8.0.6/discwb4/util启动scripts: startall.sh
11.5.10直接启动, 11.5.8要改两个参数, 用discoverer4i 搜索metalink。
plus : http://xxxx.com:8001/discwb4/html/english/ms_ie/welcome_ie.htm
viewer : http://xxxx.com:8001/discoverer4i/viewer?

方法 1, 2, 3

Column '<column1 name>' references column '<column2 name>', which has incompatible frequency.

Cause: A column in your data model references another column (e.g., in the Formula field) in your data model, but the two columns are assigned to

incompatible groups. For example, if a formula column with a Group of Report referenced a column with a Group of G_Emp, this error would be raised.
Action: Remove the column reference, or assign the referencing column to a group that is compatible with the group of the referenced column.

REP-1216:解决方法

I got the solution from the metalink.
I just brought the frame which needs to be set as last page out of the
parent repeating frame and its working now as required.

Cheers,
Piyush



>
> You can also check with the following solutions from Metalink:
>
> SOLUTION DESCRIPTION:
> >
> Objects in the margin region are restarted on every physical page. As a
> result, not all print condition types make sense for margin objects.
> Because
> objects are restarted on every page, it is as if you are always on the
> first
>
> page of the object.
>
> The print condition FIRST is the same as the print condition ALL.
>
> The print conditions LAST and ALL BUT LAST are invalid because "LAST" is
> never
> reached.
>
> The print condition ALL BUT FIRST causes the object to never appear
> because
> the object never goes beyond "FIRST" page.
>
> Thus, the only valid print conditions for the object are FIRST and ALL.
>
>
> **************************************************************************************
>
> *How to create a Reports with a frame displayed only at the bottom of
> the last page.*
> --------------------------------------------------------------------
>
> To display a frame only on the last page of a "repeating frame" the
> properties "Print Object On" and "Base Printing On" must be used.
>
> The frame to be displayed only on the last page should be anchored to the
> repeating frame and the properties "Print Object On" and "Base Printing
> On"
> should be set like this:
>
>
> Print Object On : Last Page
> Base Printing On : Anchoring Object
>
>
> The frame to be displayed only on the last page should NOT be included
> in the frame it is anchored to, else an error :
>
> REP-1216 : xxx has an illegal print condition
> Hope this info will help you....
>

1.CTL FILE date 必须加 date

2.Commit point reached-> 查看log
Record 2: Rejected - Error on table XX_CATALOG_SETUP_H_IFACE, column CATALOG_NUMBER.
Field in data file exceeds maximum length
实际VARCHAR2 (30), 而数据只有 6
一定要用EXCEL 另存为...CSV,不要手动改后缀名

3. register sql load
select '/$XX_TOP/1.0.0/bin/catalog_setup_headers.csv' from dual
4.CONTROL 文件设置

infile '$XX_TOP/bin/catalog_setup_headers.csv'

**Starts**29-12-2006 16:07:21
FDPSTP 中出现 ORACLE 错误 6502

原因：由于 ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1
, FDPSTP 失败。

出现错误时执行的 SQL 语句为: SELECT R.Conc_Login_Id, R.

CVS是一个C/S系统，多个开发人员通过一个中心版本控制系统来记录文件版本，从而达到保证文件同步的目的。

If you put most of your code in packaged PL/SQL procedures, and then call those
procedures from your triggers, you will have modular form code that is easy to develop and maintain.

Be sure to group these smaller procedures into logical packages so their purpose is clear.
--尽量使用小的而且逻辑清楚的procedure.

Server–side
Server–side is a term used to describe PL/SQL procedures that are
stored in an Oracle database (on the database server).

Client–side
Client–side is a term used to describe PL/SQL procedures that run in
programs that are clients of the Oracle database, such as Oracle Forms,
Oracle Reports, and libraries.

concept of chapter1,2,3

overview of coding standards

set up your applications framewok

building your database objects

Handlers:
oracle applications group of packaged procedure called handlers. to organize pl/sql in forms so that is it easier to develop , maintain and debug.

CBO :Oracle cost-based optimization
RBO :Rule-based optimization
WHO: Record history (who ?) the WHO report feature reports the information who created or updated rows in oracle applications table

编辑reports 的data model 时候出现ORA-24323，本来在toad 里面sql脚本一点问题没有啊！

ORA-24323: value not allowed

Cause: A null value or a bogus value was passed in for a mandatory parameter.

Action: Verify that all mandatory parameters are properly initialized.

 查看全文

用reports写简体的不报表如果设置成Ameircan_America.utf8 会乱码的！！！