自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

田攀的日志

日拱一卒 | 学习、思考

  • 博客(47)
  • 资源 (13)
  • 论坛 (3)
  • 收藏
  • 关注

原创 SSH Got WARNING: 'POSSIBLE DNS SPOOFING DETECTED'

(ptian) ptian- ssh -l user host_name@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@       WARNING: POSSIBLE DNS SPOOFING DETECTED!          @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

2012-12-31 15:30:16 3022

原创 Form Trigger Sequence Demo Form

Form Trigger太多太庞杂,新手往往很难上手,加上一些Trigger有点偏门,用的比较少,真到想用的时候,又不知道从哪下手。所以之前就有想法写一个Demo Form,用于显示Trigger的执行顺序,今天发现已经有人写过这个东西了,也就不用重造这个轮子了。作者:Francois Degrelle(Oracle ACE)Site:http://sheikyerbouti.developpez

2012-12-31 12:31:33 2578 1

原创 2012年读过的书和看过的电影

书电影(部分书和电影其实很早就看过,只是今年才在豆瓣上勾选上,所以统计也有出入)"阅读DNA"统计,数据来自豆瓣

2012-12-29 00:23:49 2208

原创 frmcmp.sh报FRM-91500

[oracle@bej301441 ~]$ frmcmp.shFRM-91500: Unable to start/complete the build.Reason:frmcmp.sh需要GUI显示,如果通过putty之类的SSH客户端连上服务器的话,无法GUI展示,所以命令会报错。Solution 1:The only catch is when you use frmcmp.sh you n

2012-12-28 16:27:34 3580

原创 How to check Oracle Applications Web Server Version ?

Login Apps Servercd $IAS_ORACLE_HOME/Apache/Apache/bin./httpd -versionOutput:Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-ServerServer built:   Jul  7 2008 14:58:00

2012-12-26 12:07:01 1937

原创 Oracle Forms Versions

IAF 2CharacterNo IDEFastForms+IAG 4Character SQL*Forms25Character SQL*Forms2.35CharacterNew IDE, No PLSQL, User Exits, INP ASCII File, FRM Runtime FileSQL*Forms36CharacterMajor Rewrite, New IDE, PLSQL

2012-12-26 11:03:07 2406

原创 Set_XXX_Property Build-Ins

Build-In List·  SET_APPLICATION_PROPERTY·  SET_BLOCK_PROPERTY·  SET_CANVAS_PROPERTY·  SET_FORM_PROPERTY·  SET_ITEM_PROPERTY·  SET_ITEM_INSTANCE_PROPERTY·  SET_LOV_PROPERTY·  SET_MENU_ITEM_PROPERTY·  S

2012-12-25 18:55:28 7962

原创 [Code Sample]loop trough all records of a block

Sample 1:declare currRec integer;begin -- go to the desired block navigate_to_block('BLOCK_NAME'); -- save the current record position currRec := :system.cursor_record; first_record

2012-12-25 18:14:06 3032

原创 FND: Debug Log Enabled引起的性能问题

客户遇到一性能问题,某EBS功能之前性能还可以接受,但最近突然发现性能非常差。从TKRPOF看到,下边SQL语句执行了上千次,SELECT NVL( SUBSTR( VALUE, 1, INSTR( VALUE, ',')-1), VALUE) FROM V$PARAMETER WHERE NAME = 'utl_file_dir'这条语句基本是写日志前的读取可写日志的目录,然后检查各项Debug

2012-12-25 15:50:45 2618

原创 Oracle EBS Tables

eTRM: etrm.oracle.com"EBS重要表用途与关系介绍.pdf" http://vdisk.weibo.com/s/lt2I-"R12_Table(All Module)_ER.zip" http://vdisk.weibo.com/s/lt8GM"R12_eTRM(多模块).zip" http://vdisk.weibo.com/s/lzfIw"OracleERP表结构.xls"

2012-12-24 11:38:33 4451

原创 11i and R12 Table Count in Different Module

Module 11i Tables R12 Tables New Tables AR 551 616 118 BOM 264 337 73 GL 186 309 140 AP 236 297 73 INV 247 274 33 PO 186 213 33 FA 179 198 19 MRP 174

2012-12-24 11:35:06 2051

原创 Attachments in Oracle Form

默认情况下“附件”按钮是灰显的,本文将展示如何让某个Form的附件按钮变亮,并能上传附件.以用户Form为例,我们想让用户上传自己的照片Pre-SetupsHelp > Diagnostics > Custom Code > Personalize,记录下Function Name并用Help > Diagnostics > Examine查看User Name字段和User ID字段对应的Fie

2012-12-21 13:19:01 3882

原创 Oracle E-Business Suite Benchmarks

Oracle EBS需要什么样的硬件水平,可以参考下我搜集的一些资料ServerOracle R12 E-Business Standard Benchmark Overviewhttp://www.oracle.com/us/solutions/benchmark/apps-benchmark/ebs-standard-benchmark-overview-192676.htmlOracle E

2012-12-19 10:22:14 3675

原创 [Script]Get APPL_TOP and <PROD>_TOP

Get APPL_TOPselect name,       node_id,       path,       shared,       created_by,       creation_date,       last_updated_by,       last_update_date,       FILE_SYSTEM_GUID,       appl_top_guidFROM

2012-12-18 12:32:16 2033

原创 [Script]Get Hierarchy of employee and supervisor hierarchy when a person id provided

SELECT PAAF.SUPERVISOR_ID MGR_ID,      PJ.JOB_ID ,      PAPF.FULL_NAME,      PJ.NAME,      PAPF.PERSON_ID PER_IDFROM PER_PEOPLE_X PAPF,      PER_ASSIGNMENTS_X PAAF,      PER_JOBS PJWHERE PAPF.PERSON_I

2012-12-18 12:15:04 2468

原创 AWR (Automatic Workload Repository) Report

10g引入AWR(Automatic Workload Repository),一个新的性能采集和分析工具。(10g以前使用statspack)AWR可以收集的信息有:Wait events used to identify performance problems.Time model statistics indicating the amount of DB time associated

2012-12-17 19:08:37 5422

原创 awrrpt.sql报错:ORA-00904: : invalid identifier

使用awrrpt.sql来生成AWR Report,脚本运行完毕的时候报下边的错误,select output from table(dbms_workload_repository.awr_report_html( :dbid, * ERROR at line 1: ORA-00904: : invalid identifier 解决方法:需要使用sys或者system用户来执行AWR脚本

2012-12-17 18:35:08 5511

转载 General Ledger Useful SQL Scripts – Oracle Applications 11i

General Ledger Useful SQL Scripts – Oracle Applications 11iContentsGL Set of Books Configuration Overview

2012-12-17 10:40:30 71833

原创 Oracle EBS用户登录情况统计脚本

select distinct d.user_name from apps.fnd_logins a,v$session b, v$process c, apps.fnd_user dwhere b.paddr = c.addrand a.pid=c.pidand a.spid = b.processand d.user_id = a.user_idand (d.user_name =

2012-12-15 19:49:51 4502

转载 Inventory Transfer To GL(11i)

How Inventory Passes Journals To General Ledger (GL)Inventory Transactions transfer to GL normally done by Program called INCTGL.The accounting information related to transactions in INV module is tra

2012-12-15 19:12:50 3072

原创 Period Close Sequence

下图为Oracle EBS关闭期间的时候,各个模块的相互依赖的关系,顺着箭头逐步关闭各模块的期间。比如,Order Management会直接影响应收(Receivables)模块,所以OM模块应先于应收模块关闭。如果图中某个模块没有使用,则可以跳过它,进入下一个模块。每个特定模块期间中,Transactions的账户信息在关闭时最终都会Transfer to General Ledger.所以期

2012-12-15 16:10:27 3868

转载 (V45) Trigger Execution Sequence in Forms 4.5

(V45) Trigger Execution Sequence in Forms 4.5 ============================================= Introduction This document lists the order in which triggers fire in Oracle Forms 4.5:  o The first column,

2012-12-14 12:18:36 2246

原创 INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS

For Interface Transactions,INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS DOES below things:1)validate_group (Validate a group of MTI records in a batch together)2)validate_lines(Validate each record of a b

2012-12-13 11:36:34 10843

原创 Number of Processes(Workers) for Concurrent Manager

一个Concurrent Manager可以调用多个进程(Worker)来同时做事务处理,如何修改Concurrent Manager所能调用的进程数(Worker数)System Admin >Concurrent > Define > Work ShiftsProcesses的数量就是将来Concurrent Manager能够调用的进程数量。更改完后,去Concurrent > Manage

2012-12-12 20:01:29 3024

原创 File/Directory Permission in Unix/Linux

Permission Modes 7 5 5 user group world r+w+x r+x r+x 4+2+1 4+0+1 4+0+1 = 755Read 4 - Allowed to read filesWrite 2 - Allowed to write/modify fileseXecute 1 - Read/write/delete

2012-12-12 15:51:05 7386

原创 Using API FND_PROFILE.save to update profile from backend

SyntaxFND_PROFILE.SAVE(,                  ,                  ,                  ,                  );ExampleSET SERVEROUTPUT ON SIZE 1000000DECLARE l_user_id NUMBER; l_resp_id NUMBER; l

2012-12-12 12:15:55 7825

原创 Step by Step to Define a BI Publisher Report

这里演示一下,开发一个最简单BI Publisher Report的流程,下图为开发的基本流程.Data Template(.xml) 作为Data Source,用于数据源的定义,以及取数的SQL语句;Template(.rtf) 用于定义输出展示(Layout); (RTF:Rich Text Format)1.首先创建一个Demo数据CREATE TABLE demo_products(

2012-12-11 19:54:52 3736

原创 BI Publisher Error:自动化(Automation)错误

安装完BI Publisher之后,然后试图在Word中打开BI Publisher的插件,报:自动化(Automation)错误(Automation Error)这个错其实不是BI Publisher的问题,而是Word的问题。解决方法:The solution is to unregister and re-register the C:\Windows\System32\MSCOMCTL.

2012-12-11 18:26:25 3274

原创 Oracle BI Publisher

Oracle BI Publisher以前叫XML Publisher,这里'BI'为'Business Inteligence'Wiki:Oracle BI PublisherOracle XML Publisher (XMLP) is Oracle Corporation's latest reporting technology. It was originally developed to

2012-12-11 17:56:56 5893

原创 美国IT服务公司-IT服务收入

微博上看到的,转载记录下IBM把服务这块做的确实是好

2012-12-11 14:52:24 2926

原创 [Index]Null值和索引

Index是不存储NULL值的,所以如果你有NULL的条件在SQL中,那么相关的索引是用不到的。CREATE TABLE PTIAN1 AS (SELECT * FROM DBA_OBJECTS);CREATE INDEX PTIAN_INDEX ON PTIAN1(DATA_OBJECT_ID);EXEC DBMS_STATS.GATHER_TABLE_STATS('APPS','PTI

2012-12-11 12:31:20 2007

原创 Receiving Module Data Flow

Basic Data Flow in ReceivingPO Receipt for Inventory destinationPO Receipt for lot controlled itemsPO Receipt for serial controlled itemsInterorg Transfer Receipt – In transit Shipment Interorg Transf

2012-12-11 10:54:51 3592

原创 [Index]组合索引(Composite Index)中多个字段的顺序

一个表中有三个字段,XX,YY,ZZ,如果要建立给这三个字段建组合索引(Composite Index),组合索引中字段的顺序应该遵循怎样一个原则。一般的原则:越离散的字段越靠前。哪个列可以降低索引的扫描成本就放在前面。比如:下位三个字段的离散情况XX:2YY:1000ZZ:50000那么建立索引的顺序应该为:ZZ,YY,XXCREATE INDEX t_idx ON t (zz,yy,xx);但

2012-12-10 19:08:22 13593

原创 Oracle Supported Languages

对于EBS可以查询:SELECT TERRITORY_CODE,TERRITORY_SHORT_NAME,DESCRIPTION FROM FND_TERRITORIES_VL;语言缩写(abbr)和对应的语言Language NameLanguage AbbreviationDefault SortAMERICANusbinaryARABICarARABICASSAMESEasbinaryAZE

2012-12-10 12:34:25 1830

原创 V$SQL,V$SQLAREA,V$SQLTEXT

V$SQL*表用于查看Shared SQL Area中SQL情况V$SQLTEXTV$SQLTEXT用途很简单,就是用来查看完整的SQL语句,V$SQL和V$SQLAREA只能显示1000 bytes,且特殊字符用空格替代。This view contains the text of SQL statements belonging to shared SQL cursors in the SGA

2012-12-07 16:04:23 4495

原创 DBA_SEGMENTS - 查看数据库对象所分配的物理存储空间

如何查看某个数据库对象(TABLE, INDEX ....)所占得物理存储空间SELECT SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME,EXTENTS,BLOCKS,BYTES/1024/1024/1024  GBFROM DBA_SEGMENTS WHERE SEGMENT_NAME = Upper('MTL_MATERIAL_TRANSACTIO

2012-12-07 11:40:28 17881

原创 SQLT(SQLTXPLAIN)

SQLT也叫SQLTXPLAIN,如果某一条SQL执行效率很低,也不知道从哪里下手,可以使用SQLT来收集和性能相关的各种信息(如:Execution plans, Cost-based Optimizer CBO statistics, Schema objects metadata, Performance statistics, Configuration parameters...)一般情

2012-12-06 19:51:13 5032

原创 Using the this API wsh_deliveries_pub.Delivery_Action to ship confirm for the delvery

CREATE OR REPLACE procedure cc_shippingasl_return_status VARCHAR2(2000);l_msg_count NUMBER;--l_msg_data VARCHAR2(1000);pp_init_msg_list VARCHAR2(10) := FND_api.G_FALSE;pp_return_values VARCHAR2

2012-12-06 18:48:56 6751

原创 SAMPLE SCRIPT TO CREATE SALES ORDER USING OE_ORDER_PUB.PROCESS_ORDER

Use Of Oe_Order_Pub.Process_Order To Create Sale OrderProcess Order API is a PL/SQL packaged procedure which can be used to manipulate the sales order data by performing Insert, update or delete opera

2012-12-06 18:35:56 9846

原创 TRANSACTION_HEADER_ID & TRANSACTION_BATCH_ID & TRANSACTION_BATCH_SEQ

MTL_TRANSACTIONS_INTERFACE和MTL_MATERIAL_TRANSACTIONS_TEMP有三个类似的字段:TRANSACTION_HEADER_ID & TRANSACTION_BATCH_ID & TRANSACTION_BATCH_SEQ以下为eTRM里关于这三个字段的解释:TRANSACTION_HEADER_ID:Transaction group identif

2012-12-05 22:17:35 3929

深入浅出Oracle EBS之核心功能(FIN)

深入浅出Oracle EBS之核心功能(FIN)

2012-04-06

Upgrading Oracle Applications

Upgrading Oracle Applications

2012-04-12

Form Personalization(Form个性化)

Oracle EBS Form Personalization(Form个性化)

2012-04-12

Extent Oracle Applications Release 11

Extent Oracle Applications Release 11

2012-04-12

Oracle_BIEE实例详解

Oracle_BIEE实例详解,深入浅出系列

2012-04-06

深入浅出Oracle EBS之核心功能(DIS)

深入浅出Oracle EBS之核心功能(DIS)

2012-04-06

深入浅出Oracle EBS之全模块设置详例

深入浅出Oracle EBS之全模块设置详例

2012-04-06

深入浅出oracle ebs之核心功能(mfg)

深入浅出oracle ebs之核心功能(mfg)

2012-04-06

深入浅出Oracle EBS之FINDISMFG应用模块

深入浅出Oracle EBS之FINDISMFG应用模块

2012-04-06

深入浅出Oracle EBS之Discoverer实例详解

深入浅出Oracle EBS之Discoverer实例详解

2012-04-06

深入浅出Oracle EBS之 workflow

深入浅出Oracle EBS之 workflow

2012-04-06

Beginning_Oracle_Form_Builder

Beginning_Oracle_Form_Builder

2012-04-12

Oracle_EBS_系统安装与维护(深入浅出)

Oracle_EBS_系统安装与维护(深入浅出)

2012-04-06

复杂问题的调试

发表于 2013-05-29 最后回复 2013-05-29

'企业开发'大板块下有SAP子版块,但为什么没有Oracle的企业开发子模块?

发表于 2013-02-22 最后回复 2013-02-25

博客上传图片:“您的空间已满”

发表于 2012-11-23 最后回复 2012-11-26

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人 TA的粉丝

提示
确定要删除当前文章?
取消 删除