ITPub博客

Symptom随便submit一个request，发现几乎所有的Concurrent Manager都为No Manager状态，Phase为Inactive。Solution一个Concurrent Request的生命周期包含不同的阶段(Phase)：Pending, Running, and Completed，并且对于每一个Phase，又可能会有不同的状态。Pending Phase - Normal, Standby, Scheduled, WaitingRunning Phase - Normal, Paused, Resuming, TerminatingCompleted Phase - Normal, Error, Warning, Cancelled, TerminatedInactive Phase - Disabled, On Hold, No

1.定义BOM BOM（物料清单）是WIP的基础，BOM定义了产品的组成结构图，定义了生产特定物料所需的零件及数量。每一个零件也可能有他们的BOM结构，由此产生多层的产品结构树。 比如：一台电脑 = 1 CPU + 1 内存 + 1 硬盘 + 1 显示器  + 1 个鼠标 + 1个键盘 + 30根 数据线 + 50 个螺丝 ，这个电脑的构成就是一个BOM。另外一个硬盘可能又是一个BOM，比如 1 硬盘 =

Syntax of the Create Package CREATE OR REPLACE PACKAGE [body] packagename IS END;Sample: CREATE OR REPLACE PACKAGE overloaded IS PROCEDURE insby(namein VARCHAR2); PROCEDURE insby(numbin PLS_INTEGER); END overloaded; / CREATE OR REPLACE PACKAGE BODY overloaded IS --========================================== PROCEDURE local(namein VARCHAR2, nameout OUT VARCHAR2) IS BEGIN nameout := TRANSLATE(namein,\'AEIOUaeiou\',\'EIOUAeioua\'); END local; --======================================

FND_REQUEST.SUBMIT_REQUEST is an API used to submit a concurrent program in ORACLE Applications. Parameters: Application : Short name of the application associated with the concurrent request to be submitted.  Program - Short name of the concurrent program (not the executable) for which the request should be submitted.  Description - Description of the request that is displayed in the Concurrent Requests form (Optional.)  Start_time - Time at which the request s

API To Find Sales Order\'s Subtotal,discount,charges and Tax (OE_OE_TOTALS_SUMMARY.ORDER_TOTALS)API for Cancelling the Purchase Order (PO) Document (PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT)API for Deleting the category assignment to an item (INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY_ASSIGNMENT)API for Updating Category Assignment of an item (INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY_ASSIGNMENT)API to Book a sales order (OE_ORDER_PUB.PROCESS_ORDER )API to Cancel a Sales Order (OE_ORDER_PUB.PROCE

1. FND_PROFILE.GET(‘Name of the Profile’, variable name);SELECT fnd_profile.value(\'PROFILEOPTION\') ,fnd_profile.value(\'MFG_ORGANIZATION_ID\') ,fnd_profile.value(\'ORG_ID\') ,fnd_profile.value(\'LOGIN_ID\') ,fnd_profile.value(\'USER_ID\') ,fnd_profile.value(\'USERNAME\') ,fnd_profile.value(\'CONCURRENT_REQUEST_ID\') ,fnd_profile.value(\'GL_SET_OF_BKS_ID\') ,fnd_profile.value(\'SO_ORGANIZATION_ID\') ,fnd_profile.value(\'APPL_SHRT_NAME\')

Compile alter package INV.INV_TRANSFER_ORDER_PVT compile; Check error if any show error; C:\Documents and Settings\ptian>sqlplus apps/password@instance SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 7月 16 23:57:18 2012 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter package INV.IN

基于Item Template,导入Item数据1.查找到TEMPLATE_IDSELECT * FROM MTL_ITEM_TEMPLATES_B b,MTL_ITEM_TEMPLATES_TL tl WHERE b.TEMPLATE_ID = tl.TEMPLATE_ID AND tl.TEMPLATE_NAME LIKE \'Purchased Item%\';2.基于模板插入ItemINSERT INTO MTL_SYSTEM_ITEMS_INTERFACE ( process_flag, set_process_id, transaction_type, organization_id, segment1, description, TEMPLATE_ID ) VALUES ( 1, --process_flag 1, --set_process_id \'CREATE\', --transaction_ty

Top Ten List的数据保存在表FND_USER_DESKTOP_OBJECTS中，登陆的时候从这个表读取，然后展示；在用户退出的时候，通过API:FND_SIGNON.UPDATE_NAVIGATOR把新的TOP Ten List更新到FND_USER_DESKTOP_OBJECTS表中。 SQL查看Top Ten List Select function_name, object_name from fnd_user_desktop_objects where user_id =&user_id and responsibility_id = &responsibility_id and application_id = &application_id; --附:查找user_id,responsibility_id,applicati

A DBA’s take on MSCA (Mobile supply chain applications) What is MSCA? MSCA is Oracle’s take on mobile ERP.  In manufacturing, having Oracle on a PC is sometimes inconvenient.  Being able to process certain transactions where they actually happen is a huge win.  So is being able to scan a barcode at this location, instead of typing in a long item number or purchase order number.  Some common examples may be going out to the warehouse and counting inventory, t

Step 1:创建两个目录C:\mwagui\lib和C:\mwagui\log，下载patch:4205328(Mobile Wireless Applications (MWA) J2ME Telnet GUI Client 11.5.10)到C:\mwagui\lib。(patch:4205328有一个包含Mobile手持模拟所需要的java class的zip文件，j4205328.zip)Step 2:下载jdk1.5Step 3:创建一个bat文件，内容:set MWA_GUI_TOP=C:\mwagui\set JAVA_TOP=C:\Program Files\Java\jre1.5.0_08%JAVA_TOP%\bin\java -classpath %JAVA_TOP%\lib\classes.zip;%MWA_GUI_TOP%\lib\j4205328.zip oracle.apps.mwa.awt.c

如果系统里安装了多个ORACLE产品，那么在注册表里，有可能也会有多个ORACLE HOME，在不设置系统环境变量的情况下，默认情况使用哪个ORACLE HOME? HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\DEFAULT_HOME这个值就是默认的ORACLE HOME，有了DEFAULT_HOME的值，你可以在HOME0或HOME1或HOME2...中的ORACLE_HOME_NAME找到对应值，所处的HOMEx就是默认的ORACLE_HOME. 如何在注册表里更改ORACLE_HOME？ 把

什么是NLS_LANG NLS_LANG是一个环境变量，用于定义语言，地域以及字符集属性。对于非英语的字符集，NLS_LANG的设置就非常重要。 NLS：‘National Language Support (NLS)’ 当我们设定一种nls的时候实际上我们是为oracle在存放数据时指定了他的语种所特有的一些表达形式，比如我们选择chinese,那么它的中文字符如何存放,按什么规则排序，货币如何表示，日期格式也就被设定了。 N

Oracle DB中SQL Script注释的语法 REM Single line comment -- Single line comment /* Single line comment */ /* Multi Line comment */ 补充：REM是REMARK的缩写 那么REM和--的区别是什么？ --或者/* */可以用于PL/SQL,但REM[ark]不可以。 下边这段可以在SQL*PLUS中执行成功 REM comment -- comment /* comment */ begin DBMS_OUTPUT.PUT_LINE(\'Test\'); --comment DBMS_OUTPUT.PUT_LINE(\'Test\'); /* comment */ end; /但下

ERROR FRM-92102: A network error has occured. The Forms Client has attempted to reestablish its connection to the Server 1 time(s) without success. Please check the network connection and try again later. FRM-92102 is Gerneric Error maybe occur for more than one reasons : 1-Network 2-Proxy 3-http 4-Session Time But today i will discuss the problem On oracle Application server 10g . Description for the problem like the following when you try to connect on your deploy applica

Picking Release Parameter "Auto Allocate" Path:OM > Shipping > Setup > Shipping Parameter > Pick Release tab >Parameter "Auto Allocate" If check this,while perform "Launch Pick Release" in shipping transaction form,then Allocation will automaticlly be created. "Pick Confirmation Required" Path:Organization Parameter > ATP,Pick,Item-Sourcing > Parameter "Pick Confirmation Required" Select the Pick Confirmation Re

OM System Parameter: Reservation Time Fence Path:Order Management > Setup > System Parameters > Values > "OM System Parameters" Form About parameter "Reservation Time Fence",It means "Time(in days). If the schedule date falls within the reservation time fence,we will reserve it at the time of scheduling" For SO,If (Schedule Date - Order Date) < Parameter:Reservation Time Fence,reservation will be created while performing SO book;else,reservat

How to start&stop WMA MSCA(Mobile) port in R12/11i system Start Mobile new Port R12:cd $INST_TOP/admin/scripts 11i:cd $MWA_TOP/bin mwactl.sh start 10999 Stop Mobile port R12:cd $INST_TOP/admin/scripts 11i:cd $MWA_TOP/bin mwactl.sh -login sysadmin/sysadmin stop_force 10666 or mwactl.sh -login mfg/welcome stop_force 10666 NOTE:sysadmin/sysadmin,mfg/welcome are EBS user account,NOT DB account. 转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7743613

<Incoming material>                          <<Inventory>>                 <Outgoing Material> PO/PR                                                Intra-Org Transfer              SO(OM/Shipping) JOB(Wip Comple

不管哪一家的ERP系统，都是以“平衡供需”为目的、以计划为中心思想的，并将各管理职能作紧密的集成。 因为企业本来就是一个非常复杂的分工与合作的系统，ERP系统只有做到了职能间的高度集成，才能跨职能地通盘规划、达成供需平衡，并有效地执行和控制。 ERP是一种通过计算机系统固化了的管理的方法，它可以让企业更合理地配置企业资源（包括人员、物品、