ITPub博客

SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id FROM fnd_user_resp_groups furg, FND_RESPONSIBILITY fr, fnd_responsibility_tl frt, fnd_user fu WHERE fu.user_name =upper(\'ptian\') AND fu.user_id = furg.user_id AND furg.responsibility_id = fr.RESPONSIBILITY_ID AND frt.responsibility_id = fr.RESPONSIBILITY_ID ORDER BY 1

begin fnd_user_pkg.addresp( ‘&User_Name’, /*Application User Name */ ‘&Responsablity_Application_Short_Name’, /*get from Query Below */ ‘&Responsibility_Key’,/*get from Query Below */ ‘&Security_Group’, /* Most of cases it is ‘STANDARD’ so you can hard code it */ ‘&Description’, /* Any comments you want */ ‘&Start_Date’, /* Sysdate From Today */ ‘&End_Date’ ); /* Sysdate + 365 Ri

TablesQP_LIST_HEADERS_BQP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.QP_LIST_LINESQP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. This table stores all types of list lines; price list lines, all types of modifiers including price modifier list lines used to derive factors. The different types of list lines are based on Lookup Type, \'LIST_LINE_TYPE_CODE\'.QP_PRICING_ATTRIBUTESQP_PRICI

Oracle Application Express(APEX),最早叫Oracle HTML DB，一个以Oracle数据库为中心，来开发Web应用的快速开发工具。Architectural Overview主要组件：1.Application Builder用于构建web applications2.SQL Workshop用于创建和管理数据库对象APEX的历史InstallationAPEX is currently supported on on 10.1 and higher. The 11.x version of the database automatically installs Application Express by default.Schema:APEX_xxxxxxHow to Install and De-Install: Note 1086415.

普通的数组语法：TYPE year_type IS TABLE OF number INDEX BY BINARY_INTEGER;The above single statement contains a lot of meaning.  First of all, we are simply defining our own data type, “year_type.” Make sure that “year_type” is not a  variable.  It is a user defined data type.  According to the above statement, “year_type” is a data type which can hold a set (or table) of values (typically of type “number”), organized with a

Here is the small post which describes the potential placed where log files and trace files are present and can be cleaned up. This is requied when you want to free up space on the system.Cleaning up R12 instance:Following are the locations in applmgr side which you can check and clean up. Be careful while cleaning up the log files, because some might be needed for analysis or might contan errors for some reproducible test case. So if you delete some log file which is needed, you might have to

For Discrete ManufacturingQuery Like:SELECT SEGMENT1 ITEM, CST_COST_API.GET_ITEM_COST(1,INVENTORY_ITEM_ID, ORGANIZATION_ID,NULL,NULL) COST FROM MTL_SYSTEM_ITEMS_B WHERE INVENTORY_ITEM_ID = &ITEM_ID AND ORGANIZATION_ID = &ORG_ID;For OPM organization对于OPM组织，上边的Query不适用，需要使用下边的QuerySELECT MSI.SEGMENT1 ITEM, GMF_CMCOMMON.GET_CMPT_COST( INVENTORY_ITEM_ID, ORGANIZATION_ID, SYSDATE, CMM.COST_TYPE_ID ,0) COST FROM MTL_SYSTEM_ITEMS_B MSI, CM_MTHD_MST CMM WH

Transaction Historical Summary Report Use the Transaction Historical Summary Report to report past item quantities, past item value, or past inventory balances. The report calculates historical balances based on a rollback date. The report rolls back all of the transactions for the item to the date you specify and prints the quantity, value, or balance as of that date. In addition, the value and quantity versions let you specify the source type. The report sums the transactions for the item an

Oracle已经提供了一个标准的Report \'Transaction historical summary\'来展示历史上的某一天item的Quantity,Value或者Balance输出结果：其中01-SEP-2012 Quantity表示2012年9月1日时，Item的数量。后边的Current Quantity是指现在系统中的库存量是多少。两个数字中间的Purchase Order，Account，Account Alias, Job or Schedule, Other是指从9月1日到当前，那些业务对数量发生了影响。另外有时候，我们想通过一个SQL Query来

if you upgrade your database from release 10.1 to release 11.1, but you want to keep the release 10.2.0.4 optimizer behavior, you can do so by setting this parameter to 10.2.0.4. At a later time, you can try the enhancements introduced in releases up to and including release 11.1 by setting the parameter to 11.1.0.6.ALTERSYSTEM SET optimizer_features_enable = \'10.2.0.4\';PropertyDescriptionParameter typeStringSyntaxOPTIMIZER_FEATURES_ENABLE = { 8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 | 8.0.7 |

Creating Move OrderDECLARE x_return_status VARCHAR2 (1); x_msg_data VARCHAR2 (4000); x_msg_count NUMBER; l_user_id NUMBER; l_resp_id NUMBER; l_appl_id NUMBER; l_hdr_rec inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec; x_hdr_rec inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec; l_line_tbl inv_move_order_pub.trolin_tbl_type:= inv_move_order_pub.g_miss_trolin_tbl; x_line_tbl inv_move_order_pub.trol

企业管理软件，疏通流程是关键。上ERP这种大型东西，一般是借上系统信息化之名来优化企业或工厂的业务流程。不同的行业有着不同的流程，但基本运作是相通的。下面这张图很清晰的表明了整个EBS的业务操作:库存作业流程物料生产计划流程物料BOM流程采购PO流程订单OM流程工单WIP流程总账会计作业流程上面这些流程图涵盖了大部分的作业操作流程,来源于台湾世新大学的PPT

Using API inv_mo_backorder_pvt.backorder to back order move orderDECLARE CURSOR c_order_det IS SELECT dd.delivery_detail_id, dd.source_code, dd.source_line_id, dd.org_id, dd.source_header_id, dd.source_header_number, dd.source_line_number, NVL (dl.ship_method_code, dd.ship_method_code) ship_method_code, dd.inventory_item_id, (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id = dd.inventory_it

有一个小技巧，Oracle EBS登陆后可以绕过职责和功能的选择过程，就可以直接打开某个特定的Form，这样整个的登陆过程会更快.方法：Oracle Application Home Page > Preferences > Start Page，输入起始的\'Responsibility\'和\'Page\'，Apply之后，重新登陆，就可以绕过职责和功能的选择过程，直接打开某个特定的Form or Page另外，如果设置了Start Page，那么Oracle Application Home Page这个页面就不会展示了

In the Oracle E-Business Suite (EBS) Release 12 the data model of Suppliers has become much more complex. The base tables have changed (Suppliers, Sites, Bank Accounts, Contacts) and some of the fields have become obsolete.Here is a query to bring many of the Supplier attributes together, with focus on banks / bank accounts, payment methods, contacts, remittance delivery (email, notification method). Please post comments if you find any issues!Adjust the WHERE clause on the first WITH query to

Workflow Definition--Workflow Item Type的定义信息select * from wf_item_types where name = \'TPLEAVE\'select * from wf_item_types_tl where name = \'TPLEAVE\'--工作流里各个节点信息select * from wf_activities where item_type = \'TPLEAVE\';--End_Date没数据的那个版本，为当前有效版本--Version有多个，是因为你UPLOAD了多次，每次UPLOAD都会新增一个版本--Function的节点，那么Function中就会有对应的package.procedure的内容，比如ptleave.find_app

Workflow Definition TablesWF_ITEM_TYPESThe WF_ITEM_TYPES table defines an item that is transitioning through a workflow process.WF_ACTIVITIESWF_ACTIVITIES table stores the definition of an activity.Activities can be processes, notifications, functions or folders.A process activity is a modelled workflow process, which can be included as an activity in other processes to represent a sub-process.A notification activity sends a message to a performer. A functions activity performs an automated fu

What is the purpose of Workflow Background ProcessWorkflow Background Process is a concurrent program which is run for processing deferred activities, timed out activities, and stuck processes using the parameters specified. The background engine executes all activities that satisfy the given arguments at the time that the background engine is invoked. This procedure does not remain running long term, so you must restart this procedure periodically. Any activities that are newly deferred or ti

之前写了一篇工作流的Demo文章 - Oracle Workflow Demo (1) - 一个简单的请假申请工作流 ，这篇文章在那个工作流的基础上增加一些功能。增加一个Function来自动的判断Employee的Manager谁，然后把工作流走到那个对应的Manager上新增一个Function，属性中指定一个Procedure，这里可以先指定procedure，再来定义procedure然后在流程图中，新增一个Function图标，并关联上边新创建的Function，如果Result

Run workflow from PL/SQLdeclare v_itemtype varchar2(30):=\'TPLEAVE\'; --Item Type Internal Nam v_process varchar2(30):=\'DEFAULT_PROCESS\'; --Process Name v_itemkey varchar2(30); begin select rcv_transactions_s.nextval into v_itemkey from dual; --Assign a item key wf_engine.createprocess(v_itemtype, v_itemkey,v_process); --Creates a new runtime process for an application item. wf_engine.SetItemAttrText(v_itemtype ,v_itemkey,\'EMPLOYEE\',\'OPERATIONS\'); --Input Param