摘要：
In this DocumentPurposeQuestions and AnswersIntroduction to OpatchGetting and using Opatch utilityMain functionality of OpatchSet PATH environment variableOpatch prerequisite checksArchitecture of InventoriesEnvironment variables used by OPatchMost common commands available with OPatchOpatch –helpIn 阅读全文
摘要：
Oracle Applications DBA has useful collection of SQL scripts. They reside under $AD_TOP/sql. The following list shows the description of each script along with its availability for each Applications release. Script11.0.x10.7NCA10.7SC/16.1Descriptionadcompsc.plsxxxCompile objects in a given schemaadc 阅读全文
摘要：
A SR is a Service Request to Oracle Support; it was previously called a TAR (Technical Assistance Request). SR's can be logged on Oracle's Metalink website.SR Severity Definitions Severity Level 1 (Critical Business Impact) You experience a complete loss of service. Work cannot reasonably co 阅读全文
摘要：
事件：無法關閉分散式工單。概述：原物料異動中有錯誤。問題記錄：1)「成本管理」職責下->檢視異動->暫緩資源異動。2)彈出「搜尋暫緩的資源異動」視窗->依條件填入異動日期欄位->搜尋。3)彈出「暫緩異動」視窗->內有暫緩狀態之資料(表示工單上有資源存在暫緩之狀態)4)並且「重新提交」框無法勾選，工具->選取全部以重新提交，也無法執行。5)以下為oracle support所提供的解決方案：Comments--------Please perform the following action plan on TEST INSTANCE after taking 阅读全文
摘要：
一、平均成本计算用到的几个表1，MTL_CST_TXN_COST_DETAILS(CTCD)记录每一笔事务处理的成本；对于每笔库存事务的记录，这个表中有可能有记录，也有可能没记录；对于那些可以手工设定成本的事务处理，在这个表中有记录，例如，录入成本的杂项事务处理等2，MTL_CST_ACTUAL_COST_DETAILS(CACD)记录了库存物资成本变化的详细信息及平均成本计算的过程；是基于每个成本组的(LAYER_ID)3，CST_QUANTITY_LAYERS(CQL)记录每个成本组的成本信息4，CST_LAYER_COST_DETAILS(CLCD)CQL的明细数据5，CST_ITEM_ 阅读全文
摘要：
Most often, oracle apps developers have to work in different DB instances for development as well as for testing purposes. In such situations we need to get access to different oracle application instances and data base (dev/test/crp etc.,) instances. So we have to request & follow a lengthy app 阅读全文
摘要：
HRMS API's1. Updating the Per_periods_of_service table using hr_ex_employee_api.update_term_details_emp2. Terminating using hr_ex_employee_api.actual_termination_emp3. Applying the final process in the shared instance usinghr_ex_employee_api.final_process_emp4. Re - Hire hr_employee_api.re_hire_ 阅读全文
摘要：
给post表增加一个test字段，test字段类型为stringD:\Ruby\projects\blog>rails generate migration add_test_to_post test:string invoke active_record create db/migrate/20130410145129_add_test_to_post.rbD:\Ruby\projects\blog>rake db:migrate== AddTestToPost: migrating ================================================ 阅读全文
摘要：
黑板http://wenku.baidu.com/view/5d4081a7dd3383c4bb4cd229.html 阅读全文
摘要：
QuestionWhat is Difference between Internal Sales order and Intercompany Sales order ? How they are Different in 11i and R12 AnswerQuestionWhat are the Process Constraints?AnswerProcessing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its.. 阅读全文
摘要：
原文:PO: Tips and useful Query作者:Sanjit Anand来源:http://www.oracleappshub.com/oracle-purchasing/po-tips-and-useful-query/1.列出没有销售订单的内部采购订单---used to list all Internal Requisitions that do not have anassociated Internal Sales orderSelect RQH.SEGMENT1 REQ_NUM,RQL.LINE_NUM,RQL.REQUISITION_HEADER_ID ,RQL.R 阅读全文
摘要：
source:http://apps2fusion.com/at/43-ss/293-extend-a-standard-oracle-mscamwa-pageIn this Article, we will see how to extend a standard Oracle MSCA/MWA pages. It is a common requirement by most of the customers to do some modifications to standard Mobile forms to suit their requirements better. Most c 阅读全文
摘要：
HTMOMSE Sales Order Diagnostic Script [ID 133464.1]To BottomApplies to:Oracle Order Management - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]Information in this document applies to any platform.Main ContentTranslated versions:- Japanese: N/A- Chinese: N/A- Korean: Document 1524392.1Refer t. 阅读全文
摘要：
Order header infoSelect * from oe_order_headers_all oohwhere order_number= :p_order_numberOperating unit infoselect * from hr_operating_unitswhere organization_id=oe_order_headers_all.org_idOrder type infoselect * from apps.oe_transaction_types_tlwhere transaction_type_id=oe_order_headers_all.order_ 阅读全文
摘要：
GoalHow to change the server IP Address in an Oracle Applications environment ?Solution1. Change the IP Address in the Server; 2. Verify the current ip address setup in the Oracle Applications environment. Connect as apps user into SQL*Plus and run:select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER 阅读全文