2013年03月_田攀

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 Inventory Transactions Manager

OverviewInventory Transaction Manager用于处理库存接口表(MTL_TRANSACTION_INTERFACE或者MTL_MATERIAL_TRANSACTIONS_TEMP)中的记录，处理之后最终产生库存事务(MTL_MATERIAL_TRANSACTIONS)。(补：MTL_MATERIAL_TRANSACTIONS里记录了所有库存事务的历史，是Invento

2013-03-30 21:07:54 5494

原创 OM:Over-ship Tolerance

订单(Order Management)流程，发运数量(Shipped Qty)可以超过实际的订单请求数量(Requested Qty)，最终会以发运数量为准。在订单的Shipping页签，设定"Over-ship Tolerance"，这个值是一个百分比，是指可以超发多少比例的数量(这个字段如果隐藏，可从Folder中显示出来)超发的数量/订单请求数量不能大于Over-ship Toleranc

2013-03-29 17:29:31 3330

原创 How to invoke Standard Choose Organizations Form From your form

Step1: Create 4 parameters in your custom form,ORG_ID,ORG_CODE,ORG_NAME,CHART_OF_ACCOUNTS_IDAttributes like belowStep2: Pre-Form Trigger, call FND_ORG.CHOOSE_ORG;(FND_ORG.CHOOSE_ORG定义在FNDSQF.pll文件中)An

2013-03-29 13:36:52 5361

原创 ORA-24323 Error in Report Builder

Report Builder写入SQL后，点下一步，报ORA-24323: 不允许此值的错误解决方法：重新连接数据库，再试，问题应该能解决。原因可能是数据库的连接丢失造成的。

2013-03-28 10:35:35 2227

原创 New Feature "Optional Lot Allocation" in Oracle EBS R12.2.2

今天和同事分享了我在EBS R12.2.2做的一个新功能-Optional Lot Allocation. Optional Lot Allocation的引入，可以让客户在挑库的时候，可以选择是否自动挑入批次。在以前，挑库后，批次一定会根据挑库规则被选择上，客户可能会不满意挑库规则所挑选的批次，那么就需要手动的删除批次，再更改批次，如果批次很多就会增加很多工作量。新功能之后，客户可以选择不挑批次

2013-03-27 23:14:24 2782 1

原创 "ROWNUM = 1"会使SQL的性能更快?

SQL中加入ROWNUM = 1会让性能有所提升么？有可能，但也不全是。遇到了一个Case，ROWNUM = 1的加入并没有像想象的那样让性能有所提升。背景：PL/SQL的代码，用下边的Query来检查符合条件的记录是否存在。SELECT 'X' FROM MTL_MATERIAL_TRANSACTIONS A,MTL_TRANSACTION_TYPES B WHERE A.ORGA

2013-03-27 17:20:09 6801

原创不要为了重构而牺牲代码的阅读性

在性能可以接收的前提下，不要为了重构而牺牲代码的阅读性，这会让后期的维护越来越难。尤其是PL/SQL这样面向过程的语言，宁肯代码存在冗余，也要保证逻辑的清晰。重构是为了让逻辑更简单和清晰，而不是为了抽象让逻辑变得混淆和复杂。为了重构而重构，那是炫技，企业级软件工程需要更多地是稳定，清晰，而不是花架子。-------------------------------------------------

2013-03-26 17:00:33 2627 4

原创 Error: APP-ONT-250268: Record is currently being worked on by another user, Please try to update it

Error: APP-ONT-250268: Record is currently being worked on by another user, Please try to update it later.Cause：叉掉IE，EBS非正常关闭,就可能会有这个问题。非正常关闭，造成数据库锁没有释放，下次再登陆可能就遇到上述错误。Solution: 如何解数据库锁

2013-03-26 15:27:15 6604

原创 Creating a Customer at the time of creating a Sales Order

Profile:OM: Add Customer允许可以在定义销售订单时，快速添加一个新的客户None:表示不允许使用快速添加客户功能。All:表示既可以添加新客户，也可以为已经存在的客户添加地址及联系人。Address and Contact Only:仅能为已经存在的客户添加地址及联系人

2013-03-25 15:22:00 2468

原创 WebUtil Useful Reference

WebUtil Demo / DocumentationWebUtilHome Page on OTNWebUtil- A simplified guide to understanding WebUtil.WebUtil Version 1.0.6 - Production Release Notes FAQ Oracle Forms 10g WebUtil WebUtilDemoUsing W

2013-03-25 00:45:24 4059

原创 FRM-40735: ON-ERROR trigger raised unhandle exception ORA-06508

Form Builder版本10，在本机编译、运行Form（此form基于Template.fmb基础上开发的），编译都没有问题，但是运行时报错。英文：FRM-40735: ON-ERROR trigger raised unhandle exception ORA-06508中文：FRM-40735: ON-ERROR 触发器提出了不能处理的异常状况 ORA-06508原因：基于Template

2013-03-24 23:29:18 4475

原创 Find all used ports list in EBS R12 Instance

1. How to check used ports in oracle application systemNavigation: System Administrator -> Oracle Application Manager - > Dashboard -> click the link of the apps server in the HOST column -> On the p

2013-03-23 19:03:14 10768

原创 [News]Apple iPads Certified with Oracle E-Business Suite 12.1

Steven Chan最近发布消息，iPad(iOS 6.0+)已经可以访问EBS(12.1.3+)了。用户可以通过iPad来访问OA Framework页面的EBS功能，但还不支持访问Form。OverviewOracle E-Business Suite Release 12 (12.1.3 or higher) is now certified with iOS 6.0 and higher

2013-03-23 18:11:34 2196

原创 FRM-18108,FRM-10102 Error when open form

新装了个XP的虚拟机，拷贝了必要的fmb和pll文件开发目录下，Form Builder(version:10)打开TEMPLATE.fmb，总是报FRM-18108,FRM-10102错误，这种错误多半是FORMS_PATH的问题，但仔细检查过注册表,FORMS_PATH参数设置应该是没有问题，并且报的相关文件都已经在开发目录下了。解决方法：1.重新拷贝了$AU_TOP/forms下TEMPLA

2013-03-22 21:42:27 3020

原创 Zoom Feature with Custom.pll or Form Personalization

什么Zoom功能：通过客户化，用户在点击Zoom按钮后，可以从一个Form跳转到另外一个Form上。比如销售订单，输入物料后，想看下物料的库存情况，可以把焦点放在到物料上，然后点击Zoom按钮，Workbench的Form被调用起来。有两种方法可以实现zoom功能：第一种是通过custom.pll，还有一种是通过Form Personalization1. Custom.pllFUNCTION Z

2013-03-22 16:46:25 2993

原创 Consignment Inventory in Oracle EBS

Consignment Inventory:即寄售库存，在货物没有被购买商使用之前，货物的所有权仍归供应商所有，购买商只有在使用货物时才支付费用。“寄售库存”是处理积压库存产品，腾出其占用空间，增加现金流的一种库存处理方式。委托方将积压的库存产品委托给受委托方代为销售，委托方一般需将库存产品交给受委托方代为保管，授权其代为销售，产品出售后，由受委托方向委托方结算货款并获取佣金或差额利润。沃尔玛采用

2013-03-22 10:21:26 4577

原创 Oracle Forms Customizations Technology Stack

A Mind Map Regarding Oracle Form Personalization. Choose proper technology base on your requirements.

2013-03-19 19:21:20 2568

原创 Oracle的单点登录解决方案（Single Sign-On Solution）

Single Sign-On(SSO)即单点登录，简单说，就是通过用户的一次性鉴别登录，即可获得需访问系统和应用软件的授权，在此条件下，管理员无需修改或干涉用户登录就能方便的实施希望得到的安全控制。Oracle现有两套单点登录的解决方案：Oracle Access Manager，Oracle Single Sign-On Server (OSSO)。Oracle官方推荐Access Manage

2013-03-19 15:01:32 19305 1

原创 How to Transact Move Order in WMS Enabled Organization

How to Transact Move Order in WMS Enabled OrganizationTransact Move Order Form, In case organization is WMS enabled, 'Transact' is disabled.User Must transact move order in Mobile device.Navigation of

2013-03-18 12:16:20 7424

原创 Oracle E-Business Suite Strategy and Roadmap - Cliff Godwin, SVP

Cliff Godwin-甲骨文应用产品线的高级副总裁，3月初在youtube上，发布了关于EBS未来策略和路线图的演讲视频。我转了一份到Youku上，你可以通过这个视频了解EBS将来的走向和策略。应用无极限，几年来，Oracle的应用产品线越来越丰富。E-Business Suite路线图E-Business Suite 12.2.x的新特性：* OC4J全面被Weblogic取代* 数据库使用

2013-03-15 12:58:25 3200

原创几个关于Oracle EBS二次开发的问题

问：论坛里有人问如何给Form添加新的字段?答：通过DFF,Descriptive Flexfield。Descriptive Flexfield会把新加的字段添加到基表中的预留字段。不推荐通过直接修改Form的方式来添加字段，那样的话，如果打了patch后，新加的字段就会被覆盖。关于Flexfield的更多信息，可以查阅Oracle Applications Flexfields Guide问：

2013-03-14 11:37:38 4601

原创 Item Styles in OA Framework

messageStyledText - When you want to display only the text and the user should not be able to edit the text then we use the messageStyledText.messageTextInput - As the name implies it helps the users

2013-03-13 16:51:02 4526

原创 Personalization Level on Oracle MSCA

Oracle Mobile Supply Chain Applications enables you to personalize the user interface to suit your individual preferences. Personalization can be performed at the following levels:• Responsibility lev

2013-03-12 23:55:25 3893

原创 Oracle E-Business Suite on Mobile Device

近期看了一些EBS在移动终端的应用案例，大体研究了下，EBS移动终端的实现方法大体有以下几种:1.ADF MobileOracle ADF Mobile是基于Java和HTML5的移动开发框架，基于这个框架构建，扩展企业应用到安卓和iOS。Demo1:http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/adfmobiledem

2013-03-12 20:54:22 4291

原创 Oracle ADF Faces Rich Client Components

Oracle ADF Faces rich client (known also as ADF Faces) is a set of JavaServer Faces (JSF) components that include built-in Asynchronous JavaScript and XML (AJAX) functionality. While AJAX brings rich

2013-03-12 19:45:24 3280

原创 Application ENV parameter:CLASSPATH and AF_CLASSPATH

CLASSPATH=[JDK_TOP]/lib/dt.jar:[JDK_TOP]/lib/tools.jar:[JDK_TOP]/jre/lib/rt.jar:$JAVA_TOP/../lib/appsborg.zip:$JAVA_TOPand some other forms/mid server necessary lib.eg.frmall.jar,ewt3.jar,frmsrv.jar..

2013-03-11 17:57:10 2992

原创 WMS Task Loading and Dropping

Load:Load of material for movement.Drop:Drop of material to complete a movement.Task loading and dropping includes the following and completes the Oracle Warehouse Management picking task process. Lo

2013-03-11 15:37:00 2659

原创 How to Login Oracle Applications Directly - fndvald.jsp

Oracle EBS标准登录页面的链接格式：http://hostname.domain:port/OA_HTML/AppsLogin，然后输入用户名、密码，就进入主页面(职责页)。有的客户可能会有这样的需求，是否可以绕过登录界面，直接进入系统主页。解决方法：可以使用如下的登录链接： URL> http://hostname.domain:port/OA_HTML/fndvald.jsp?us

2013-03-09 00:10:19 3995

原创 java.lang.UnsupportedClassVersionError in Oracle Apps

After submitting inventory transaction, Oracle Applications show process error, Check inventory debug log, found out error:java.lang.UnsupportedClassVersionError. From log, The issue seems be related

2013-03-07 17:20:49 3395

原创 Installing Oracle Application Express(APEX) in Linux

APEX is currently supported on on 10.1 and higher. The 11.x version of the database automatically installs Application Express by default.So at beginning, you need use below query to check whether you

2013-03-07 15:32:10 3425

原创 Database Components Information Table - DBA_REGISTRY

DBA_REGISTRY displays information about the components loaded into the database.SELECT COMP_ID,COMP_NAME,VERSION,STATUS FROM DBA_REGISTRYORDER BY COMP_NAME;COMP_IDCOMP_NAMEVERSIONSTATUSJAVAVMJServer J

2013-03-07 15:26:39 3267

原创 ORA-01031: insufficient privileges

command 'sqlplus system/manager' works fine. But in case connect system/manager as sysdba, it will tell me "ORA-01031: insufficient privileges" error.[oracle@bej301441 ~]$ sqlplus system/manager as sy

2013-03-07 00:37:25 3561

原创 odf-File and xdf-File

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

2013-03-06 18:37:22 3646

原创 $PROFILES$ in Examine

$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$.AFLO

2013-03-06 12:07:42 4707

原创 Enable EBS environments for JRE 7

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

2013-03-05 17:07:00 7534

原创 Difference between Commit,COMMIT_FORM and Do_Key('Commit_Form')

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 tri

2013-03-05 15:34:49 7837

原创 Difference between Do_Key('Exit_Form') and Exit_Form

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

2013-03-05 15:15:10 4139

原创 Interface Managers - Material Transaction - Process Interval - Field Not Updatable

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

2013-03-05 14:35:03 4384

原创 OPEN_FORM, CALL_FORM, NEW_FORM and FND_FUNCTION.EXECUTE

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_FO

2013-03-05 12:34:07 11005

原创 Create an Inventory Organization

Inventory-> Setup-> Organizations->OrganizationsFocus on Inventory Organization,And Click 'Others'Accounting Information,Enter Account Information.Enter Inventory Information. Associate this new org t

2013-03-04 18:57:55 2540