ITPub博客

有时只是想浏览下class文件的内容，使用Eclipse/Netbeans...反编译还是太“笨重”了，推荐一款轻量级Java反编译工具 -- JD-GUIJD-GUI 是一个用 C++ 开发的 Java 反编译工具，由 Pavel Kouznetsov开发，支持Windows、Linux和苹果Mac Os三个平台。JD-GUI下载地址:http://java.decompiler.free.fr/?q=jdgui

QUANTITY_DETAILED:Allocated Quantity.QUANTITY_DELIVERED:Final Transacted Quantity.1. Create move order:Quantity: 10Quantity Delivered: NULLQuantity Detailed: NULLQuantity Required: NULLLine Status: 1 (Incomplete)2. Approve move order:Quantity: 10Quantity Delivered: NULLQuantity Detailed: NULLQuantity Required: NULLLine Status: 3 (Approved)3. Allocate move order for full quantity:Quantity: 10Quantity Delivered: NULLQuantity Detailed: 10Quantity Required: NULLLine Status: 3 (Approved)4. Transact

提问的智慧(How To Ask Questions The Smart Way)作者：Eric Steven Raymond在黑客的世界里，你所提技术问题的解答很大程度上取决于你提问的方式与解决此问题的难度，"提问的智慧"此文将教你如何提问才更有可能得到满意的答复。此文大受欢迎，转载于各大技术论坛的头版。英文版: http://www.catb.org/~esr/faqs/smart-questions.html中文版: http://www.wapm.cn/smart-questions/smart-questions-zh.html &nbs

耗时较长的SQLselect msn.serial_number, msi.description from mtl_system_items_tl msi , mtl_serial_numbers msn where ( UPPER(SERIAL_NUMBER) LIKE :1 AND (SERIAL_NUMBER LIKE :2 OR SERIAL_NUMBER LIKE :3 OR SERIAL_NUMBER LIKE :4 OR SERIAL_NUMBER LIKE :5)) AND ( msn.current_organization_id = msi.organization_id and msn.inventory_item_id = msi.inventory_item_id and msn.inventory_item_id = nvl( :6, msn.inventory_item_id) /* and msn.current_organization_i

Query:SELECT CONCATENATED_SEGS_VIEW_NAME,APPLICATION_TABLE_NAME,DESCRIPTIVE_FLEXFIELD_NAME,TITLE,CONTEXT_COLUMN_NAME,DESCRIPTION FROM FND_DESCRIPTIVE_FLEXS_VL WHERE APPLICATION_ID = 401  --Take Inventory Module as ExampleORDER BY APPLICATION_TABLE_NAME;List:CONCATENATED_SEGS_VIEW_NAMEAPPLICATION_TABLE_NAMEDESCRIPTIVE_FLEXFIELD_NAMETITLECONTEXT_COLUMN_NAMEDESCRIPTIONMTL_ABC_ASSIGNMENT_GROUPS_DFVMTL_ABC_ASSIGNMENT_GROUPSMTL_ABC_ASSIGNMENT_GROUPSABC groupsATTRIBUTE_CATEGORY MTL_ABC_COMP

Category是把具有相似特性的物料分配到一个类别里。Category set是一组Category的合集。The complete set up of item categories is done in below 5 steps in sequence.Tables RelationshipRelated TablesMTL_CATEGORIES_B is the code combinations table for item categories. Items are grouped into categories within the context of a category set to provide flexible grouping schemes.The item category is a key flexfield with a flex code of MCAT. The flexfield structure identifier is a

Standard CostingStandard costing uses predefined costs that are fixed for a specified period of time. Standard Costing enables you to:? Control and measure performance.? Define component costs (material costs) using the projected average acquisition costs and associated indirect costs (material overhead) over the specified period of time.? Roll up assembly costs using bills of material and routings:- Use bills of material to determine the component cost of an assembly.- Use routings to apply b

Basics of Cost Managementhttp://www.oracleug.com/user-guide/cost-management/basics-cost-managementCost Managementhttp://www.oracleug.com/user-guide/cost-management/cost-managementStandard Costinghttp://www.oracleug.com/user-guide/cost-management/standard-costingItem Costinghttp://www.oracleug.com/user-guide/cost-management/item-costingPerform Cost Updatehttp://www.oracleug.com/user-guide/cost-management/perform-cost-updateDefining Cost Typeshttp://www.oracleug.com/user-guide/cost-management/de

任意物料的单位成本等于各个成本要素(Cost Element)的成本之和。物料成本在系统中具体细分为5大要素的成本：Material、Material Overhead、Resource、Outside Processing、Overhead。与实际成本分析中的“料、工、费”对应。1. Material -- The raw material/component cost at the lowest level of the bill of material determined from the unit cost of the component item.材料成本，通常是BOM最底层的组件的直接采购成本。2. Material

接收时报APP-PO-14376的错误,APP-PO-14376: Please enter a GL Date within an open purchasing period.Cause: You provided a GL date that is not within an open purchasing period.Action: Enter a date that is within an open period.解决方法：确保GL,Purchasing,Inventory期间为打开的状态。如何开各个期间，参考：Navigation to Open/Close INV/GL/AR/AP/PO Period To determine the Status of the periods, substitute the pertinent start and end dates in the sql below:GL Period:sele

INV: Restrict Receipt of SerialsThis profile determines if users can receive into stores the serial numbers that have been issued out of inventory and are in status 4 –Issued out of Stores. INV: Validate Returned SerialThis profile option determines whether component serials that are returned from WIP should be validated against serials that are issued to thesame job. The available options are Yes and No. This profile option is updateable only at site level.‘Validate Serial Numbers on RMA

A sequence is a database object that generates unique numbers, mostly used for primary key values. One can select the NEXTVAL and CURRVAL from a sequence. Selecting the NEXTVAL will automatically increment the sequence.Create a sequenceCREATE SEQUENCE INV.MTL_MATERIAL_TRANSACTIONS_S START WITH 22611295 MAXVALUE 4294967295 MINVALUE 1 NOCYCLE CACHE 1000 NOORDER;Selecting from the sequence:SQL> select MTL_MATERIAL_TRANSACTIONS_S.nextval from dual; NEXTVAL ---------- 24177354

ADF Mobile ArchitectureOracle ADF Mobile FAQhttp://www.oracle.com/technetwork/developer-tools/adf/learnmore/adfmobilefaq-1866697.pdfThis series of videos investigates integrating device services such as email, SMS, GPS, picture and contacts, into your ADF Mobile applications. It looks at 4 techniques including using the JDev data control, Java APIs, JavaScript APIs and EL.ADF Mobile - Integrating SMSADF Mobile - Integrating the GPSADF Mobile - Integrating EmailADF Mobile - Integrating the Cam

Gartner 2012 Worldwide RDBMS Market Share Reports 48.3 percent revenue share for Oracle * Gartner has published their market share numbers for 2012 based on total software revenues. According to Gartner, Oracle: Remains #1 in worldwide RDBMS software revenue shareHolds a larger revenue share than four closest competitors combinedLeads next closest competitor revenue share by 29% News Source:http://w

Query to find WIP Job detailsSELECT E.WIP_ENTITY_ID, E.WIP_ENTITY_NAME Job, M.SEGMENT1 ITEM, --M.INVENTORY_ITEM_ID, M.DESCRIPTION Item_Desc, D.DESCRIPTION JOB_DESCRIPTION, M.PRIMARY_UOM_CODE UOM, D.START_QUANTITY Start_Quantity, D.JOB_TYPE Job_Type, D.COMPLETION_SUBINVENTORY Subinventory, D.COMPLETION_LOCATOR_ID Compl_Loc_Id, D.BOM_REVISION BOM_Revision, D.BOM_REVISION_DATE BOM_REVISION_DATE, SUBSTR(TO_CHAR(D.BOM_REVISION_DATE,\'HH24:MI\'),1,5) BOM_TIME, D.SCHEDULED_START_DATE Sc

Performance Coding Standards by Abhijit Ray

Relation between Requisition and PO tables,Here is link:PO_DISTRIBUTIONS_ALL =>PO_HEADER_ID, REQ_DISTRIBUTION_IDPO_HEADERS_ALL=>PO_HEADER_ID, SEGMENT1PO_REQ_DISTRIBUTIONS_ALL =>DISTRIBUTION_ID, REQUISITION_LINE_IDPO_REQUISITION_LINES_ALL =>REQUISITION_LINE_IDPO_REQUISITION_HEADERS_ALL =>REQUISITION_HEADER_ID, REQUISITION_LINE_ID, SEGMENT1What you have to make a join on PO_DISTRIBUTIONS_ALL (REQ_DISTRIBUTION_ID) and PO_REQ_DISTRIBUTIONS_ALL (DISTRIBUTION_ID) to see if there is a

相对于SAP，国内Oracle EBS方面的中文图书真是少之又少，据我了解现在市面上应该只有三本：第一本是《ORACLE财务管理系统教程》，06年出版，之前图书馆借过(市面上好像也不好买到)，写的是Oracle EBS 11i的财务系统，不过因为R12的财务系统相较于11i已经有了较大的改变，所以觉得如果你是使用R12版本，那么这本书只能参考，收获应该有限。然后就是：赵杰夫的《Oracle EBS 入门及

Navigation:Responsibility:Application Developer -> Application -> lookupsLookup screen is available in almost evert superuser responsibility,you can access common lookup screen. Basically records get inserted into FND_LOOKUP_TYPES and FND_LOOKUP_VALUESLookup types are list of values.The Value in the list are hard code,but the mechanism is different from the value set of type independent.The Values are stored in FND_LOOKUP_VALUES,while the values of the independent value set are stored in

HR:Security Profile and MO:Security Profile are used for MOAC (Multi-Org-Access-Control). HR:Security Profile is used to restrict the data in Human Resources according to the Business Group or whatever criteria you define in this security profile. Thus, for HR, it uses this secuity profile in its data exposure to the user. MO:Security Profile acts the same but is used for Financials and Manufacturing applications. It restricts the access (site level or can be set at responsibility level) to ce