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 page Oracle Applications Hosts: <your_hostname>, click the "View configuration" button.2. How to check used port in Oracle Database System.check port list file: $RDBMS_ORACLE_HOME/install/portlist.ini3.Port Pools in R12what\'s port pool? check https://blogs.oracle.c
[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 on the Apple iPad. This certification IS available for: Oracle E-Business Suite OA Framework-based applications with Safari browser on the Apple iPad.E-mail based workflow notifications via the Apple Mail application o
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下TEMPLATE.fmb和APPSTAND.fmb到开发目录2.把$AU_TOP/resource下所有的pll文件又重新拷贝了一遍到开
Zoom Feature with Custom.pll or Form Personalization
什么Zoom功能:通过客户化,用户在点击Zoom按钮后,可以从一个Form跳转到另外一个Form上。比如销售订单,输入物料后,想看下物料的库存情况,可以把焦点放在到物料上,然后点击Zoom按钮,Workbench的Form被调用起来。有两种方法可以实现zoom功能:第一种是通过custom.pll,还有一种是通过Form Personalization1. Custom.pllFUNCTION ZOOM_AVAILABLE RETURN BOOLEAN IS form_name VARCHAR2 (30) := NAME_IN (\'system.
VBA - Hello World
首先启用宏:文件>选项>信任中心>宏设置>启用所有宏+信任对VBA工程对象模型的访问在开发工具页签,插入一个ActiveX的按钮控件插入按钮到Sheet中右键按钮>查看代码,进入VB编辑器界面保存,关闭VB编辑器,退回到Excel界面,关闭“设计模式”,然后点按钮进一步,如果想给某个单元格赋值,可以使用下边的语句Range("A1").Value = "Hello World"我们把Hello World
Consignment Inventory in Oracle EBS
Consignment Inventory:即寄售库存,在货物没有被购买商使用之前,货物的所有权仍归供应商所有,购买商只有在使用货物时才支付费用。“寄售库存”是处理积压库存产品,腾出其占用空间,增加现金流的一种库存处理方式。委托方将积压的库存产品委托给受委托方代为销售,委托方一般需将库存产品交给受委托方代为保管,授权其代为销售,产品出售后,由受委托方向委托方结
Oracle Forms Customizations Technology Stack
A Mind Map Regarding Oracle Form Personalization. Choose proper technology base on your requirements.
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 transacting move order in MSCA.Whse Mgmt Responsibility-> Task -> Manual Tasks -> Paper Based Pick -> Enter \'Pick ID\'(If you only Load, Then you also need perform \'Drop\',Tasks -> Manual Tasks ->Directed Move ->Drop Loaded LPNs)-------------------------------------------
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取代* 数据库使用11gR2+,并在此基础上,提供了EBS 12.2最大的改进Online Patching视频
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 to enter data into this box.messageCheckBox - This helps to create check box in your page.messageRadioGroup- This helps to create radio buttons in your page.see also:http://newtonapples.com/message-radio-button/messageChoice - When you want to display a list of values in
几个关于Oracle EBS二次开发的问题
问:论坛里有人问如何给Form添加新的字段?答:通过DFF,Descriptive Flexfield。Descriptive Flexfield会把新加的字段添加到基表中的预留字段。不推荐通过直接修改Form的方式来添加字段,那样的话,如果打了patch后,新加的字段就会被覆盖。关于Flexfield的更多信息,可以查阅Oracle Applications Flexfields Guide问:Form Personalization和Custom.pll的关系,谁先被执行,谁后被执行?答:基本上Personalizatio
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 to enter data into this box.messageCheckBox - This helps to create check box in your page.messageRadioGroup- This helps to create radio buttons in your page.see also:http://newtonapples.com/message-radio-button/messageChoice - When you want to display a list of values in
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 level? Organization level? Function levelPERSONALIZATION FEATURES Customers can now achieve the following without making any code changes: · Hide fields and buttons. · Change the prompts for the fields and buttons. · Provide default values to the fields. a. If there is no default value prov
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 client-like functionality to browser-based applications, using JSF provides server-side control, which reduces the dependency on an abundance of JavaScript often found in typical AJAX applications.In addition to providing the JSP tags and UIComponent instances that would be expected of any JSF com
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...-----------------------------------------------------AF_CLASSPATH=[JDK_TOP]/lib/dt.jar:[JDK_TOP]/lib/tools.jar:[JDK_TOP]/jre/lib/rt.jar:$JAVA_TOP/../lib/appsborg2.zip:$JAVA_TOPRelated Notes:Troubleshooting Classpath (Doc ID 184714.1)Upgrading Oracle Applications 11i to use JDK 1.3 (Doc ID 130091.
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. Loading material onto equipment Dropping material directly into a staging lane or consolidation locatorAfter the operator picks the load, they can either drop it directly into a staging lane, or load it on to their equipment. They can then proceed to the next pick location. The operator can view th
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?username=<username>&password=<password>(也可指定语言:在链接后边加&langCode=US、&langCode=Z
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 to LotTrxManager.class,Then run below script to check java file version in Database.beginfnd_aolj_util.getClassVersionfromDB(\'oracle.apps.inv.transaction.server.LotTrxManager\');end;Above script also error outLine Pos Text &nb
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 JAVA Virtual Machine11.2.0.1.0VALIDAPSOLAP Analytic Workspace11.2.0.1.0VALIDAMDOLAP Catalog11.2.0.1.0VALIDOWBOWB11.2.0.1.0VALIDAPEXOracle Application Express3.2.1.00.10VALIDOCAOracle Application Server Certificate Authority10.1.2.0.2VALIDDCMOracle Application Server Distributed Configuration Manage
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 sysdbaSQL*Plus: Release 10.1.0.5.0 - Production on Wed Mar 6 08:13:11 2013Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-01031: insufficient privilegesSolutionThis is not the sqlplus which under $RDBMS_ORACLE_HOME.We need switch ORACLE_HOME to real DB HOME,and use