星期六 六月 08, 2013

Dropship的流程

做的一个Dropship流程的实录(包括流程期间遇到问题的解决)

What are the advantages of Drop Shipment Orders?

These are the benefits:
  • No inventory is required
  • Reduced order fulfillment processing costs
  • Reduced flow times
  • Elimination of losses on non-sellable goods
  • Elimination of packing and shipping costs
  • Reduced inventory space requirements
  • Reduced shipping time to your customer
  • Allows you to offer a variety of products to your customers

1.png
2.png
3.jpg[Read More]

Oracle EBS进化史

通过图表总结了下Oracle EBS的进化历史,回顾历史,Oracle已经在EBS这个产品上耕耘了25年,不得不惊叹这个产品的生命力,Fusion出了之后,R12.2会不会是EBS最后一个Release[Read More]

Oracle EBS Concurrent Request:Gather Schema Statistics

Oracle EBS 的Concurrent Request"Gather Schema Statistics"是一个和性能相关的Concurrent Program,它会对表,列和索引的做数据采样,并生成统计信息。基于成本的优化器(Cost-Based Optimization CBO)会根据你的数据采样来评估执行计划,最终选取一个最高效的方式来执行SQL。

补充一点:数据采样十分类似于问卷调查,假如你的目标群体非常庞大,你就不可能对所有目标客户逐一进行调研,正确有效地做法是在目标人群中挑选一定百分比的人进行调查,最终根据这部分被调查的人来推导出目标人群的情况。

[Read More]

Inventory Picking Rule(Oracle Apps R12) 用于在非WMS组织下,给Sales Order, WIP, OPM Manufacturing设置挑库规则 路径:Inventory > Setup > Rules > Picking Lot: You can sort by lot based on the following criteria: Lot Number Asc: Sorts the lot by number in ascen

Inventory Picking Rule(Oracle Apps R12)

用于在非WMS组织下,给Sales Order, WIP, OPM Manufacturing设置挑库规则

路径:Inventory > Setup > Rules > Picking

  • Lot: You can sort by lot based on the following criteria:

    • Lot Number Asc: Sorts the lot by number in ascending order.

    • Lot Number Desc: Sorts the lot by number in descending order.

    • FIFO: Sorts the lot by first in first out.

    • FEFO: Sorts the lot by first expired first out.

  • Revision: You can sort by revision based on the following criteria:

    • Revision Asc: Sorts by revision in ascending order.

    • Revision Asc: Sorts by revision in descending order.

    • Effective Date Asc: Sorts by revision effective date in ascending order.

    • Effect Date Desc: Sorts by revision effective date in descending order.

  • Subinventory: You can sort by subinventory based on the following criteria:

    • Subinventory Asc: Sorts by subinventory in ascending order.

    • Subinventory: Desc: Sorts by subinventory in descending order.

    • Receipt Date Asc: Sorts by receipt date in ascending order.

    • Receipt Date: Desc: Sorts by receipt date in descending order.

  • Locator: You can choose to sort by locator based on the following criteria:

    • Locator Asc: Sorts by locator in ascending order.

    • Locator Desc: Sort by locator in descending order.

    • Receipt Date Asc: Sorts by receipt date in ascending order.

    • Receipt Date: Desc: Sorts by receipt date in descending order.

创建完一个Picking rule之后,你可以使用Rules Workbench来把Picking Rule规则分配给具体的Item项。Seq的数字越小,优先级越高。


Organization Parameter下边关于Picking Rule的设置

Picking Default里的Rule是用于选择一个默认的rule规则,这个默认的Picking rules用于Order Management来 挑选货物。根据NOTE1327488.1,If it will assign seeded picking rule at Org Paramerts and user define Picking rules in Rules Bench.. Which one is effective?

The Rules workbench has a high priority over the Organization Parameters Picking Rule。

特别注意:This rule will not be employed in a WMS enabled organization. (WMS 的Org不用默认的Org Picking Rule)

Item下Picking Rule的设置

用于设置这个Item默认选取的rule规则。所以Picking Rule可以在Org级设置也可以在Item级制定。


WMS Picking Rule

路径:Warehouse Manager > Setup > Warehouse Configuration > Rules > Warehouse Execution > Rules

INV Rule和WMS Rule的关系:

对于非WMS组织,应该使用Inv的Picking Rule,只有WMS才用上边这个路径来设置Picking Rule。下图为非WMS组织打开WMS Rule form的提示,"WMS Rules / Strategies are not supported in INV org. Use Picking Rules : Inventory -> Setup -> Rule -> picking"

如果是在WMS下,打开WMS Rules form,界面如下:

很明显WMS的Picking Rule能定义更负责的挑库规则。下边为http://www.oracleug.com/user-guide/warehouse-management/overview-picking的一段解释

picking rule in inventory determine the order in which revisions, lots, subinventories, and locators are picked for sales orders.

Picking rule in WMS is used for directed picking creates material allocations and directs operators to pick material from specific locations.

They(INV rule and WMS Rule) workin conjunction with the different pick methodologies. Pick methodologies refer to the different method an operator performs picking tasks. For example, an operator may select to pick an order by itself, or to pick multiple orders at the same time.

The system generates picking tasks and dispatches them to qualified operators based on rules. After picking is complete, the system provides operators with the appropriate number and size of containers the order requires for shipping.


WMS Rule定义的流程

In a WMS Organization,you need to create your rule with following nav path:

Warehouse Manager > Setup > Warehouse Configuration > Warehouse Execution > Rules

After doing that and enabling the rule you should be able to assign rule to Rules Workbench.

Nav Path: Warehouse Manager > Setup > Warehouse Configuration > Warehouse Execution > Rules Workbench

Then you should run Generate All Rules concurrent program

Warehouse Manager > Others > Others > Requests > Requests > Run > Generate All Rules


另外关于Pick Release Rules

路径:Order Management > Shipping > setup > Define Release Rules Forms

Pick Release Rule和Picking Rule 是两个不同的东西,Pick Release rule是一个在做SO Pick Release时的模板,做SO Pick Release的时候,你可以选择不同的模板,这样可以会自动带出Pick Release的预定义选项。(感觉应该改名字叫Release Template,会更清楚些)


INV Picking Rule的后台逻辑

从R12开始,对于非WMS Org,在做Pick Release的时候,WMS Rules Engine会被调用,就是说,对于non WMS organizations,Rule Engine将不会看WMS strategies,它只会看Inventory Picking Rules。

每创建一个新的Rule,在MTL_PICKING_RULES表会插入一条记录,Sample Query:
SELECT * FROM mtl_inv_picking_rules WHERE wms_rule_id = 10533;

几个MTL_PICKING_RULES表中的字段
LOT_SORT:                 0 - NONE, no sort; 1 - Lot number Asc; 2 - Lot number Desc; 3 - FIFO , first in first out; 4 - FEFO, first expire first out
LOT_SORT_RANK:     Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
REVISION_SORT:        0 - NONE; 1 - Revision Asc; 2 - Revision Desc; 3 - Effective date Asc; 4 - Effective date Desc
REVISION_SORT_RANK:Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
SUBINVENTORY_SORT:0 - NONE; 1 - Subinventory Asc; 2 - Subinventory Desc; 3 - Receipt date Asc; 4 - Receipt date Desc
SUBINVENTORY_SORT_RANK:Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
LOCATOR_SORT:        0 - NONE; 1 - Locator Asc; 2 - Locator Desc; 3 - Receipt date Asc; 4 - Receipt date Desc
LOCATOR_SORT_RANK:Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number


当Enable这个Rule之后,在wms_rules_b表也会有对应的记录产生,Sample Query:
SELECT tl.name,tl.description,b.*
FROM wms_rules_b b,wms_rules_tl tl
WHERE b.rule_id = tl.rule_id
AND b.rule_id=10533
AND LANGUAGE = 'US';


Rule Workbench对应的Table是wms_selection_criteria_txn(picking rule assignments),可以使用下边的Query查询Rule Workbench的信息,Sample Query:
Select * from wms_selection_criteria_txn where return_type_id=&rule_id;

并且会动态生成一个新的Package:WMS_RULE_<rule_id>,你可以通过下边的SQL查看WMS_RULE_<Rule_ID>的内容
select text from dba_source where name='WMS_RULE_XXXX';

可以从INV Log中找到,挑库的时候到底使用了那个Rule Id,比如,可以在日志中找到下边的信息
[01-AUG-11 05:57:43] wms.plsql.WMS_Rule_PVT.Apply.l_rule_id: 10533
如果Pick的过程报错,可以在日志中看到下边类似的信息:

wms.plsql.WMS_Engine_PVT.Create_Suggestions.end G_SUGG_FAILURE_MESSAGE: WMS_PICK_NO_ROWS


Reference:

http://www.scribd.com/doc/60058250/WMS-RULE

http://www.oracleug.com/user-guide/warehouse-management/overview-picking

Oracle R12采购接收流程(PR-PO-RCV-AP-Payment)


1.Requisitions

路径:Purchasing > Requisitions > Requisitions


请购单的类型只有两种,一种类型是Internal Requisition,用于内部组织间的物料申请;另外一种类型是Purchase Requisition,用于产生PO,对外部供应商的采购申请。[Read More]

Oracle R12 多组织访问的控制 - MOAC(Multi-Org Access Control)

什么是MOAC

MOAC(Multi-Org Access Control)为多组织访问控制,是Oracle EBS R12的重要新功能,它可以实现在一个Responsibility下对多个Operation Unit(OU)进行操作。MOAC允许用户在不切换responsibility的情况下,在一个responsibility下处理多个OU组织的事 务。

User --> Responsibilities --> Single Operation Unit Mode  /  Multiple Operation Unit Mode


一个应用场景:

某集团公司下边主要分为三个区域(北美,欧洲,亚太),亚太区你是一采购部经理,负责所有七个Operation Unit。
这 种情况下,系统管理员可以创建一个security profile,这个security profile设置成可以访问这七个亚太组织,并把这个security profile赋予到你的responsibility下,这样你就能在同一个职责下访问这七个OU了,就不用不停地切换职责来访问不同OU了。

另外如果你要经常处理中国OU下的事务,那么你可以设置Profile:MO: Default Operating Unit到中国,那么业务默认的OU就是中国了。


[Read More]

Query_Find Form开发入门

1. 打开Template.fmb,并另存为一个名字(QUERYFIND.fmb)


2.从Window,Canvas,Data Block中删除BLOCKNAME从Data Block中删除DETAILBLOCK


3.创建一个Window(DEPT_WINDOW),subclass选择WINDOW


4.Pre-Form trigger中,把DEPT_WINDOW设置为第一个显示的窗口

Program Unit:APP_CUSTOM中,设置关闭窗口的行为


5.定义一个Canvas(DEPT_CANVAS),subclass设置为CANVAS


6.通过Wizard创建Data block:DEPT,在Table中使用DEPT这个部门表


并把这个Block绑定到刚创建的canvas:DEPT_CANVAS

把block:DEPT的subclass设置为BLOCK ,并且把block下边三个字段的subclass都设置为TEXT_ITEM.


7.加载APPSTAND.fmb

把APPSTAND.fmb下的Object Groups中的Query_Find对象组拖到Demo Form中的Object Groups中(选择Copy),

这样window,canvas,datablock有了QUERY_FIND标准对象

然后分别定义QUERY_FIND window,canvas,block的subclass。

打开QUERY_FIND block,可以看到默认会有三个button自动带入。


修改FIND,New按钮的When-Button-Pressed代码,把block:DEPT,替换进去


8.在Query_Find block中增加一个TEXT_ITEM字段,用于在查询时输入部门编码,并记得把这个字段绑定到Query_Find canvas中去。


9.然后把APPSTAND.fmb中的QUERY_FIND trigger拖拽到DEPT block  level(Copy)


把原有的代码改成APP_FIND.QUERY_FIND(‘DEPT_WINDOW’, ‘QUERY_FIND’,'QUERY_FIND’);

补充:Syntax: APP_FIND.QUERY_FIND(<results block window>,<Find window>,<Find window block>);


10.接下来,在DEPT block level创建一个Pre-Query trigger,代码如下:

IF :parameter.G_query_find = 'TRUE' THEN
   COPY(:QUERY_FIND.DEPT_NO,'DEPT.DEPTNO');
  :parameter.G_query_find := 'FALSE';
END IF;

补充:

:parameter.G_query_find为True表示,当前查询为Query Find所触发的。

Pre-Query Syntax:

IF :parameter.G_query_find = TRUE THEN

COPY (<find Window field>,<results field>);

:parameter.G_query_find := FALSE;

END IF;

11.Form:QUERYFIND的属性中,设置First Navigation Data Block为Query_Find

QUERY_FIND block的Next  Navigation Data Block设置为DEPT

12.Compile一把,看看有没有错误。没有错误的话,就可以参考 如何注册一个新的form到EBS系统 把文件注册到系统中了。

13.进入系统,查看功能



Revert R12.1.3 Homepage Layout to Link Style as in R12.1.1 or 11i

Oracle EBS 12.1.3主页的展示方式不太习惯,12.1.3为了展示更多的内容(比如Work List),把职责压缩左侧,如果responsibility很多,找起来很麻烦,因为我对Work List没有要求,所以想恢复到11i或者12.1时候那种传统展示模式(link style)。

修改方法:System Administrator职责下,修改以下Profile

  • FND: Applications Navigator Menu Consolidation count : 25
  • FND Slideout menu: Enabled
  • Enable Configurable HomePage: No
  • FND: Personalization Region Link Enabled: Yes
  • FND: Disable Configurable Home Page: True
The above changes will result in the expandable menus changing to the older 'link style' menus


修改前,12.1.3默认的主页展示


改成11i传统风格展示



更多EBS主页个性化的配置,可以参考:NOTE 1061482.1: 12.1.2: How to Modify and Enable The Configurable Home Page Delivered Via 12.1.2

Dual UOM in Oracle EBS

Dual UOM是随着Process Manufacturing(流程制造)的加入,在Oracle EBS R12中新加的特性。对于Dual UOM的物料,查库存时,Workbench不仅会显示主计量单位(Primary UOM),同时也会显示次计量单位(Secondary UOM)。

Dual UOM适用于特定的行业,比如化工,食品...,具体的例子,以牛肉为例,在欧美常常以磅(Pounds)作为牛肉主计量单位,但中国更习惯使用公斤来作为主计量单位。对于这样的物料就有必要启用双单位控制。


上图中红色部分即为计量单位相关的物料设置。

Primary:主计量单位,所有的物料都需要有一个主计量单位。后台的逻辑运算,报表等也都是基于主计量单位来的。


Tracking:这个就是控制物料是否为双单位的属性。 (组织级别属性)

Primary :库存只显示主计量单位

Primary & Secondary:  库存会同时显示主计量单位以及次计量单位


Pricing:这个属性控制,在计价的时候,价格是基于主计量单位还是次计量单位。(组织级别属性)

如果这个值为Secondary,发运时(Ship Confirmation),系统会在订单行上重新算价格。


Secondary:如果Tracking是Primary & Secondary(Dual UOM Item)或者Pricing为Secondary,那么你在这个数量里设置次计量单位。(组织级别属性)


Defaulting:
Fixed The system stores inventory in both the primary and secondary units of measure. You can enter an item quantity in one unit of measure, and the system converts the quantity to the secondary unit of measure and displays both quantities.

Default The system stores inventory in both the primary and secondary units of measure. You can enter an item quantity in one unit of measure, and the system converts the quantity to the second unit of measure and displays both quantities. You can change the quantity in the secondary unit of measure, without changing the quantity in the primary unit of measure.

No Default The system stores inventory in both the primary and secondary units of measure. Use this option when the default conversion between the two units of measure is usually not the same. The system does not automatically display in the secondary unit of measure when you specify the quantity for the primary unit of measure. You manually enter the quantity of the secondary unit of measure before you process a transaction. The secondary quantity can fluctuate from the default conversion by the factors that you specify in the Deviation + and Deviation - attributes.


Deviation Factor +

You can enter acceptable deviations as decimal values. This attribute is assigned at the organization level. This produces a plus or minus tolerance of acceptability. For example, if the allowable transaction quantity deviation for the item is 10 percent higher

than the established conversion, you would enter 10 in this field.

Deviation Factor -

You can enter acceptable deviations as decimal values. This attribute is assigned at the organization level. This produces a plus or minus tolerance of acceptability. For example, if the allowable transaction quantity deviation for the item is 10 percent lower

than the established conversion, you would enter 10 in this field.



事务处理

对于beef这个物料,defaulting我们设置成了'No Default',所以需要手工输入次计量单位量,100 Lbs(即Pounds) = 45.35924 KG,我这里就输入45.35924到Secondary Qty里。

然 后修改Secondary Qty到50,提示“The quantity entered is higher than the allowed deviation for the item. Please re-enter.”,这是因为,(50 - 45.35924) / 45.35924 = 10.2%,超过了10%误差(Deviation)。

如果把Secondary qty修改成47就不会报上边的提示。这是因为,(47 - 45.35924) / 45.35924 < 10% 误差(Deviation)。


查询库存现有量



报表中的UOM

但是对于很多标准report,现在还只是显示Primary UOM/Qty,不知道以后会不会把Secondary UOM/Qty加到报表中去。

Inventory Value Report


Inventory Quantity Summary Report




Step by Step to Define a BI Publisher Report

这里演示一下,开发一个最简单BI Publisher Report的流程,下图为开发的基本流程.


Data Template(.xml) 作为Data Source,用于数据源的定义,以及取数的SQL语句;

Template(.rtf) 用于定义输出展示(Layout); (RTF:Rich Text Format)


1.首先创建一个Demo数据

  1. CREATE TABLE demo_products  
  2. (  product_code   NUMBER,  
  3.    product_name   VARCHAR2 (100));  
  4. INSERT INTO demo_products  
  5. VALUES (569, 'Oracle Cost Management');  
  6. INSERT INTO demo_products  
  7. VALUES (401, 'Oracle Inventory Management');  
  8. COMMIT;  

2.Define Data Template

Date Template为XML文件,基本的格式如下图


<parameters><parameter>为传入参数项

<dataQuery><sqlStatement>为Report所执行的Query语句

<dataTrigger>用于指定beforeReport或afterReport,调用那个Function/Procedure

<dataStructure>为XML输出的结构


这里创建我们的Data Template文件

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <dataTemplate name="demoProductsDT" description="Demo Products Details" version="1.0">
  3. <parameters>
  4. <parameter name="p_product_id" datatype="number"/>
  5. </parameters>
  6. <dataQuery>
  7. <sqlStatement name="DQ">
  8. <![CDATA[ SELECT product_code, product_name FROM demo_products
  9.                             WHERE product_code = NVL(:p_product_id,product_code) ]]>
  10. </sqlStatement>
  11. </dataQuery>
  12. <dataStructure>
  13. <group name="G_DP" source="DQ">
  14. <element name="PRODUCT_CODE" value="product_code"/>
  15. <element name="PRODUCT_NAME" value="product_name"/>
  16. </group>
  17. </dataStructure>
  18. </dataTemplate>
最后保存成ABC.xml

3.Create Data Definition & Associate with Data Template

XML Publisher Administrator -> Data Definitions -> Create Data Definition


这里的Code会被后边定义的Concurrent Program用到.

接下来,Data Template  'Add File',选择我们第二步定义的XML Data Template.

4.接下来切换到Application Developer职责下,定义一个新的Concurrent Program

注意:
1. Output format应该XML
2. Short Name和之前定义Data Definition中的Code完全一样

What is XDODTEXE used in the Executable section of Concurrent Program?

XDODTEXE is a BI Publisher Data Template Executable. The purpose of this executable is to identify data template file (.xml) and execute the data template to generate the raw xml data, that later can be used by BI Publisher formatting engine to format as as per the layout (RTF, PDF etc).
This executable will be used by all the BI Publisher reports (Concurrent Program) which are using Data Template to generate the xml data.

5.Concurrent Program Parameter

Note:Token is p_product_id. This is the bind parameter we have used in date template. For every bind parameter used in the data template, we have to define parameter in the concurrent program.

6.把这个新定义的Concurrent Program绑定到对应Request Group里

切换到System Admin职责,Security > Responsibility > Request,把刚定义好的Program绑定到一个Request Group里

7.运行Concurrent Program

8.Output

保存上面这个Output成XML格式,我们还需要基于这个xml output做RTF template,RTF Template为了让报表输出更友好,更灵活的展示,而不是只给用户一个XML结果。


9.下载安装XML Publisher Desktop

refer:http://blog.csdn.net/pan_tian/article/details/8283543


10.Define the RTF Template using the Generated Data XML

加载项 > 导入XML数据 导入第8步的output的xml文件


然后“插入” > “表向导”

掠过定义模板的几步,最终RTF模板文件样子大概如下,

11.Registering the Template with BI Publisher

XML Publisher Administrator -> Templates -> Create Template


12.Run the concurrent program to see the output

重新切换到Concurrent Program的定义Form上,更改输出的文件类型,然后文件输出的格式也就随之发生改变






How to Add a Icon to your Oracle Apps Toolbar item

1.准备图片,图片的格式为gif,不是icon或其他格式,图片像素:18×18 pixels
把准备好的图片放到$OA_JAVA/oracle/apps/media下

2.Forms Personalization

Trigger:When-New-Form-Instance

3.Personalization Action

'Icon Name'特别要注意,不要加后缀的'.gif'

效果


JDeveloper Setup for OA Framework

Download JDeveloper

参考下边Note来下载JDev,不同版本的EBS需要下载不同版本的JDev
Note 416708.1 - OA Framework - How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x 

ATG Release 12 Version JDeveloper 10g Patch
12.0.6  (patch 6728000 or patch 7237006) Patch 7523554 10G Jdeveloper With OA Extension ARU for R12 RUP6
12.1.2 (patch 7303033 or patch 7651091) Patch 9172975 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.2
12.1.3 (patch 9239090 or patch 8919491) Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3

不同版本的JDEV包含不同的FND包,所以你必须挑选正确保本的JDEV来下载

Extract the JDeveloper patch

JDev Patch解压后会有三个目录


jdevbin – Includes an extended version of the Oracle JDeveloper 10g executable and OA Framework class libraries.
jdevhome – Includes the OA Framework Toolbox Tutorial source and developer working area.
jdevdoc – Contains documentation


JDEV_USER_HOME Environment Variable

增加一环境变量:JDEV_USER_HOME,值为<install directory>\jdevhome\jdev



Copy a .dbc file to your local dir

通 过putty之类的工具SSH到Apps Server,在$INST_TOP/appl/fnd/12.0.0/secure或者$FND_SECURE目录下找到.dbc文件,把dbc文件拉 到<JDEV_USER_HOME>\dbc_files\secure目录下


dbc文件内包含许多连接数据库的必要参数(比如APPS_JDBC_URL,DB_PORT,DB_HOST...),有点像Oracle数据库的tnsnames.ora配置文件。


Launch your JDeveloper

jdevbin\jdev\bin\jdevW.exe


Create a Database Connection




Hello World

JDev自带了一套Demo Project,你可以用它来测试JDev配置是否正确,File -> Open,<JDEV_USER_HOME>\myprojects\toolbox.jws

右键Tutorial project --> Project Properties --> Runtime Connection

和 正常运行EBS系统不同,在JDev里运行OAF页面,我们没有提供一个responsibilities列表让用户选择,也没有提供一个页面让用户输入 用户名和密码。我做的仅仅是右键一个Page,然后Run。所以系统用户,密码,还有职责的信息,你需要输入到这里"Runtime Connection"。注意:这个用户名和密码是有效的,并且这个用户可以访问对应的职责。

Use below query script to find Application Short Name and Responsibility Key

SELECT A.APPLICATION_SHORT_NAME,R.RESPONSIBILITY_KEY
FROM FND_RESPONSIBILITY R,FND_APPLICATION A ,FND_RESPONSIBILITY_TL TL
WHERE R.APPLICATION_ID = A.APPLICATION_ID
AND R.RESPONSIBILITY_ID = TL.RESPONSIBILITY_ID
AND A.APPLICATION_ID = TL.APPLICATION_ID
AND TL.RESPONSIBILITY_NAME  LIKE 'Inventory%';


Run Options

OADeveloperMode默认都会有的,我需要做的是OADiagnostic加到Selected Options列表中区。

In jDeveloper, you must include OADiagnostic in the “Run Options”. This is effectively similar to setting profile option “FND: Diagnostics” to Yes in eBusiness Suite. Using this option, you will be able to click on ‘Diagnostics’ to enable On-Screen display of debug messages.



Database Connection中,选择刚刚设置的数据库。

还有一个设置,Business Components项下,选择刚才新建的数据库,这步对于仅仅测试下页面来说不是必须的,但是如果后续要新增BC4J组件的时候,就会使用到这个数据库连接。



右键oracle.apps.fnd.framework.toolbox.tutorial.webui.HelloWorldPG.xml,Run


Enjoy...




Some Other Reference

Configuring JDeveloper For Use With Oracle Applications 11i and R12 (Doc ID 330236.1)

How to Run Standard OA Framework Pages from JDeveloper

1.FTP Classes

FTP All the .class & .xml files from $JAVA_TOP/oracle to your local PC, and put them into jdev/jdevhome/myclasses


2.Source Files

From 1st step files,Also need copy necessary PROD files into source file directory: jdev\myprojects\oracle\apps\
eg.If you want to run a WIP module page,Then you can only copy $JAVA_TOP/oracle/apps/wip/xxx/ to jdev\myprojects\oracle\apps\
For source files, we don't need class files, so we can delete all the *.class files from jdev\myprojects\oracle\apps\


NOTE:Remember dont copy unnecessary files and open them in your project. Because when you will run even your HelloWorld page, all these will try to compile and will give you thousands of errors...
Never solve these errors, as they don't exist at all. They are coming just because we have done something wrong....


3.mds Files

FTP files from $PRODUCT_TOP/mds to jdev\myprojects\oracle\apps\PROD, for example copy directories from $WIP_TOP/mds to jdev\myprojects\oracle\apps\wip

(mds:Meta Data Service)


4.JDeveloper Setups and Run

You can follow article "JDeveloper Setup for OA Framework"  to config JDEV,

Except above note, in project properties remove select compiler and in java uncheck the xml validation (it will throw error while compiling)

Path: Project Properties -> Compiler -> XML -> Uncheck XML Syntax on Make


Now run the page you want, it will mostly work...

Forgot one thing, Keep patient, Run OAF files locally, This process(Compiling + OC4J Launching + OAF Page Open) may need long time,depends on your hardware,Enjoy,PTIAN

Period Close Sequence

下图为Oracle EBS关闭期间的时候,各个模块的相互依赖的关系,顺着箭头逐步关闭各模块的期间。比如,Order Management会直接影响应收(Receivables)模块,所以OM模块应先于应收模块关闭。如果图中某个模块没有使用,则可以跳过它,进入下 一个模块。

每个特定模块期间中,Transactions的账户信息在关闭时最终都会Transfer to General Ledger.



所以期间关闭基本是下边这个流程:

1. Order Management / Shipping

2. Cash Management / Treasury

3. Payables

4. Receivables

5. Purchasing

6. Inventory / Costing

7. Projects

8. Assets

9. General Ledger


一篇期间关闭的详细文档:EBS_period_end_close_R12_Final.pdf


Period- End Processing in Oracle Financials (Release 11i)  为期间关闭时各模块更详细的一个TODO List


Payables

  1. Complete All Transactions for the Period Being Closed
  2. Run the Payables AutoApproval Process for All Invoices / Invoice Batches
  3. Review & Resolve Amounts to Post to the General Ledger
  4. Reconcile Payments to Bank Statement Activity for the Period
  5. Transfer All Approved Invoices Payments, Reconciled Payments to the General Ledger
  6. Review the Payables to General Ledger Posting Process After Completion
  7. Submit the Unaccounted Transactions Sweep Program
  8. Close the Current Oracle Payables Period
  9. Accrue Uninvoiced Receipts
  10. Reconcile Oracle Payables Activity for the Period
  11. Run Mass Additions Transfer to Oracle Assets
  12. Open the Next Payables Period
  13. Run Reports for Tax Reporting Purposes (Optional)
  14. Run the Key Indicators Report (Optional)
  15. Purge Transactions (Optional)
Purchasing
  1. Complete All Transactions for the Period Being Closed
  2. Review the Current and Future Commitments (Optional)
  3. Review the Outstanding and Overdue Purchase Orders (Optional)
  4. Follow up Receipts-Check with Suppliers
  5. Identify and Review Un-invoiced Receipts (Period End Accruals)
  6. Follow Up Outstanding Invoices
  7. Complete the Oracle Payables- Period End Process
  8. Run Receipt Accruals - Period End Process
  9. Reconcile Accounts - Perpetual Accruals
  10. Perform Year End Encumbrance Processing. (Optional)
  11. Close the Current Purchasing Period.
  12. Open the Next Purchasing Period.
  13. Run Standard Period End Reports (Optional)
Inventory/WIP
  1. Complete All Transactions for the Period Being Closed.
  2. Check Inventory and Work In Process Transaction Interfaces.
  3. Check Oracle Order Management Transaction Process.
  4. Review Inventory Transactions.
  5. Balance the Perpetual Inventory.
  6. Validate Work In Process Inventory.
  7. Transfer Summary or Detail Transactions
  8. Close the Current Oracle Payables and Oracle Purchasing Periods
  9. Close the Current Inventory Period
  10. Open the Next Inventory Period
  11. Run Standard Period End Reports (Optional)
Order Management
  1. Complete All Transactions for the Period Being Closed
  2. Ensure all Interfaces are Completed for the Period (Optional)
  3. Review Open Orders and Check the Workflow Status
  4. Review Held Orders
  5. Review Discounts
  6. Review Backorders
  7. Review and Correct Order Exceptions
  8. Reconcile to Inventory
  9. Reconcile to Receivables (Optional)
  10. Run Standard Period End Reports
Receivables
  1. Complete All Transactions for the Period Being Closed
  2. Reconcile Transaction Activity for the Period
  3. Reconcile Outstanding Customer Balances
  4. Review the Unapplied Receipts Register
  5. Reconcile receipts.
  6. Reconcile Receipts to Bank Statement Activity for the Period
  7. Post to the General Ledger
  8. Reconcile the General Ledger Transfer Process
  9. Reconcile the Journal Import Process
  10. Print Invoices
  11. Print Statements (Optional)
  12. Print Dunning (Reminder) Letters (Optional)
  13. Close the Current Oracle Receivables Period
  14. Reconcile Posted Journal Entries
  15. Review Unposted Items Report
  16. Open the Next Oracle Receivables Period
  17. Run Reports for Tax Reporting Purposes (Optional)
  18. Run Archive and Purge programs (Optional)
Assets
  1. Complete All Transactions for the Period Being Closed
  2. Assign All Assets to Distribution Lines
  3. Run Calculate Gains and Losses (Optional)
  4. Run Depreciation
  5. Create Journal Entries
  6. Rollback Depreciation and/or Rollback Journal Entries (Optional)
  7. Create Deferred Depreciation Journal Entries (Optional)
  8. Depreciation Projections(Optional)
  9. Review and Post Journal Entries
  10. Reconcile Oracle Assets to Oracle General Ledger Using Reports.
  11. Run Responsibility Reports (Optional)
  12. Archive and Purge Transactions (Optional)
Projects
  1. Change the Current Oracle Projects Period Status from Open to Pending Close
  2. Open the Next Oracle Projects Period
  3. Complete All Maintenance Activities
  4. Run Maintenance Processes
  5. Complete All Transaction Entry for the Period Being Closed
  6. Run the Final Cost Distribution Processes
  7. Interface Transactions to Other Applications (AP, GL, FA)
  8. Generate Draft Revenue for All Projects
  9. Generate Invoices
  10. Run Final Project Costing and Revenue Management Reports
  11. Transfer Invoices to Oracle Receivables
  12. Interface Revenue to General ledger (Project Billing Only)
  13. Run Period Close Exception and Tieback Reports
  14. Change the Current Period Oracle Projects Status from Pending Close to Closed
  15. Advance the PA Reporting Period (Optional)
  16. Update Project Summary Amounts
  17. Restore Access to User Maintenance Activities
  18. Permanently Close the Oracle Projects Period (Optional)
  19. Reconcile Cost Distribution Lines with General Ledger (Optional)
Cash Managment
  1. Load Bank Statements
  2. Reconcile Bank Statements
  3. Create Miscellaneous Transactions
  4. Review AutoReconciliation Execution Report
  5. Resolve Exceptions on the AutoReceonciliation Execution Report
  6. Run Bank Statement Detail Report
  7. Run Transactions Available for Reconcilaition Report
  8. Resolve Un-reconciled Statement Lines
  9. Run the GL Reconciliation Report
  10. Run the Account Analysis Report for the General Ledger Cash Account
  11. Review the Account Analysis Report
  12. Correct any Invalid Entries to the General Ledger Cash Account (Optional)
  13. Perform the Bank Reconciliation
General Ledger
  1. Ensure the Next Accounting Period Status is Set to Future Entry
  2. Complete Oracle Sub-ledger Interfaces to Oracle General Ledger
  3. Upload Journals from ADI (Applications Desktop Integrator) to Oracle General Ledger
  4. Complete Non-Oracle Sub-ledger Interfaces to Oracle General Ledger (Optional)
  5. Generate Reversal Journals (Optional)
  6. Generate Recurring Journals (Optional)
  7. Generate Mass Allocation Journals (Optional)
  8. Review and Verify Journal Details of Unposted Journal Entries
  9. Post All Journal Batches
  10. Run General Ledger Trial Balances and Preliminary Financial Statement Generator Reports (FSGs)
  11. Revalue Balances (Optional)
  12. Translate Balances (Optional)
  13. Consolidate Sets of Books (Optional)
  14. Review and Correct Balances (Perform Reconciliations)
  15. Enter Adjustments and / or Accruals and Post
  16. Perform Final Adjustments
  17. Close the Current Oracle Gneral Ledger Period
  18. Open the Next Oracle General Ledger Period
  19. Run Financial Reports for the Closed Period
  20. Run Reports for Tax Reporting Purposes (Optional)
  21. Perform Encumbrance Year End Procedures (Optional)

Period Navigation

  • Purchasing:Purchasing Responsibility > Setup > Financials > Accounting > Control Purchasing Periods
  • Inventory:Inventory Responsibility > Accouting Close Cycle > Inventory Accounting Periods
  • GL:General Ledger Responsibility > Open/Close
  • AP:Payables Responsibility > Setup > Calendar > Accounting > Accounting Periods
  • AR: Receivables Responsibility > Control > Accounting > Open/Close Period


Reference:Period Close Advisor: E-Business Suite (EBS) (Doc ID 335.1)

Oracle E-Business Suite Upgrade Documents

Oracle E-Business Suite Upgrade Guide Release 11i to 12.1

PDF Version: Link

HTML Version:Link


New Whitepaper: Planning Your E-Business Suite Upgrade from Release 11i to 12.1 (Second Edition)

https://blogs.oracle.com/stevenChan/entry/ebs_121_upgrade_whitepaper


Planning Your Oracle E-Business Suite Upgrade from Release 11i to 12.1 and Beyon

http://www.oracle.com/technetwork/apps-tech/upgrade-planning-2011-1403212.pdf


Upgrading to Oracle E-Business Suite Release 12: Best Practices

https://blogs.oracle.com/stevenChan/resource/images/eweinstein.pdf


Five Key Resources for Upgrading to E-Business Suite Release 12

https://blogs.oracle.com/stevenChan/entry/five_key_resources_for_upgrading_to_ebusiness_suit


11i to R12(12.1.3) Real Experiences of a DBA

http://www.solutionbeacon.com/RealUpgradeExperiences11itoR12.pdf


Four Critical Changes for Customizations in Release 12

https://blogs.oracle.com/stevenChan/entry/four_critical_changes_for_cust


Oracle eBusiness Suite Applications Release 12 Upgrade from Deloitte

http://nooaug.oaug.org/meetings/DeloitteR12UpgradePresentationforNOOAUGAugust2012.pdf


MOS Notes

Planning Your E-Business Suite Upgrade from 11i to Release 12.1 (Note 987516.1)

Upgrade Advisor: E-Business Suite (EBS) Technology Stack Upgrade from 11.5.10.2 to 12.1.2 [ID 253.1]

Upgrade Advisor: E-Business Suite (EBS) Upgrade from 11.5.10.2 to 12.1.3 [ID 269.1]

Planning Your Oracle E-Business Suite (EBS) Upgrade from Release 11i to Release 12 [ID 1406960.1]

Preparing Custom Development for Next Oracle E-Business Suite Release [ID 374398.1]

R12: Upgrade vs. Reimplementation (Financials) [ID 780989.1]

Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade [ID 761570.1]

Oracle E-Business Suite Upgrade Center - Home [ID 461705.1]

Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions [ID 752619.1]
About

  • Pan Tian(田攀)
  • Search

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