星期二 六月 04, 2013

WIP Component Pick Release

WIP Component Pick Release是WIP模块的挑库(Picking Release),这个和订单模块的挑库类似,但又有区别。

相同点:不管是WIP还是OM的挑库,他们都会用到挑库规则

区别:订单模块的挑库,是把仓库中的货物挑选出来,然后发往一个临时发货区(Staging Subinventory);

WIP的挑库,目的地取决于WIP Supply Type

1.1. 对于Push类型的工单,如果不指定Supply仓库的话(Supply Subinv为非必填项),WIP Component Pick Release之后并Transact Move Order,那么物料将直接到工单上,相当于做了WIP Component Issue,这种Move Order的Transaction_Type_ID为35。

(参见:Oracle EBS R12 WIP Component Issue&Return Process中例子)

[Read More]

Oracle EBS Key Patches

Release R12.0.X

5082400 - 12.0.1(RUP1 FOR ORACLE APPLICATIONS RELEASE 12)
5484000 - 12.0.2 Release Update Pack (RUP2)
6141000 - 12.0.3 Release Update Pack (RUP3)
6435000 - 12.0.4 Release Update Pack (RUP4)
6728000 - 12.0.6(ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6) )

Release R12.1.X
7303030 - 12.1.1 Maintenance Pack
7303033 - Oracle E-Business Suite 12.1.2 Release Update Pack (RUP2)

7651091 - Oracle Applications Technology Release Update Pack 2 for 12.1 (R12.ATG_PF.B.DELTA.2)
8919491 - Oracle Applications Technology 12.1.3 Product Family Release Update Pack
9239090 - ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK 

                README - Oracle E-Business Suite Release 12.1.3 Readme (Note 1080973.1) 

                Oracle E-Business Suite Release 12.1.3: Release Content Documents (Note 561580.1)


Release 11i
3140000 - Base 11.5.10(Oracle Applications Release 11.5.10)
3240000 - CU1(11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 1)
3460000 - CU2(11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2)  

11i RUP Patches
3480000 - 11.5.10.2 Maintainance
4334965 - RUP3
4676589 - RUP4
5473858 - RUP5
5903765 - RUP6
6241631 - RUP7

INV/RCV Rollup Patch23    - 10111967
INV/RCV Rollup Patch22    - 9878808
INV/RCV Rollup Patch21    - 9649124
INV/RCV Rollup Patch20    - 9466436
INV/RCV Rollup Patch19    - 9265857
INV/RCV Rollup Patch18    - 9063156
INV/RCV Rollup Patch17    - 8403258
INV/RCV Rollup Patch16    - 8403254
INV/RCV Rollup Patch15    - 8403245
INV/RCV Rollup Patch14    - 7666112
INV/RCV Rollup Patch13    - 7581431
INV/RCV Rollup Patch12    - 7258629
INV/RCV Rollup Patch11    - 7258624
INV/RCV Rollup Patch10    - 7258620
INV/RCV Rollup Patch9    - 6870030
INV/RCV Rollup Patch8    - 6461522
INV/RCV Rollup Patch7    - 6461519
INV/RCV Rollup Patch6    - 6461517
INV/RCV Rollup Patch5    - 6449139
INV/RCV Rollup Patch4    - 5739724

------------------------------------

NOTE:CU = Consolidated Update, RUP = RELEASE UPDATE PACK


Related Topic:

How to check whether the patches have been applied or not:http://blog.csdn.net/pan_tian/article/details/7498617
Oracle Application Patch Types :http://blog.csdn.net/pan_tian/article/details/8903284

source:http://blog.csdn.net/pan_tian/article/details/8903076

OPM Demo Flow

OPM全称Oracle Process Manufacturing,即Oracle流程制造,和离散制造(Discrete Manufacturing)不同,流程制造主要应用于制药,食品行业。


Process Manufacturing vs Discrete Manufacturing

流程式制造(Process Manufacturing)是通过一条生产线将原料制成成品,比如集成电路、药品及食品/饮料制造等。
流 程式制造(Process Manufacturing)特点:生产计划方面,计划制定简单,常以日产量的方式下达计划,计划也相对稳定;生产设备的能力固定;生产过程控制方面,工 艺固定,工作中心的安排符合工艺路线。通过各个工作中心的时间接近相同;工作中心是专门生产有限的相似的产品,工具和设备为专门的产品而设计;物料从一个 工作点到另外一个工作点使用机器传动,有一些在制品库存;生产过程主要专注于物料的数量、质量和工艺参数的控制;生产领料常以倒冲的方式进行。

离散式制造(Discrete Manufacturing)是将不同的现成元部件及子系统装配加工成较大型系统,例如电脑、汽车及工业用品制造等。
离散式制造最主要特征为:生产过程中基本上没有发生物质改变,只是物料的形状和组合发生改变,即最终产品是由各种物料装配而成,并且产品与所需物料之间有确定的数量比例,如一个产品有多少个部件,一个部件有多少个零件,这些物料不能多也不能少。

按通常行业划分属于离散行业的典型行业有机械制造业、汽车制造业、家电制造业等等。

[Read More]

Solution for Error: APP-FND-01931 or FRM-92050

使用IE9或者IE8打开Oracle EBS 11i报错"APP-FND-01931 : your session is no longer valid or your logon information could not be reestablished from your session."

或者

使用IE9或者IE8打开Oracle EBS R12报错:“FRM-92050: Failed to connect to the Server /forms/servlet -1


解决方法:

1.Open Internet Explorer
2.Tools Internet Options
3.Select "Security" tab
4.Select "Custom Level" button
5.Scroll down and find "Enable XSS filter" under "Scripting". If it is "Enabled", change it to "Disable"
6.Click OK, Apply, OK
7.Restart the IE,and re-try the problem.

source:http://blog.csdn.net/pan_tian/article/details/8945470


Solution for Error FRM-92095: Oracle Jnitiator version too low

Symtom:

After logging into application, system pop up below error message:

FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher

Cause:

The JRE version is not incompatible.

Solution 1:

This is a workaround solution, For Window 7 user, Add a OS Parameter: JAVA_TOOL_OPTIONS, and parameter value is: -Djava.vendor="Sun Microsystems Inc."

(Not very sure this way works in windows XP or not, You can try it, And pls let me know the result)

Reference:http://www.ora600.be/FRM-92095%3A+Oracle+Jnitiator+version+too+low+-+please+install+version+1.1.8.2+or+higher

Solution 2:

This is a workaround solution as well, Uninstall your JRE 7, and re-install JRE 6

How uninstall JRE 7, Refer: http://www.java.com/en/download/uninstall.jsp

How to install JRE 6,Refer: http://www.java.com/en/download/manual_v6.jsp

Solution 3:

This is root solution, Enable EBS environments for JRE 7, refer: https://blogs.oracle.com/stevenChan/entry/java_jre_1_7_03

source:http://blog.csdn.net/pan_tian/article/details/8000844

星期三 二月 20, 2013

Oracle Metalink Note Search Add-On for Firefox

Wrote a Firefox search add-on which is used to search Oracle Metalink Note/Doc more quickly.


[Read More]

星期二 十月 16, 2012

How to use Chrome to access Oracle Applications

So far,Chrome browser is still not certified by Oracle Application, so you can not access Oracle Apps via Chrome.But you can install a chrome Extension to access Oracle Application(It works fine for 11i or R12 instance)[Read More]

星期一 九月 03, 2012

Oracle EBS订单的流程(Order->AR)

创建订单

路径:Order Management > Orders,Returns > Sales Orders

填写订单头信息,客户,订单类型,销售人员

填写订单体信息,输入物料,数量...

然后Book Order,订单Book之后,你会发现订单头的Status的状态变成了“Booked”,订单行的状态为"Awaiting Shipping",记录下来你的订单号,后边的每一步都需要这个订单号。

状态:订单Book之后,这个时候发运单也就产生了,如果你去Shipping Transactions Form,查找订单,你就会发现发运单的Line Status为Ready to Release,Next Step为Pick Release

[Read More]

星期二 八月 07, 2012

Descriptive Flex Field Sample Code

以Lot Entry中的两个DFF为例,一个是Maintain Lot Number DFF,另一个是Lot Attributes DFF[Read More]

星期二 七月 24, 2012

Oracle EBS R12 WIP Component Issue&Return Process

定义BOM

BOM(物料清单)是WIP的基础,BOM定义了产品的组成结构图,定义了生产特定物料所需的零件及数量。每一个零件也可能有他们的BOM结构,由此产生多层的产品结构树。

比如:一台电脑 = 1 CPU + 1 内存 + 1 硬盘 + 1 显示器  + 1 个鼠标 + 1个键盘 + 30根 数据线 + 50 个螺丝 ,这个电脑的构成就是一个BOM。另外一个硬盘可能又是一个BOM,比如 1 硬盘 = 4组磁盘 + 1个磁盘指针 + 1 个硬盘壳,同样的道理,显示器,内存...都有自己的BOM定义,这样对电脑这个BOM来说,实际上构成了一个庞大的BOM树。

定义Routing

路径:Bill Of Materials > Routings > Routings

Routings(工艺路线)最终解决的问题是生产过程中加工顺序、资源和用量的标准化。Routing是产品/半成品的生产步骤图,定义了生产特定物料所要经历的工序、加工部门(工作中心)、提前期、耗用的资源及其额定数量。

[Read More]

基于Item Template,导入Item数据

基于Item Template,导入Item数据

[Read More]

星期六 七月 14, 2012

Oracle Apps AutoConfig

Oracle Apps的架构非常复杂,使用了非常多技术(或服务)。比如Apache Web server, Apache Jserv, Forms Listener servlet (或forms server) 等等,每一个服务都有着自己的配置文件,只有都设置正确了,系统才能正常运作。而且,Oracle Apps使用了许多的Profile Options(比如Applications Web Agent, Applications Framework Agent等),这些也需要都设置正确,人工管理这么多配置文件,其实并不容易,对于新人来说,学习成本很高。

所以Oracle推出了一个非常强大的工具--Autoconfig(Autoconfig是11.5.4后引入的),用于维护这些配置文件和 Profile Options。我们可以认为AutoConfig是一些系列模板化配置文件的集合,用于配置出一个标准化的应用环境。

[Read More]

Oracle Application R12 (12.1.3) Installation on Linux(64 bit)

Step by Step instructions to install Oracle Applications R12(12.1.1) on Oracle Enterprise Linux 5 are described in this article. This is a single node installation, meaning that the database, all product directories and AD core directories, and all servers (concurrent processing, forms, and Web) are installed on a single node under one common APPL_TOP.

The database node and the Applications node can be installed on the same machine. This type of installation is generally used for small systems or for demonstration purposes. More commonly, the database node is installed on one machine, and the Applications node on another machine. This provides improved manageability, scalability, and performance.

[Read More]
About

  • Pan Tian(田攀)
  • Search

    Categories
    Archives
    « 四月 2014
    星期日星期一星期二星期三星期四星期五星期六
      
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
       
           
    今天