ITPub博客

File Type:jpr jpx jwsjpr - JDeveloper Project Filejws - JDeveloper Workspace Filejpx - The.jpx file contains configuration information that JDeveloper uses in the design time to allow you to create the data model project.make vs rebuild"make" JDeveloper should detect that the .java file doesn\'t need recompiling and skip it; "rebuild" JDeveloper should recompile everything whether or not it needs it.Embedded OC4J ServerOracle Application Server Containers for J2EE (OC4J) is

Download JDeveloper 参考下边Note来下载JDev，不同版本的EBS需要下载不同版本的JDevNote 416708.1 - OA Framework - How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x ATG Release 12 VersionJDeveloper 10g Patch12.0.6  (patch 6728000 or patch 7237006)Patch 7523554 10G Jdeveloper With OA Extension ARU for R12 RUP612.1.2 (patch 7303033 or patch 7651091)Patch 9172975 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.212.1.3 (pat

Oracle strongly recommends the following settings for these five security profiles:FND: Diagnostics -> NOFND Validation Level -> ERRORFND Function Validation Level ->ERRORFramework Validation Level -> ERRORRestrict Text Input -> YesSecure Configuration of Oracle E-Business Suite Profiles [ID 946372.1]

早先做EBS功能测试，主要是使用HP的Winrunner或者是HP的QTP，自从2008年Oracle收购了Empirix之后，Oracle产品的自动化测试也将逐步转到了Empirix旗下的测试工具(Empirix eTest Suite)，后改名为Oracle Applications Testing Suite(OATS)，这次收购也填补Oracle在测试工具产品线的空白。OpenScript是Oracle Application Testing Suite的测试平台，一款基于Eclipse的测试工具，所以OpenScript也就当然是使用Java语言写后台

Why Quantity Tree?Why go for such a complex structure just to get the quantity of an Item?Why not just query the tables and get it every time?Why not Just do the computation at each and every code where it is required?This is why:Centralized structure to do anything will reduce much of the hassles. Not only Quantity Computation, but also anything done at a single place will lead to lesser number of bugs and easier maintenance.E.g. where Quantity Tree goes handy:Misc. Receipt Form when you tab

EBS的安全性管理，主要通过“用户+职责”的方式来管理。用户是Oracle Apps的身份表示，每一个用户可以访问一个或者多个职责。而职责是Oracle EBS产品功能的授权层，用户按所属职责访问相应的功能.所以通过对用户职责的设置就可以控制用户在系统中的功能使用权限。Responsibility用于隔离功能(menus,forms,a set of data)Organization用于隔离主基础数据(items,customer,supplier)======================

Many oracle apps scripts need user_id, resp_id and resp_appl_id as input parameter,so how to get the proper value from your systemFrom Back EndHow to get input parameter user_id?eg.SELECT USER_ID FROM FND_USER WHERE USER_NAME = \'MFG\';How to get input parameter resp_id?eg.SELECT RESPONSIBILITY_ID FROM FND_RESPONSIBILITY_TL WHERE RESPONSIBILITY_NAME = \'Inventory\';How to get input parameter resp_appl_id?eg.SELECT APPLICATION_ID FROM FND_APPLICATION WHERE APPLICATION_SHORT_NAME  = \'INV\'

PeopleNavigation:HRMS Management Responsibility -> HRMS Manager -> People -> Enter and MaintainType People:1)Employee 2)Applicant(申请人,请求者) 3)Contingent Worker(临时工)Tables:PER_ALL_PEOPLE_FPER_ALL_PEOPLE_F is the DateTracked table that holds personal information for employees, applicants, ex-employees, ex-applicants, contacts and other people. The columns START_DATE,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE are all maintained by DateTrack. The START_DATE is the date w

2012年My Oracle Support的几点变化1.优化的Metalink页面，从Flash页面回归HTML页面，并作了许多HTML页面的优化2.简化了SR流程3.Mobile Apps: Oracle Now4.Oracle Enterprise Manager与My Oracle Support的集成

将心注入副标题: 星巴克创始人，全球董事长霍华德.舒尔茨自述 作者: [美] 霍华德·舒尔茨 / [美] 多利·琼斯·扬 译者: 文敏 [书摘1]星巴克的历史并不仅仅是一个发展和获胜的历程，它也是关于如何以不同方式来建立一个公司的故事。它完全不同于我父亲曾工作过的那种公司。它证明了一个以

郦波评说曾国藩家训(第一部分)作者: 郦波 出版社: 中国民主法制出版社[书摘1]《三字经》里说：“养不教，父之过。教不严，师之惰。”这说明教不教，是父母的责任；教的程度如何，才是老师的责任。[书摘2]“做官要学曾国藩，经商要学胡雪岩”[书摘3]湘军的三个核心人物曾国藩、左宗棠、李鸿章，都说曾国藩会做人、左宗棠会做事、李鸿

1.准备图片，图片的格式为gif，不是icon或其他格式，图片像素：18×18 pixels把准备好的图片放到$OA_JAVA/oracle/apps/media下2.Forms PersonalizationTrigger:When-New-Form-Instance3.Personalization Action\'Icon Name\'特别要注意，不要加后缀的\'.gif\'效果

APP_SPECIAL.INSTANTIATEExample 1APP_SPECIAL.INSTANTIATE(\'SPECIAL3\',\'&Book Order\', \'POBKORD\', TRUE, \'LINE\'); APP_POPUP.INSTANTIATE(\'POPUP1\',\'First Entry\'); APP_POPUP.INSTANTIATE(\'POPUP2\',\'Second Entry\', TRUE,\'LINE\'); APP_POPUP.INSTANTIATE(\'POPUP3\',\'Third Entry\', FALSE); Example 2app_special.instantiate(\'SPECIAL12_CHECKBOX\', \'Specia&l 12 Check Box with Line\', separator=>\'LINE\'); app_special.

Diagnostics script qtytree_r12.sql is intended to collect quantity tree debug log and data dump from key tables related to quantity eg.MOQD,MR,MMTT etc.qtytree_r12.sqlSET SERVEROUTPUT ON SIZE 1000000 -- DESCRIPTION: -- ============ -- Script qtytree12.sql is intended to collect quantity tree debug log and data dump from key tables related to quantity eg.MOQD,MR,MMTT etc. -- qtytree12.sql is only used For EBS R12 or higher version. -- -- <<OUTPUT FILE>> -- path:utl_file_dir -- file

As product analysts, part of your job is to test new functionality and bug fixes.  You frequently encounter situations where the code is fixed but will not be rolled into a standard testing environment until some future date.  Test your FormMenu:Help-->Diagnostics-->ExamineBlock : $PROFILESField : APPLWRKValue : <your directory in linux> e.g /home/ptian/temp/Test your Library(pld) changes: (in R12)Menu:Help-->Diagnostics-->ExamineBlock : $ENVIRONMENTField : FORMS_PA

How to access \'Integration Repository\' From E-Business SuiteResponsibility : \'Integration Repository\' (12.0.x) \'Integrated SOA Gateway\' (12.1.x)From the Public Web Sitehttp://irep.oracle.com/(This site is unavailable recently,refer:Hosted EBS 11i Integration Repository Temporarily Offline)Oracle Integration RepositoryOracle Integration Repository, an integral part of Oracle E-Business Suite, is a compilation of information about the numerous interface endpoints exposed by Oracle applica

In a OAF Page, Click \'About this Page\'\'Business Component References Details\' AreaDrill Down,You will see View Objects(VO),click any VO you want, you will see detailed SQL Query which is associated to the VO.

Form注册里（Application Developer > Application > Function）的Parameter，加上QUERY_ONLY="YES"这样Form就为只读模式了Reference:How to Make a Form Query Only in Oracle Applications (Doc ID 1013404.102)

.....formname := NAME_IN(\'system.current_form\');blockname := GET_FORM_PROPERY(formname, FIRST_BLOCK);WHILE (blockname is not null) LOOP  IF (GET_BLOCK_PROPERTY(blockname, BASE_TABLE) is not NULL) THEN      SET_BLOCK_PROPERTY(blockname, INSERT_ALLOWED, PROPERTY_FALSE);    SET_BLOCK_PROPERTY(blockname, UPDATE_ALLOWED, PROPERTY_FALSE);    SET_BLOCK_PROPERTY(blockname, DELETE_ALLOWED, PROPERTY_FALSE);    END IF;blockname := GET_BLO

Script that queries the Menu structureSELECT LPAD (\' \', 6 * (LEVEL - 1)) || menu_entry.entry_sequence SEQUENCE, LPAD (\' \', 6 * (LEVEL - 1)) || menu_entry.prompt prompt, menu_entry.grant_flag grant_flag, DECODE (menu_entry.sub_menu_id, NULL, \'FUNCTION\', DECODE (menu_entry.function_id, NULL, \'SUBMENU\', \'BOTH\') ) TYPE, menu2.user_menu_name, func2.user_function_name FROM fnd_menu