2009年05月_feixiangVB

转载 Oracle ERP数据转换论

Oracle ERP 方法体系中属实施管理范畴的是AIM（Application Implementation Method），从下图AIM流程中我们可以看到系统时间轴上共分为六个阶段：需求定义阶段（Definition）业务分析阶段（Operations Analysis）方案设计阶段（Solution Design）建立系统阶段（Build）系统切换阶段（Transitio

2009-05-22 15:46:00 830

转载 What Effects Does 'Replicate Seed Data' Concurrent Request Have On Appls?

The information in this article applies to: Oracle Incentive Compensation - Version: 11.5.8This problem can occur on any platform.GoalSystem wide consequences of running "Replicate Seed Data"

2009-05-22 15:01:00 2134

原创 How the revaluation works or gets calculated--来自Metalink的解释

ACTION PLAN===========As this issue is related to two modulesie, general ledger and Payables, it taking sometime. From the General ledger side , I would explain how the revaluation works or gets ca

2009-05-21 11:04:00 1471

转载 Quantity Invoiced Defaults To Many Decimals In The Match To Receipts Window

Applies to: Oracle Payables - Version: 11.5.9This problem can occur on any platform.FORM:APXRMTCH.FMB - Match to Receipts SymptomsWhen an invoice is matched to a Receipt and the Purchase Order u

2009-05-14 14:38:00 1552

转载查询EBS接口表

select *from dba_objects dbwhere db.object_type = TABLEand db.object_name like %INTERFACE%

2009-05-08 13:23:00 880

转载销售到出仓所经历的表

销售到出仓所经历的表销售订单要经历登记、发放、挑库、交货四个主要环节，有些表在各个环节都有不同的特性，作者罗列了几个主要的常用的表，其它好象还有些货物路线、停靠之类的信息表则没有涉及下面是销售订单的四个主要环节和每个环节用到的常用表：一、登记1、oe_order_headers_all--订单头信息表2、oe_order_lines_all--header_id=oe_order_headers

2009-05-08 11:57:00 1649

原创 Oracle EBS 统计我们客制的报表

SELECT t.user_concurrent_program_name, b.concurrent_program_nameFROM fnd_concurrent_programs_tl t, fnd_concurrent_programs bWHERE b.application_id = t.application_idAND b.concurrent_program_id =

2009-05-08 11:36:00 870

原创已知接受号,如何查这笔接受传到GL的分录?

已知接受号,如何查这笔接受传到GL的分录?1)可否在用户界面查找?2)能否在后台通过关联GL_SL_LINK_ID来查找?RCV_RECEIVING_SUB_LEDGER中的gl_sl_link_id GL_JE_LINES中的gl_sl_link_id把上面两表进行关联查询其实RCV_RECEIVING_SUB_LEDGER表就是接收生成的会计分录信息,在生成这个的同时,也会传一份到

2009-05-08 08:51:00 1895

转载 Diagnostic Scripts: Close Period Notes - Diagnostic SQL Scripts

Checked for relevance on 06-Dec-2007DISCLAIMER: This script is provided for educational purposes only. It is not supported by Oracle World Wide Technical Support. The script has been

2009-05-05 08:41:00 1507

Yuanhy的自由空間