ITPub博客

关于odf文件，写过一篇笔记,见：Oracle Apps ADODFCMP Utility, xdf和odf类似，都是数据库对象的描述文件，用于数据库表，视图，索引等等在不同数据库间的移植。根据NOTE:551325.1的说法，xdf将会逐步取代过去的odf，毕竟xdf的xml格式还是要比文本格式的odf有方便处理些。xdf对应的执行文件是$JAVA_TOP/oracle/apps/fnd/odf2/FndXdfCmp(一java文件)odf对应的执行文件是$AD_TOP/bin/adodfcmp(脚本语言)xdf文件

$PROFILES$.AFLOG_ENABLEDSpecifies if logging is enabled or not. The default value is NULL (False).$PROFILES$.AFLOG_FILENAMESpecifies the file where middle-tier log messages are written.$PROFILES$.AFLOG_LEVELSpecifies the logging level. The default value is NULL (Log.UNEXPECTED).$PROFILES$.AFLOG_MODULESpecifies which modules are logged. The default value is NULL (%).Refer:http://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T359300.htm$PROFILES$.APPLWRK= Profile: FND: Override DirectoryThe

What\'s needed to enable EBS environments for JRE 7? EBS customers should ensure that they are running JRE 7u17, at minimum, on Windows desktop clients. Of the compatibility issues identified with JRE 7, the most critical is an issue that prevents E-Business Suite Forms-based products from launching on Windows desktops that are running JRE 7.  Customers can prevent this issue -- and all other JRE 7 compatibility issues -- by ensuring that they have applied the latest certified patches

COMMIT_FORM and COMMIT do the same thing, they apply any outstanding changes in the form to the DB and issue a DB-COMMIT.DO_KEY(\'commit_form\') executes the code which is written in your KEY-COMMIT trigger. If that trigger doesn\'t exist it does the same as COMMIT_FORM.Oracle Application Developer Guide says:Replace COMMIT with do_key(\'commit_form\'), This routine raises the exception FORM_TRIGGER_FAILURE if there is an invalid record.Sequence of Trigger Fire while Committing KEY-Commit

In Oracle Application Developer Guide, It says following...The Oracle Applications forms have special exit processing. Do not call EXIT_FORM directly; always call do_key(’EXIT_FORM’).What\'s difference between Do_Key(\'Exit_Form\') and Exit_Form?EXIT_FORMexit_form will close form (with validation).Calling the exit_form built-in performs the standard exit form process (only). Do_Key(\'Exit_Form\')If you want to customize your exit process, you need a KEY-EXIT trigger. Then calling do_key(\'exit

Asked a question in OTNQestion1:In Interface Managers form(Navi:Inventory > Setup > Transactions > Interface Managers), Default interval of concurrent program \'Material transaction\' is 5 mins, how can I modify this interval time?Anser1:You can schedule the program related to the manager on an interval based on the business requirement,Click on Tools -> Launch manager and schedule the program accordingly.Question2: Tools > Launch Manager,It will Run request "Process transa

OPEN_FORMwhen one form invokes another form by executing open_form the first form remains displayed, and operators can navigate between the forms as desired. Example:When we invoke a form from OPEN_FORM built-in, we can freely move to calling form and called form.We have FormA, FormB.We open the formB from FormA.OPEN_FOR(\'FormB\');We can move the focus to FormA and FormB without closing FormB. CALL_FORMwhen one form invokes another form by executing call_form, the called form is modal wi

Inventory-> Setup-> Organizations->OrganizationsFocus on Inventory Organization,And Click \'Others\'Accounting Information,Enter Account Information.Enter Inventory Information. Associate this new org to a responsibility.  Inventory-> Setup-> Organizations-> Organization Access

source:REQCHECK.sql - Diagnostic Script for Concurrent Requests (Doc ID 164978.1)This Script is made available for Diagnosing Common Problems Related to Concurrent Requests.REM ######################################################################### REM ## Purpose: Diagnostic Script for Concurrent Requests REM ## Author: Brian Kerr REM ## Email: brian.kerr@oracle.com REM ## Filename: reqcheck.sql REM ## Cert: 10.7, 11, 11.5, 12 REM ## Note: REM ## Usage: sqlplus apps/ @reqcheck.sql REM ## Out

1.Control Filesset pagesize 500 set linesize 130 Prompt Prompt Control Files Location >>>> col name format a60 heading "Control Files" select name from sys.v_$controlfile /2.Redo Log FilesPrompt Prompt Redo Log File Locations >>>> Prompt col Grp format 9999 col member format a50 heading "Online REDO Logs" col File# format 9999 col name format a50 heading "Online REDO Logs" break on Grp select group#,member from sys.v_$logfile /

Oracle EBS中，如果获取Item，Organization等基础数据的信息。你可以写SQL来查，这种做法的不好处就是，在不同Procedure或者Function中，你可能需要写多次类似的SQL来取值，造成代码的冗余。EBS标准的做法是，通过Cache模式来时缓存需要的信息。以获取Organization为例，系统中标准的做法是: l_return_value := INV_CACHE.set_org_rec(p_organization_id); IF NOT l_return_value THEN RAISE fnd_api.g_exc_unexpected

Server上，发现空间不足，于是想删除一些临时日志来腾点空间，以为自己已经在日志目录下了，也没仔细看，就直接运行rm命令了，结果把系统中很多非常关键的脚本都清掉了，惊出一身冷汗。本来就很忙，还花费了一下午的时间才把删除的文件重新恢复。从中也得到了些教训：1.备份，备份，还是备份；2.慎用或者不用rm命令；3.操作前，保持头脑清醒，知道自己在干什么；

10g(R2)  (大图 )11g (大图)

In Oracle Shipping, Interface Trip Stop (ITS) will be trigger at the time of Shipping confirm if check box “Defer Interface” is not check.Navigation:Order Management > Shipping > Interface > Run > Request: Interface Trip Stop - SRSConcurrent Program Name:WSHINTERFACESExecution File Name: WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrpMain Function of ITSMain Code Flow WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp  |- interface_ALL    |- PROCEDURE oe_interface_trip_s

Online Patching就是允许用户在运行时打patch，并且无需重启服务器。以前如果用户要打patch，用户必须重启服务器，这个很麻烦并且让会造成几个小时的停机，给客户也造成了成本的损失，12.2以后引入Online Patching,就不会有这样的烦恼了,对于EBS DBA绝对是一个福音。R12.2 OLP的实现方式：12.2引入了双文件系统(一个是run time文件系统，另一个是patching文件系统)，包括APPL_TOP, Common Top,Ora

Navigation:Inventory > Transaction INVTTMTX.fmx - Misc Transaction/Inter-Org Transfer/SubInv Transfer/Consigned TransactionINVTVTXN.fmx - Material TransactionINVTVTUS.fmx - Transaction SummariesCSTFQITD.fmx - Material DistributionsINVTVTMP.fmx - Pending TransactionINVTVPTX.fmx - Transaction Open InterfaceNavigation:Inventory > Transaction > ReceivingRCVRCERC.fmx - ReceiptsRCVTXERT.fmx - Receiving TransactionsRCVTXECO.fmx - Receiving CorrectionsRCVTXERE.fmx - ReturnNavigation:Inventory

Solution:1.Create a Text Item2.Database Item = No3.Calculation Mode = Formula    Formula = :SYSTEM.TRIGGER_RECORDCalculation Mode property

\'Workflow Notification Mailer\' Service is under status:\'System Deactivated\'.Detailed Status Information like below:---------------------------------------------------------This automatic Service Component has been restarted the maximum of 10 times after stopping with error. Thus, it has been system deactivated -> oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for

Unable to connect SMTP port,There is a easy to check this.(ptian) ptian- telnet server_host 25Trying ip...telnet: Unable to connect to remote host: Connection refusedThis means probably, SMTP port 25 is not open.Solution:To resolve the issue,you need login with root user.1.Verify sendmail packagesIn order to configure sendmail, you will require the sendmail and sendmail-cf packages. [root@bej301441 oracle]$ rpm -qa | grep sendmail sendmail-doc-8.13.8-8.1.el5_7 sendmail-8.13.8-8.1.el5_7 sendmai

1.要想从DB Server发邮件，首先得确保DB Server已经启用了SMTP(Simple Mail Transfer Protocol)服务。检查是否启动SMTP的方法telnet server.domain.com 25(25是SMTP的默认端口)2.PL/SQL to send email sample code:DECLARE lc_from_email_id VARCHAR2 (100); lc_mailhost VARCHAR2 (100) := \'abc.com\'; lc_connection UTL_SMTP.connection; v_mail_sub VARCHAR2 (200) := \'Hello\'; v_mail_body VARCHAR2 (1000) := \'This is the mail bo