ITPub博客

UploadWFLOAD <apps/pwd>@<connect_string> 0 Y {UPLOAD | UPGRADE | FORCE} <file_name.wft>把工作流文件(wft文件)上传到数据库中Example:-WFLOAD apps/apps@instance 0 Y UPLOAD ABCDEFG.wftDifferent “Upload Modes” applicable to WFLOADUPLOAD  - Honors only protection level of data [No respect of Customization Level]UPGRADE – Honors both protection and customization levels of dataFORCE   - Force upload regardless of protection or customization level注

目标：通过Oracle Workflow做一个简单的请假申请工作流，效果：经理接到流程后，可以Approve，也可以Reject。File > Quick Start WizardItem Type名字取得不好，让人不好理解，实际上Item Type可以就理解为工作流程序，一个Item Type下边，有一个或者多个Process，Process是工作流的核心。Persistence Type:Permanent:产生工作流信息永久性的保存，不会被清除掉，很少有流程要设置成permanentTemporary:工

Here is the list of important events that took place in the last 30 years of Oracle history. Oracle is celebrating its 30 wonderful years in the industry (from 1977 to 2007). This article was updated on 6th August, 2007.In 1977, Larry Ellison, Bob Miner and Ed Oates founded Software Development Laboratories to undertake development workAfter reading a paper by Codd in IBM Journal of Research and Development, they created Oracle. The first version was never released. It was written in Assembly

1.职责：Desktop Integration，WEBADI所有的功能都在“Desktop Integration”下，默认用户都是没有这个职责的，需要在管理员里添加。首先创建一个Document，这个Document相当于一个模板文件。2.Integrator中选择"General Ledger - Journals"，然后Next3.View中选择Excel的版本4.LayoutLayout option：Budgets - MultipleBudgets - SingleForeign Actual - MultipleForeign Actual - SingleFunctional Actual - MultipleFunctional Actual - SingleTh

Desktop Integration职责下 -> Create Document，遇到错误BNE_UIX_PHYSICAL_DIRECTORY is not configured.解决方法：1. Go into the responsibility: System Administrator2. Navigate to Profile -> System -> Profile:BNE UIX Physical Directory3. Remove any value in the profile BNE UIX Physical Directory (null value is the default)4. Bounce the web server and retest the issue.（see：http://blog.csdn.net/pan_tian/article/details/8135987）

WebADI是什么?ORACLE WEB APPLICATION DESKTOP INTEGRATION, WEBADI的目的：Extending the E-Business Suite with Desktop Applications例如：WEBADI可用于连接EBS和Excel，你可以把Excel的数据通过WebADI上传到EBS中区。Features* Metadata driven framework* Allows data to be downloaded and uploaded to Oracle E-Business Suite from desktop applications* Supports Oracle Application Framework artifacts like   Flexfields   Lists of Values* Leverages Oracle E-Busi

Sample script for assigning one item to an organizationDECLARE g_user_id fnd_user.user_id%TYPE :=NULL; l_appl_id fnd_application.application_id%TYPE; l_resp_id fnd_responsibility_tl.responsibility_id%TYPE; l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2(2) := fnd_api.g_false; l_commit VARCHAR2(2) := FND_API.G_FALSE; x_message_list error_handler.error_tbl_type; x_retu

Triggers in Oracle FormsTriggers are blocks of PL/SQL code that are written to perform tasks when a specific event occurs within an application. In effect, an Oracle Forms trigger is an event-handler written in PL/SQL to augment (or occasionally replace) the default processing behavior. Every trigger has a name, and contains one or more PL/SQL statements. A trigger encapsulates PL/SQL code so that it can be associated with an event and executed and maintained as a distinct object.Block Process

Ten Steps To Success from Mohan Dutt

14 Easy Steps to End-User Empowerment: Convert Custom Reports to BI Publisher from Mohan Dutt

Best Implementation Practices with BI Publisher from Mohan Dutt

OAF is a java based application framework to develop web based applications that link to Oracle Applications instance while maintaining all the security features of that apps instance. A framework is a specialized set of related classes designed to make application development easier.  In effect, a framework implements part of an application so developers don’t have to write all of its code from scratch; they can use the framework as the basis for their work and while focusing on the ad

login to your instance with putty or any other software cd $ADMIN_SCRIPTS_HOMER12adoacorectl.sh stop adoacorectl.sh startadoacorectl.sh status(optional)11ish $COMMON_TOP/admin/scripts/adapcctl.sh stopsh $COMMON_TOP/admin/scripts/adapcctl.sh startOAF Server和Form Server是不同的，所以重启Apache Server不会影响Form Server.Bouncing the Apache or OC4J will impact only the self service pages.It won\'t bounce the form server.Bouncing Apache will not disconnect the connected users from the

1. 环境变量的设置1.1  ORACLE_HOME环境变量的设置，我这里指向了我的Oracle 10g的客户端ORACLE_HOME=C:\oracle\product\10.2.0\client_21.2 TNS_ADMIN环境变量的设置,TNS_ADMIN目录下需有tnsnames.ora文件2.ODBC的连接我的OS为Windows7,控制面板>管理工具>数据源(ODBC),这个ODBC为64位的ODBC数据源，因为我们使用的客户端为32位的Oracle 10g客户端，则需要使用32位的ODBC程序来配置连接。32位ODBC的路径默认为

Window7下使用ODBC连Oracle数据库(11g的)，然后报下边的错误:Unable to connectSQLState=IM004[Microsoft][ODBC 驱动程序管理器]驱动程序的 SQLAllocHandle on SQL_HANDLE_ENV 失败解决方法：原来是Oracle_Home指向错了，我连得是Oracle11g的数据库，但环境变量里指定的Oracle_Home为一个Oracle10g的路径，所以连得时候，ODBC报驱动错误.

Win 7下的ODBC不同bit所在路径名字取得实在令人发晕C:\Windows\System32\odbcad32.exe是64 bit ODBCC:\Windows\SysWOW64\odbcad32.exe则为32 bit ODBC应用通过ODBC连到Oracle数据库的路线图（refer:http://support.microsoft.com/kb/140548） ORACLE CONNECTION 6 AND 7 CONNECTION PATHS ------------------------------------------ Application | ODBC Driver Manager(

如何判断Oracle数据库是32位还是64位？Script 1:SELECT length(addr)*4 || \'-bits\' word_length FROM v$process where ROWNUM =1;Script 2:select * from v$version;output like:Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL Release 11.1.0.7.0 - Production CORE 11.1.0.7.0 Production TNS for Linux: Version 11.1.0.7.0 - Production NLSRTL Version 11.1.0.7.0 - Production如何判断Linux操作系统是32位还是64位？[oracle@bej301441 bin]$ uname -m x86_6

REM: Script to compile invalid objects in DB after refreshing REM: REM:***************************************** REM: REM: NOTE: PLEASE TEST THIS SCRIPT BEFORE USE. REM: Author will not be responsible for any damage that may be cause by this script. REM:***************************************** set pagesize 0 set feedback off set trimspool on prompt prompt Run the script as sysdba otherwise invalid objects will remain (ORA-01031 error) prompt prompt Run the script several times. It only takes

How to populate poplist item? Your client has a form that contains a product description. They don’t want that their data entry staffs to type a product description. You, as a programmer, have been asked to change their form so that the product description item is populated from the PRODUCT table. They therefore are able to select the product description. You need to change the “text item” object

ORG_ACCT_PERIODS holds the open and closed financial periods for organizations. When a period is opened, the period open form (INVTTGPO) pulls in the next available period from the GL table GL_PERIODS. ORG_ACCT_PERIODS holds the relevant data, such as period start, end and close dates. Note that only postable periods will be brought over. You may create non-postable periods in Oracle General Ledger or in the GL forms provided with Oracle Inventory. If data exists in the PERIOD_CLOSE_DATE c