ITPub博客

Navigation:Navigate to Workflow Administrator> Oracle Application Manager > Workflow Manager > Service Components > Workflow Agent Listener Services Start and Stop the Oracle Workflow Services--------------------------------------------------------------------------------------------There also is a script to check all workflow service statusSET PAGESIZE 400 SET LINESIZE 120 SET PAGESIZE 50 COLUMN COMPONENT_NAME FORMAT A45 COLUMN STARTUP_MODE FORMAT A15 COLUMN COMPONENT_STATUS FORMA

现象：从JDeveloper中Run OAF页面非常慢。原因：开发环境下，一定硬件配置，OAF页面运行的性能瓶颈主要在于网络。所以理想性能的OAF开发环境是，DB Server里安装JDev来开发OAF，这种最理想情况。一般情况下，想提升性能，最好保证DB Server和本机在同一个局域网络下。Server A是中国的服务器，我的开发环境是美国Linux机器，ping Server A,time大概在165ms左右，Run一个OAF页面非常慢，一个

Regions are containers for for different items in a page.In a page there can be any number of regions inside regions and many number of items inside the region.Every region is a java bean acting as a container for regions under it or items.Regons inside another region is called Child Region and that is present in the same level as another region it is a Sibling.Region properties can be set like Style,ID,Rendered etc. There are small restrictions while creating the region which will affect the

Responsibility:System Administator > Profile System ValuesQuery Find Profile:Site NameRe-Login,

Java Color SchemeYou can use this profile to set different colours to the oracle apps forms.Need re-login after setting.The different colours:ColorExampleBlafBlueKhakiOlivePurpleRedTealTitanium  

RelationshipMTL_SECONDARY_INVENTORIESMTL_SECONDARY_INVENTORIES is the definition table for the subinventory. A subinventory is a section of inventory, i.e., raw material, finished goods, etc. Subinventories areassigned to items (in a many to one relationship), indicating a list of valid places where this item will physically exist in inventory.Other attributes include general ledger accounts, demand picking order, locator type, availability type, and reservabletype.You can also specify whether

一篇关于如何成为Oracle E-Business Suit DBA的文章，很短，但里边的提到的一些文档，链接和Webcase还是比较有价值的。 1. 从官方文档开始 E-Business Suite Documentation Library里有着各种值得收藏的文档，内容丰富，覆盖面广。所有想成为DBA可以从下面开始 Oracle E-Business Suite 12.1.3 Concepts Guide 2. 构建一个自己的测试环境 实践是最好的学习方法。你可以下

LPN(License Plate Number) is an object carries the location where it is residing and items that are holding. LPN need not be a physical object, it could be logical grouping. LPN simpley a group of items represented systematically. The major advantage of LPN is less number of transactions. Entire LPN can be transacted at once instead of by each line that LPN holds. In a word,A LPN allows you to logically group items together that physically travel together on the floor.All material received thr

Oracle’s Application Implementation Methodology (AIM) is Oracle\'s project management methodology and implementation strategy. AIM provides documentation templates that support the tasks that must be performed to assist the implementation participants in running and managing projects successfully. One typically doesn\'t use all the available templates, but pick those that will be useful to your project. The methodology and structureThe methodology used is similar to traditional software projec

FND_FUCTION.TEST(Function_Name)Test if function is accessible under current responsibility.TRUE if function is accessible.This function Only checks static function security, and global object type grants from data security.  Because this routine does not take the object id and instance pks, it cannot test for most data security grants, and therefore it should not be used if the object id and/or instance pks are known. This is here for cases where performance is critical, and for backwards

Link:https://blogs.oracle.com/stevenChan/entry/webcast_replay_available_top_10covered the following topics: Check Profile SettingsChange Default PasswordsSecure APPLSYSPUBActivate Server SecurityImplement IP address restrictionsMigrate to Password HashingEnable Application Tier Secure Socket Layer (SSL)Move Off of Client/Server ComponentsSecure Configuration of AttachmentsTurn on ModSecurityEncrypt Credit Card DataSeparation of Duties: Review Access To “Sensitive Administrative Pages”

Script Like:SELECT SUBSTR(B.APPLICATION_SHORT_NAME,1,11) "APPLICATION", SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,50) "CONCURRENT PROGRAM NAME", SUBSTR(A.CONCURRENT_PROGRAM_NAME,1,35) "SHORT NAME" FROM APPS.FND_CONCURRENT_PROGRAMS_VL A, APPS.FND_APPLICATION_VL B WHERE A.APPLICATION_ID=B.APPLICATION_ID AND A.ENABLED_FLAG=\'Y\' AND (Upper(A.USER_CONCURRENT_PROGRAM_NAME) LIKE Upper(\'%purge%\') OR Upper(A.USER_CONCURRENT_PROGRAM_NAME) LIKE Upper(\'%delete

Steven Chan published a very good whitepaper about E-Business Suit + Oracle Exadata.Click: New Whitepaper: Deploying E-Business Suite on Exadata and Exalogic This whitepaper covers the following topics: Scalability and Sizing Examples - provides performance benchmark analysis with concurrent user counts, scaling analysis and sizing recommendationsDeployment Standards - includes recommendations for deploying the various components of the E-Business Suite architecture on ExastackMigration Stan

问：互联网公司的高层（比如360高级产品总监、百度高级产品总监）是怎样炼成的？答：非高管，但比较认可“Facebook COO 桑德伯格2012哈佛商学院毕业演讲”中的一段话原文： CEO Eric Schmidt: "Get on a rocket ship. When companies are growing quickly and having a lot of impact, careers take care of themselves. And when companies aren’t growing quickly or their missions don’t matter as much, that’s when stagnation and politics c

过去的一年，在这里贴了400+的文章（比我预想的要快的多），真心希望朋友们能从这里能有所收获，少走些弯路。新的一年就要开始了，让我们一起继续成长和提高。作为IT从业者，需要多注重些身体，多些锻炼，身体才是革命本钱（年纪越大越发认可这条理论），其他真的都是浮云。  PTIAN2013年2月10日（大年初一）  

Once Sales Order get booked, There will be record go into mtl_sales_orders.Unlike account numbers which are stored as flexfields in GL_CODE_COMBINATIONS, or purchase orders which are stored in PO_HEADERS, sales orders are not assumed to originate in any particular application. MTL_SALES_ORDERS exists for the purpose of mapping sales orders between other applications and Inventory.MTL_SALES_ORDERS is a key flexfield table with no structure defining column or set defining column. The flexfield c

1.LoopDECLARE emp_rec emp%rowtype; CURSOR emp_cur IS SELECT * FROM emp; BEGIN OPEN emp_cur; LOOP FETCH emp_cur INTO emp_rec; EXIT WHEN emp_cur%NOTFOUND;--这个必须有,否则buffer overflow dbms_output.put_line (emp_rec.ename || \' \' ||emp_rec.sal ); END LOOP; CLOSE emp_cur; END; 注：emp_rec必须和emp_cur保持结构一致2.For LoopDECLARE CURSOR emp_cur IS SELECT * FROM emp; BEGIN FOR emp_rec in emp_cur LOOP dbms_output.pu

 * Purchasing:Purchasing Responsibility > Setup > Financials > Accounting > Control Purchasing Periods  * Inventory:Inventory Responsibility > Accouting Close Cycle > Inventory Accounting Periods  * GL:General Ledger Responsibility > Setup > Open/Close  * AP:Payables Responsibility > Setup > Calendar > Accounting > Accounting Periods  * AR: Receivables Responsibility > Control > Accounting > Open/Close Pe

--需要输入set_of_books_id，set_of_books_id可以从GL_SETS_OF_BOOKS查,Demo环境中的Vision Operations (USA)的set_of_books_id是1 SELECT a.period_name, a.period_num, a.gl_status, b.po_status, c.ap_status, d.inv_status FROM (SELECT period_name, period_num, DECODE (closing_status, \'O\', \'Open\', \'C\', \'Closed\',

a) Copy all files except page definition from local machine to appropriate directories.The files such as    Controllers *CO.class    Application modules *AM.class    View Objects *VOImpl.class, *VORowImpl.class, *VO.xml    Entity objects *EO.xml, *EOImpl.javashould be deployed in the $JAVA_TOP/<path of your file>.b) Copy page definition(*PG.xml/*RG.xml) to $PROD_TOP/mdsc) Call java importerThe Page xml files(*PG.xml) and region