tp's blog | 一路走来

Supermemo

admin — Sat, 04 Sep 2010 04:13:47 +0000

So far,I think supermemo is the best memory software(no ‘one of’) which I have ever used ,you can use it memorize everything which you want.

I mainly use it to memorize English,have used it over 2 months,I think it indeed is a good one to memorize english.

Oracle E-Business Suite R12.1.3 (RUP3) is now Released

admin — Tue, 24 Aug 2010 01:58:44 +0000

You can download the lastest patch form support.oracle.com

Oracle E-Business Suite Release 12.1.3 Release Update Pack(Patch 9239090)

For installation instructions for EBS 12.1.3, see:

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

This release update pack (RUP) combines error corrections, statutory/regulatory updates, and functionality enhancements into a consolidated, suite-wide patch set. This release is a maintenance pack and can only be installed on top of an existing EBS 12.1 environment.

我的oracle面试总结(08年)

admin — Thu, 19 Aug 2010 10:46:14 +0000

下边的当初面试oracle的一些总结（08年写的），虽然比较凌乱但应该也还是有些用处的，现在贴出来方便一些正在面试oracle或者其他外企朋友

第一轮 HR电话面试
目的：主要大体考察你英文的表达能力，如果HR那边觉得基本满足要求就会给你下轮面试机会
题目大概类似如下：
1.描述一下你一天工作的情况是怎么样的？
2.描述一下你现在负责那些模块及具体的细节情况？
3.为什么离职？
4.你能给oracle带来什么？
5.现在的薪资及期望的薪资之类的问题

第二轮经理面试
本轮包括一个Writing Test和一个Face to Face Interview
Writing Test主要考察你英文的写作能力
我考的题目有三：
1.设计在water-fall模型中的应用
2.你能给Oracle带来什么？
3.Oracle EBS为什么把R&D Center设立在深圳？
Face2Face主要是这个部门的老大对你的一个大体的考察，考察之前他会让你对你的技术以及业务打分
这个打分会影响到你后边的笔试题目情况
1分听过 ,没有做过
3分听过并以前简单做过，
5分以前做过，现在没有做了
7分是做过并熟悉，但没有熟练掌握
10分是精通

那个经理会问一些业务问题及一些简单的技术问题，题目不定，其实也是主要看你的英文能力的。
他问我了，描述下Foreign key，采购订单权限相关东东，老外人比较随和，比较好接触

第三轮技术笔试
根据你第二轮打分情况来进行本轮的技术笔试，我的笔试包括Logic Test,Java,SQL,PL/SQL
Logic Test为四道题，任选一道题目来做，那天我大体给你描述了
1.Employee,Manager,Role三个表，给你若干条件
有两问，1.让你插入一个人，他的上级是xx，职位是xx
2.这个人升职了，上级变成xx，职位变为xx
2。没看
3.大体是就是a,b,c,d,e,f盒子，数据库中有一个表记录着b盒子能放多少个a盒子，a盒子能放多少个c盒子,b盒子能放多少个d盒子等等，让你设计一种方法，getxx(X,Y),问Y盒子最多能放多少个X盒子
4.艺术家，画，类型，客户等等
1.画E-R图
2.选出那个画家画的画最多
我的答案：
select top 1 艺术家.name ,count(作品.title) from 作品 group by 作品.艺术家 order by count(作品.title) desc

Java和SQL很简单，就不多少了，都是选择题，基本一眼就能看出答案的那种。
PL/SQL我基本不会，都是乱答的，你可以准备一下

第四轮印度工程师的面试
大概1个多小时，问的很广，那边的口音很奇怪，一开始基本不能适应，你下载些印度的英语听下，方正我一开始很难适应
他问题的很广，从业务到技术什么都有，这轮不好搞，最好多多准备些，问题其实都很简单，主要是能不能听懂印度人说的是什么
比如：
1.介绍一下采购销售流程
2.主键
3.外键
4.索引，索引的一些规则，聚簇索引与非聚簇索引
5.表中有firstname lastname 是否能建索引
6.查找其中有重复firstname和lastname的数据。
7.知道JDBC吗？连接数据库用什么driver。
8.ResultSet
9.知道JDBC吗？连接数据库用什么driver。
10.GC 什么时候进行垃圾收集
11.用过PL/SQL吗？
12.描述一下cursor，存储过程等
13.vector 和 arraylist 有什么区别
14.overload 和 overwrite 有何区别
15.是否用过其他数据库
16.采购订单的一些情况

第五轮
主要就是关于薪酬方面

甲骨文研发中心（深圳）招EBS开发和产品经理

admin — Tue, 17 Aug 2010 05:58:26 +0000

注意两个职位都是@深圳

因为Manager和很多同事都是在美国和印度，所以对英文有一些要求，面试也会是老外面的
最好做过ERP相关产品，薪水看你自己谈的情况了，应该不低，另外还有住房公积金(=salary * 13%)

具体的JD就看下边的了。

有意者发送中英文简历到我的邮箱，我会联系你的

EMAIL:pan.tian@oracle.com/tianpan@gmail.com(不要用163邮箱给我发，谢谢)
MSN:tian.pan@msn.com

==============Applications Engineer=================
Organization Name: E-Business Suite China Development Center (CDC)

Open Positions: 30

Job Title Applications Engineer (IC1/IC2/IC3)

Department description: Oracle’s Applications Division is opening its development center in China with focus on E-Business Suite – a product suite that provides Enterprise Software that enables large multinational companies as well as SMBs (Small and Medium Businesses) to manage their enterprise business needs. Oracles’ E-Business suite is a world-class application suite that covers Supply Chain Management (SCM), Human Capital Management (HCM), Financial Management (FMS), Customer Relationship Management (CRM), and Business Intelligence.

Responsibilities:

As a member of the Applications Engineering team, you will help build the next generation functional and technological capabilities within our enterprise software utilizing Java, J2EE, Web2.0 and other cutting edge technologies. Your responsibilities include:

1. Creation of designs, both high level and detailed design for the software
2. Build the next generation of software capabilities to address needs of global enterprises
3. Participate in the entire software development lifecycle, including design, development, testing, and release of our software

Key Skills Required:

1. BS /MS degree in Computer Science or related engineering discipline

2. Proficiency in one more of the following technologies – Java, J2EE, SQL, PL/SQL

3. Strong Problem Solving and Analytical Skills

4. Ability to communicate in English, both written and verbal, including meetings

5. Result orientation and strong creativity

6. Experience in either one or all of the following is a plus:

a) Oracle Forms, Oracle Reports, XML Publisher & Oracle Application (OA) Framework

7. Experience with Enterprise Software, Business Intelligence / Analytics would be a plus

8. Ability to work independently and as part of a team

==============Product Manager=================
Organization Name: E-Business Suite China Development Center (CDC)

Responsibilities:

As a member of the Product Management team, you will help build the next generation web 2.0 capabilities within our enterprise software: Your responsibilities include,

1. Define product requirements and/or strategy

2. Communicate product strategy and functionality

3. Gather and analyze information to define product requirements and review design specifications

4. Drive functional design projects

5. Initiate and foster relationships with other groups

6. Review product documentation and collateral

7. Ensure successful product releases based on corporate priorities

8. Manage strategic customers for successful implementation

Key Skills Required:

1. BS /MS degree, MBA or equivalent.

2. Strong communication and presentation skills – in English (Written & Verbal)

3. Strong Market and Customer focus

4. Ability to articulate Enterprise Business Solutions

5. Ability to work the virtual ecosystem, marketing, sales, support, and consulting to identify customer needs to build the next generation products

6. Cross-group collaboration along with technical and business acumen with the business applications / solutions space will be valuable

7. Ability to manage, prioritize and deliver multiple projects

8. Experience with Enterprise Software, Business Intelligence / Analytics would be a plus

9. A team player who works well in a challenging and highly collaborative environment

Contact: pan.tian@oracle.com

Location：深圳

Oracle BJ 测试职位热招中

admin — Fri, 23 Jul 2010 05:09:23 +0000

看到Helena发的招聘信息，这里也转下，有兴趣的同学可以发简历给Helena,She is a nice girl

(Senior)QA Analyst – Database
Perform Installation/Upgrade/Sanity Check, Function Testing, Performance Testing, New Feature Evaluation for Oracle Server products including CRS/RAC/Goldengate
Requirement:
BS or above in computer science or equivalent
Extensive experience with Unix platforms
Solid Oracle database experience
DB2 and Sybase experience will be a big plus

(Senior) Linux QA
Perform Installation, Functional, Stress,and Performance testing for Oracle VM and Oracle Enterprise Linux, Working together with development teams to make sure the products released in high quality.
Requirement:
1. Good python and shell programming skill
2. Good working knowledge of C
3. Excellent system-level debugging skills
4. Experience with test automation
5. Experience with one or more Linux distributions
6. Experience with patching and rebuilding Linux packages

(Senior) QA Analyst – Oracle Enterprise Manager Grid Control
Perform function, regression and new feature tests for Oracle Enterprise Manager products in Japanese environment.
Requirement:
1.BS or MS in Computer or related major.
2.Technology background and knowledge of Oracle Database, Enterprise Manager products, Middleware products.
3.Extensive experience with mainstream platforms, including Linux, Windows, Solaris, HP-UX, AIX.
4.Knowledge of Java/J2EE, SOA.

FIN QA Analyst
Work with development team globally to verify the accuracy of software releases throughout the development lifecycle.
Requirement
1. BS or MS in Computer Science, MIS, business or equivalent education/training/experience
2. At least 3 years in software development, business analysis, support or related IT experience. Min. 1 years direct QA experience and work in a team environment or as a solo QA Analyst on FIN function of EBS/PeopleSoft or equivalent ERP system.
3. Excellent written and good verbal communication skills both in Mandarin and English.
4. Experience in automation testing desired.
5. Understanding of environment design, knowledge on UNIX/Linux/Oracle database PL/SQL is desired.

EBS Application QA Engineer (Japanese-speaking)
Ensure the quality of Oracle Applications before release to Japan market
Help APAC customers solve complex business and technical issues, On-site work is required base on project needs
1. BS or MS in Computer, Business, Finance, Industry Engineering or Operations Research.
2. Functional expertise in EBS, Siebel or Hyperion is a must and any the following areas would be a big plus: Agile, OTM, Demantra, Peoplesoft
3. Above 3 years implementation experience is required. At least 2 entire implementation projects experience.
4. Above 2 years Testing experience is required. Experience on testing process, methodology
5. Technical knowledge of Oracle database, PL/SQL, Linux/Unix OS, development experience will be a big plus.
6. Good written and verbal communication skills in Japanese, Good in English.

(Senior) Beehive QA
Perform functional testing for Oracle Beehive product. Working with
global development teams to deliver product in high quality.
Implementing test cases on multiple platforms (Windows, Mac,
Solaris & Linux)
Requirement:
1. Knowledge of Quality Engineering and product lifecycle management
2. 2-3 years QA experience.
3. Self-motivated with strong capability of learning
4. Excellent analytical and trouble shooting skills.
5. Has interest in testing GUI applications.

(Senior) Test developer
1.Provide globalization test development for Oracle Application Server(AS), which including:
OC4J(J2EE), Web Services, ADF, JDeveloper, BPEL, Toplink, DAS, SSO, OCA, UltraSearch, Wireless, Portal…
2. Draft globalization test specs.
3.Design and Program/write globalization test cases (including regression and manual test cases).
4. File and analyze bugs.
5. Automation test development
Requirement:
1. BS or above in computer science or equivalent (BS also need 2+ years of working experience).
2. 2+ years of Java/J2EE programming experience.
3. Solid understanding of Oracle relational database.
4. Good Unix system operation skill.

Senior Quality Engineer – Web application testing

> – Developing test plan, test case for Service Engineering projects

> – Executing test cases for for Service Engineering projects

> – Develop automation test cases

> – Perform performance test

> – Communicating interactively and effectively with English speaking team members in different time zones.

Requirements:

> – Practiced with Scrum software development procedure.

> – Experienced in test cases management and bug tracking system.

> – Strong experience with QA automation, Selenium is plus.

> – Familiar with load testing or bench mark testing, Load runner is plus.

> – Strong experience with browser testing.

> – Strong ability of testing framework design

感兴趣的朋友请将简历发到 helena.cai@hotmail.com
Email subject务必注明: 职位名称_应聘者姓名

Oracle EBS OM – Drop Ship 标准流程

admin — Mon, 12 Jul 2010 14:50:50 +0000

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

How to understand the dataflow for Drop shipment Orders?

To understand, here are the processes divided in sub process and the underline activity is highlighted here:

Here are the Details as per Mark

1.Order Entry

Here the activity is entering process where oe_order_headers_all (flow_status_code as entered) oe_order_lines_all . The order is booked as DROP SHIP

2. Order Booking

3. The Purchase Release program passes information about eligible drop-ship order lines to Oracle Purchasing.The interface table which gets populated is
po_requisitions_interface_all

4. After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders

7. After the goods are successfully received invoices for vendors are created in accounts payables as in normal purchase orders.

8. Invoices are generated for customers In account receivables.

9. oe_order_lines_all (flow_status_code ’shipped’, open_flag “N”)

10. oe_order_lines_all (flow_status_code ‘closed’, open_flag “N”)

DropShip的工作场景：

企业A向客户B销售产品，但是企业A本身并不生产该产品，而是向供应商C来采购，并且在大部分的情况都是C向B直接发货，也就是说企业A大部分的交易都是贸易，属于贸易型企业，除了贸易型企业，对于一些集团公司的销售公司或门店也采用这种销售方式。即‘左手倒右手’。

1.create a item,and ensure this item have purchasable and salable properties.

(according step 4 error,we should also type a value to list price field)

2.Create a sale order,and ensure ‘Source Type’ is ‘External’.

if source type is ‘Internal’,it stand for that you will sale item from your stock.

if source type is ‘External’,it stand for that you will sale item from other supplier.(Drop ship Way)

3.The Purchase Release program passes information about eligible drop-ship order lines to Oracle Purchasing.The interface table which gets populated is

po_requisitions_interface_all

4.After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders

After requisition import,In PR summary form,Try to find your PR.

But can Not find my PR.

Execute below query,

SELECT e.error_message

FROM po_requisitions_interface_all i, PO_INTERFACE_ERRORS e

WHERE i.TRANSACTION_ID = e.INTERFACE_TRANSACTION_ID AND item_id = 25875

Error is:This item is missing a list price in the item master setup window. Please enter a list price greater than zero (0) in the item master.

Then go back to Master item form,type a value to List price,

Becasue Req Import does not pick up interface records that previously failed.we also need update process_flag from ‘ERROR’ to ‘FUTURE’.

Script like:

update po_requisitions_interface_all set process_flag = ’FUTURE’ where item_id = 25875

Then re-run Requisition Import request.PR got generated sucessfully.

5.Auto create PO

6.PO approve

7.Receipt&Delivery

9.After receipt,a sale order issue txn will automaticlly generate.

Sale order line is closed.

Once customer receipt the PO,Then you can take the AR which created by SO to customer,

Customer will give amount 1350 to you.

百公里-在路上，十年

admin — Wed, 24 Mar 2010 04:48:30 +0000

从十年前十几人到现在几千人的队伍在风风雨雨中徒步百公里丈量深圳的尺度，从夜晚到白天24小时唱响了，坚持在坚持，忍耐在忍耐，永不放弃的精神，是百公里的精神。

G哥 88

admin — Tue, 23 Mar 2010 12:32:48 +0000

Google还是决定要退出中国了，听到这个消息，实在令人沮丧。
中午和一屁民吃饭，聊起Google的事情，这个屁民竟说支持中国ZF，中国ZF做得对，让Google知道知道中国政府的厉害。
听了这话，我实在无语，但作为同事，我也只能强压住心中的鄙视，我知道在那种负面情绪下，很可能再说下去会爆粗口。
从来没有体会到网络自由的人，又如何能知道网络自由的可贵。

真的如很多Geeker所说的那样，退住中国这个当今发展最快速的国家，也就Google这个二杆子干得出来。
希望有一天Google能回来。

Crazy Heart

admin — Sat, 20 Mar 2010 12:26:31 +0000

结局咋就不能让人畅快点呢

openbravo

admin — Sat, 20 Mar 2010 06:00:37 +0000

大概试用了下openbravo，界面很玄，主要是SCM相关的业务功能

在线DEMO：http://www.openbravo.com/product/demo-center/erp/#video

需要再花些时间仔细研究下这款open source ERP，貌似基本满足我的需求。

大致的介绍：

Openbravo ERP是一套适合于中小企业并且基于web可扩展的开源ERP系统。它在著名的Compiere ERP的基础上重新开发了适用于各种浏览器的B/S界面并且新增了很多实用功能。

众所周知，企业管理软件(ERP)复杂度高，实施费昂贵，这导致传统的解决方案对中小企业来说是难以接受的。然而，Openbravo相信“每个企业，无论大小，都有权利有他们自己的ERP一一由企业拥有并且按照企业的需求和预算量身订制。” 通过与Bitrock的达成伙伴关系，Openbravo使它的ERP软件对中小企业来说更触手可及。

Openbravo ERP的主要功能

主数据管理

产品，配件，BOM，客户，供应商，员工等

采购管理

采购合同，采购发票，采购计划，货物单据等

库存管理

仓库，库位，编码，包装，标签，入库与出库，库存调拨，库存盘点等

项目/服务管理

项目阶段，项目任务，项目资源，项目预算，项目采购等

生产管理

生产计划，物料需求计划，BOM，派工单，成本核算，日常维护等

销售管理

价格，订单，销售发票，批量折扣，佣金，客户关系管理等

财务管理

会计科目，账户，账套，预算，税率，应收/应付账款，固定资产折旧等

商业智能(ＢＩ)

报表，OLAP，平衡计分表等

Openbravo ERP的技术特性

和所有解决方案一样，Openbravo ERP需要一些额外的软件，比如数据库和web服务器。(考虑到技术复杂度)新的Openbravo安装包允许用户选择已经安装的PostgreSOL或者Oracle10g数据库然后自动连接选中的数据库和已安装的TOMCAT服务器。这为用户提供了选择已安装软件的灵活性，同时又提供了一个快速的用户友好的安装过程。

“我们的目标是使开源软件更易于安装，配置和更新”， “Openbravo”的新用户现在可以仅靠点击几下鼠标就完成安装一个强劲的ERP系统一一对其他ERP系统来说几乎是不可能的。除了提供了这个精简的配置系统，BitRock的技术还可以使安装后的软件更快更容易地更新。”