田攀的日志

原创 How to use script to get all oracle EBS Form name and corresponding fmb file name

How to use script to get all Oracle EBS Form name and corresponding fmb file nameSELECT fff.function_name, ff.form_name, ffft.user_function_name, fff.function_id

原创 Profile:Flexfields:Validate On Server

Flexfields:Validate On Server Flexfield server-side validation is supplied with the base 10.7 install and as part of a 10SC patch for 10.6 releases.This profile option is set to "Yes" to enable server

原创 Oracle EBS主界面上‘Favorites’下拉列表消失了

不知道怎么搞得，Oracle EBS主界面上方的‘Favorites’下拉列表消失了，取而代之这个列表跑到了页面下方，很容易就忽略掉了解决方法：主界面 -> Preferences ，不知道谁把Accessibility Features设置成Screen Reader Optimized模式了，改回成None，然后返回主界面就能看到Favorites列表了

原创 ICX Timeout Profile Values

ICX:Session Timeout - This profile option determines the length of time (in minutes) of inactivity in a user's form session before the session is disabled.  Note that disabled does not mean terminated

原创 查询所有ICX Profile的脚本

查询所有ICX相关Profile的SQLset pages 100set line 120column "Option" format 99999999column "Profile Name" format A35column "Profile Value" format A55spool support_profile_value.txtselect a.PROFILE_OPTIO

原创 Oracle Consulting Prices(Oralce顾问在国外的价码)

来看看Oralce ERP顾问在国外的价码吧,基本上国外顾问干一个半小时的费用就等于国内顾问干一天的了Oracle Applications Consulting Prices包括EBS的patching,11i upgrades以及flex-field的客户化等等On-Site Oracle Applications Consulting Rate

原创 Accessibility

AccessibilityStandard Accessibility - Renders the pages accessible for users using assistive technology, but ensures that pages are formatted correctly for sighted users.Screen Reader Optimize

原创 Oracle Android Apps - 'Oracle Now'

Oracle官方针对Android发布了一款应用 - 'Oracle Now'，使用Oracle Now不光能查看最新的Oracle资讯，最强大的是可以使用它访问Metalink，查看Notes，SR，甚至可以更新SR。演示视频:http://v.youku.com/v_show/id_XNDQ0MTE5OTM2.html使用方法:Google Play搜索关键字"Orac

原创 OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION

打开Oracle Apps的主页，报下面的错误Error Page  You have encountered an unexpected error. Please contact the System Administrator for assistance.  Click here for exception details.  点击Details，看到以下错误堆栈

原创 Undo Segment

原创 TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG,TRANSACTION_STATUS in MTI or MMTT

TRANSACTION_MODE,LOCK_FLAG,PROCESS_FLAG in MTI(MTL_TRANSACTIONS_INTERFACE) or MMTT(MTL_MATERIAL_TRANSACTIONS_TEMP)* For transactions stuck in MMTTupdate mtl_material_transactions_tempset process_flag

原创 LAST_QUERY in Form and OAF Page

1.Form里查看Last_QuerySYSTEM.LAST_QUERYRepresents the query SELECT statement that Oracle Forms most recently used to populate a block during the current Run form session. The value is always a character

原创 How To Determine Table/View Name in a Form

Help > Record History

原创 Oracle ERP Applications papers

Building Reports Using Oracle's Flexfield Support APIReal Time Migration of Oracle Application Setups Done In HouseMigrating from SQL Server 2000 to Oracle 9iOracle 11i Receivables Implementation Prim

原创 Work Order-Less Completions

WIP > Material Transactions > Work Order-less CompletionsWork Order less completion(无工单完工入库)，可以不用创建工单(discrete job),就可以完工入库的方法,这个流程里，用户直接输入assembly和生产的数量，提交后，成品数量的库存数量就会立即增加。Component中指定组件的信息

原创 How to Make Close Other Forms Option Updatable

发现菜单里“Close Other Forms”灰显，不允许更改SolutionSystem Administrator,Navigate to Security > Responsibility > Define.Query the responsibility in which you want to allow to control the Close Other For

原创 WIP_DISCRETE_JOBS.STATUS_TYPE

WIP_DISCRETE_JOBS.STATUS_TYPEValueMeaning7Cancelled8Pending Bill Load9Failed Bill Load10Pending Routing Load11Failed Routing Load12Clo

原创 WMS_LICENSE_PLATE_NUMBERS.LPN_CONTEXT

WMS_LICENSE_PLATE_NUMBERS.LPN_CONTEXTLOOKUP_TYPELOOKUP_CODEMEANINGWMS_LPN_CONTEXT1In InventoryWMS_LPN_CONTEXT2In WIPWMS_LPN_CONTEXT3In ReceivingWMS_

原创 WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE

WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPEValueMeaning1Push2Assembly Pull3Operation Pull4Bulk5Supplier6Phantom7Based on Bill

原创 WIP_ENTITIES.ENTITY_TYPE

WIP_ENTITIES.ENTITY_TYPEValueMeaning1Discrete job2Repetitive assembly3Closed discrete job4Flow schedule

原创 MTL_TXN_REQUEST_HEADERS.HEADER_STATUS or MTL_TXN_REQUEST_LINES.LINE_STATUS

MTL_TXN_REQUEST_HEADERS.HEADER_STATUS  or MTL_TXN_REQUEST_LINES.LINE_STATUS ValueMeaning1Incomplete2Pending Approval3Approved4Not Approved5Clo

原创 Move Order Type

MTL_TXN_REQUEST_HEADERS.MOVE_ORDER_TYPE LOOKUP_TYPELOOKUP_CODEMEANINGDESCRIPTIONMOVE_ORDER_TYPE1RequisitionMove Order RequisitionMOVE_ORDER_TYPE2ReplenishmentMove Order Type created from replenishment

原创 MTL_SYSTEM_ITEMS_B.LOCATION_CONTROL_CODE

MTL_SYSTEM_ITEMS_B.LOCATION_CONTROL_CODELOOKUP_TYPELOOKUP_CODEMEANINGMTL_LOCATION_CONTROL3Dynamic entry locator controlMTL_LOCATION_CONTROL5Locator control de

原创 MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE

MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODELOOKUP_TYPELOOKUP_CODEMEANINGMTL_SERIAL_NUMBER1No serial number controlMTL_SERIAL_NUMBER2Predefined serial number

原创 MTL_SERIAL_NUMBERS.CURRENT_STATUS

MTL_SERIAL_NUMBERS.CURRENT_STATUSLOOKUP_TYPELOOKUP_CODEMEANINGSERIAL_NUM_STATUS1Defined but not usedSERIAL_NUM_STATUS3Resides in storesSERIAL_NUM_STATUS4I

原创 Delivery Line Status (WSH_DELIVERY_DETAILS.RELEASED_STATUS)

WSH_DELIVERY_DETAILS.RELEASED_STATUSDeliveryLine StatusDescriptionNNot Ready to ReleaseRReady to ReleaseSReleased to WarehouseBBackorderedYStaged

原创 Transaction Source Types

TRANSACTIONSOURCE TYPE IDTRANSACTIONSOURCE NAMEDESCRIPTION1Purchase orderPurchase order2Sales orderSales order3AccountAccount4Move orderMove order5J

原创 Transaction Action Types

TRANSCTIONACTION ID DESCRIPTION1Issue from stores2Subinventory transfer3Direct organization transfer4Cycle count adjustment8Physical inventory adjustment

原创 Transaction Types

Transaction Type = Transaction Source Type + Transaction Action TypeTRANSACTIONTYPE IDTRANSACTIONNAMEDESCRIPTIONTRANSACTIONSOURCE IDTRANSACTIONACTION ID

原创 Cost Group

A Cost Group is the set of accounts that hold on hand inventory. Before the advent of Cost Groups, subinventories in an Oracle Inventory organization defined both the physical and accounting attribute

原创 Material Workbench - Inbound check box

Material Workbench Form，Inbound选项用于查询，“在途数量”，“采购订单数量”，“ASN数量”x01为Inter Org的shipment编号6245为采购订单编号

原创 Oracle Apps User Monitor（监控用户）

Monitor Users如何监控当前哪些用户在干什么，Oracle Apps提供了一个监控这么功能（尽管还是比较简陋）。使用系统管理员用户登陆，到System Administrator职责下，Security > User > Monitor，然后F11, Ctrl-F11,就可以看到当下有哪些用户在干什么，比如这里的截图，用户PROJMFG在Order Information Super U

原创 ADADMIN - Generate Applications Files 菜单项详解

A) Select the "Generate Applications Files menu" option. B) Then select the "Generate forms files" option. C) Choose the number of workers, the default is recommended and is based off the number o

原创 Adpatch Mode FAQ

1.如何从数据库查询当前系统是否处于Maintainance模式SQL> SELECT FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE') FROM DUAL;If it is in Maintenance Mode the above query will show as follows:FND_PROFILE.VALUE('APPS_MAINTENAN

原创 Oracle Apps Patching:adpatch(Maintenance Mode)

之前写过一篇关于Oracle Apps使用hotpatch模式打patch的文章：Oracle EBS使用adpatch工具打patch过程(hotpatch mode) ，今天记录下如何使用Maintainance Mode如何来打Oracle EBS的Patch。1. 通过SQL检查，系统是否已经打了这个Patchselect * from ad_bugs WHERE bug_

转载 Oracle公司的历史发展

转引Fenng的文章，原文： http://www.dbanotes.net/database/oracle_history.htmlFenng原文按：这是这篇文章在 2009 年年底修订的版本，从成稿以来的第三次修订，补充了若干新发现的信息。仅供参考，如有谬误，敬请指正。所有信息来自公开资料，恕不负责信息准确性。1. ORACLE公司之起源很难想象，ORACLE 公司的这一段传奇

原创 Linux下FTP命令

ftp命令使用Sample-bash-3.00$ ftp rws60001rems.us.oracle.com(连接另外一台主机)Connected to rws60001rems.us.oracle.com (139.185.21.141).220 (vsFTPd 1.2.1)Name (rws60001rems.us.oracle.com:app7740): xxxxx33

转载 ERP系统之比较——SAP、Oracle、BAAN、JDE、SSA

ERP系统之比较——SAP、Oracle、BAAN、JDE、SSA ERP/MRPII系统剖析SAPSAP公司简介R/2和R/3系统是德国SAP公司所提供的MRPII产品。R/2是用于集中式大型机环境的系统，R/3是用于分布式的客户机/服务器环境的系统。SAP是国际上著名的标准应用软件公司。SAP总部设在德国南部的沃尔道夫市，公司成立于1972年，1988年成为德国股票上市

原创 Oracle Apps DBA工具:ADADMIN使用说明

ADADMIN用途ADADMIN主要用于Oracle Apps文件系统和数据库的维护工作，是Apps DBA常用的工具。（ADADMIN执行文件位于$AD_TOP/bin下）使用方法[oracle@bej301441 ~]$ adadmin如果ADADMIN命令无法运行，很可能是环境变量没有设置，可以运行下". $APPL_TOP/instance.env"来设置环境变量。adadmin执行过程中

原创 Error:The system has not been taken off maintenance mode completely.

打patch之后,重启EBS Server，使用IE登陆时，报ErrorThe system has not been taken off maintenance mode completely. Please contact your System Administrator.从错误上看，貌似是Maintainance模式没有关闭，然后就使用adadmin关闭Mainte