![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle EBS Dev
文章平均质量分 76
田攀
tian.pan@qq.com
展开
-
如何使用Oracle FND_LOAD工具在不同Instance间同步数据(Example)
FNDLOAD是Oracle官方提供数据同步工具(Data Synchronization),一般情况下,我们通过FNDLOAD工具把DEV Instance的客户化AOL数据下载到一个文本文件中,然后同样使用FNDLOAD上传到PROD Instance中去。什么样的情况下,需要使用FNDLOAD来同步我们在测试环境开发了一些客户化程序(Personalization),Conc原创 2012-07-04 11:14:46 · 6253 阅读 · 0 评论 -
Lot Number Descriptive Flex Field:Lot Attributes DFF & Maintain Lot Number DFF
Lot Entry中的有两个DFF,一个是Maintain Lot Number DFF,另一个是Lot Attributes DFF知道基表,查看对应DFFSELECT * FROM FND_DESCRIPTIVE_FLEXS WHERE application_table_name = 'MTL_LOT_NUMBERS';FND_DESCRIPTIVE_FLEXS表中几个字段需要注意,APPL原创 2012-08-07 17:33:56 · 4468 阅读 · 0 评论 -
Oracle EBS Development Command
Open Form fileR12frmbld.sh INVTOMAI.fmb11if60desm XXX.fmbCompiling formR12frmcmp.sh module=INVRSVF1.fmb userid=apps/apps@mz1ms206 module_type=form compile_all=special(Batch Mode)frmcmp.sh module=INVRS原创 2012-04-24 03:22:49 · 8517 阅读 · 0 评论 -
Oracle Apps Lookup Tables,Views,Queries,FAQ
Navigation:Responsibility:Application Developer -> Application -> lookupsLookup screen is available in almost evert superuser responsibility,you can access common lookup screen. Basically records get原创 2013-04-07 19:14:55 · 8239 阅读 · 0 评论 -
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 · 7854 阅读 · 0 评论 -
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 · 11047 阅读 · 0 评论 -
Form Trigger Sequence Demo Form
Form Trigger太多太庞杂,新手往往很难上手,加上一些Trigger有点偏门,用的比较少,真到想用的时候,又不知道从哪下手。所以之前就有想法写一个Demo Form,用于显示Trigger的执行顺序,今天发现已经有人写过这个东西了,也就不用重造这个轮子了。作者:Francois Degrelle(Oracle ACE)Site:http://sheikyerbouti.developpez原创 2012-12-31 12:31:33 · 2748 阅读 · 1 评论 -
Oracle EBS中有关Form的触发器的执行顺序
触发器执行顺序:1. 当打开FORM时:(1) PRE-FORM(2) PRE-BLOCK(BLOCK级)(3) WHEN-NEW-FORM-INSTANCE(4) WHEN-NEW-BLOCK-INSTANCE(5) WHEN-NEW-RECORD-INSTANCE(6) WHEN-NEW-ITEM-INSTANCE2.转载 2012-09-14 14:08:31 · 4251 阅读 · 0 评论 -
Triggers in Oracle Forms
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转载 2012-11-02 14:53:49 · 2659 阅读 · 0 评论 -
ENTER-QUERY Mode
SYSTEM.MODE indicates whether the form is in Normal, Enter Query, or Fetch Processing mode. The value is always a character string.* NORMAL - Indicates that the form is currently in normal process原创 2012-10-08 15:41:51 · 3946 阅读 · 0 评论 -
Oracle EBS pld file attach a LIBRARY
1. set up FORMS_PATH(in 11i,it is FORMS60_PATH), make this env parameter point to directory where pll locationFORMS_PATH is used by Forms Builder to record the location of attached libraries (.pll)原创 2012-09-26 17:29:22 · 3520 阅读 · 0 评论 -
How To Determine Table/View Name in a Form
Help > Record History原创 2012-08-22 10:35:51 · 2159 阅读 · 0 评论 -
Custom.pll example to make DFF read only
在特定的职责下,让DFF只读/* *************************** Code to make DFF Read Only ****************** */IF (event_name = 'WHEN-NEW-BLOCK-INSTANCE' AND form_name = 'PERWSEAD' AND block_name = 'ABA') T原创 2012-08-07 16:44:30 · 2779 阅读 · 0 评论 -
Oracle EBS Tables
eTRM: etrm.oracle.com"EBS重要表用途与关系介绍.pdf" http://vdisk.weibo.com/s/lt2I-"R12_Table(All Module)_ER.zip" http://vdisk.weibo.com/s/lt8GM"R12_eTRM(多模块).zip" http://vdisk.weibo.com/s/lzfIw"OracleERP表结构.xls"原创 2012-12-24 11:38:33 · 4822 阅读 · 0 评论