1、July 5th,2008Update Date:November 20th,2010Control No:Current Edition:1.0声明：本文可以任意免费转载、复制、传播。但您务必保持其完整性！If you copy this document,you ought to keep the document completely.2D Do oc cu um me en nt t C Co on nt tr ro ol lM Mo od di if fy y R Re ec co or rd dD Da at te eA Au ut th ho or rV Ve er rs si
2、io on nM Mo od di if fi ie ed d r re ef fe er re en nc ce eJuly 5th,2008jarwang1.0A Ap pp pr ro ov ve ed dN Na am me eP Po os si it ti io on ns si ig gn na at tu ur re eD Di is st tr ri ib bu ut te eN Nu um mN Na am me eL Lo oc ca at ti io on n&P Po os si it ti io on n12343I In nd de ex xDocument Co
3、ntrol2Modify Record2Approved2Index3Preface6Application Developer7Value Set7Data Table7Lookups7Data Table7E-R Diagram7Frequently-Used SQL8Query Lookup8Query ValueSet8Values Set8Data Table8E-R Diagram9OPM Process Execution10Formula10Data Table10E-R Diagram10Recipe10Data Table10E-R Diagram11Production
4、Document11Data Table11E-R Diagram12Frequently-Used SQL12Frequently-Used API12Create Batches API13Batches completedAPI16OPM Inventory17Item Master17Data Table17E-R Diagram17Organization18Data Table18E-R Diagram18Inventory Quantity19Data Table19Frequently-Used SQL19Query OPM Organization19Query Lot St
5、atus20Frequently-Used API20OPM Adjust Immediate API20OPM Move Immediate API22Human Resource25HR Employee25Frequently-Used API25Create HR Employee API25Create HR Employee API-FULL27Purchase Order33Requisition334Data Table33E-R Diagram33Purchase Document33Data Table33E-R Diagram34Quotation34Data Table
6、34Receiving35Data Table35E-R Diagram35Position Hierarchy35Data Table35E-R Diagram36Frequently-Used SQL36PO relation ITEM36Query PO37Query PO Quotation40Frequently-Used API40Create PO By Interface40Order Management41Sales Orders41Data Table41E-R Diagram41Deliver41Data Table41E-R Diagram42Frequently-U
7、sed API42Create Sales Order API43Frequently-Used SQL47Query Order47Query Profit Center50Query Monthy Sale Amount50Workflow52Workflow User&Role52Data Table52E-R Diagram53General Legder55Journals55Data Table55E-R Diagram55Frequently-Used SQL56Query GL56OPM GL drilldown PO58Account Receivable59Customer
8、59Data Table59E-R Diagram59Transaction60Data Table60E-R Diagram61Receipts61Data Table61E-R Diagram62Frequently-Used SQL62Query Customer62Query Customer Address63Frequently-Used API63Create AR Invoices API63Create AR Receipts API63Apply AR Receipts API65Accounts Payable675Supplier67Data Table67E-R Di
9、agram67Invoices67Data Table67E-R Diagram68Payment68Data Table68E-R Diagram69Bank69Data Table69E-R Diagram69Frequently-Used SQL70Query Vendor Liability70Query Unpaid Prepayment70Query UnApplied Prepayment70Frequently-Used API74Create AP Invoice Interface table74OPM Cost75Cost Event75Data Table75E-R D
10、iagram75Cost Detail76Data Table76Frequently-Used SQL76Query Cost77Subledger Query-PO78System83System Administrator83Frequently-Used API83Create AR Invoices API83Frequently-Used SQL83Query Request83Other Notes856P Pr re ef fa ac ce eOracle ERP本身异常庞大，因此Oracle ERP的表结构也异常庞大。使用下述语句，可以得到Oracle ERP的表数量有1W多
11、（此方法不精确，但也可以说明表的庞大）。select count（*）from dba_tables dt where dt.tablespace_name=APPS_TS_TX_DATA另外，EBS大多数表都没有Primary Key，Foregin Key，并且大多数表都会有100多列。熟悉EBS全部的表结构有点不太可能，事实上要画出Oracle ERP完整E-R图几乎不可能。对于常用模块的表结构还是得掌握的，否则不熟悉表结构，对Oracle ERP进行二次开发，就无异于难上加难。本文是基于Oracle EBS11.5.10.2。参考文档：http:/ Ap pp pl li ic ca
12、at ti io on n D De ev ve el lo op pe er rV Va al lu ue e S Se et tD Da at ta a T Ta ab bl le e值集表NNO O.T Ta ab bl le eNNa amme eD De es sc cr ri ip pt ti io on nNNo ot te e1APPS.FND_FLEX_VALUE_SETS值集题头表2APPS.FND_FLEX_VALUES值集行明细表视图：FND_FLEX_VALUES_VL3APPS.FND_FLEX_VALUES_TL值集多语言表L Lo oo ok ku up ps
13、sD Da at ta a T Ta ab bl le eE EB BS S中中所所谓谓L Lo oo ok ku up ps s主主要要是是指指提提供供给给L LO OV V组组件件作作为为数数据据源源。例例如如：A AP P发发票票的的I In nv vo oi ic ce e T Ty yp pe e。主主要要涉涉及及二二张张表表：A AP PP PL LS SY YS S.F FNND D_ _L LO OO OK KU UP P_ _T TY YP PE ES S和和A AP PP PL LS SY YS S.F FNND D_ _L LO OO OK KU UP P_ _V VA
14、AL LU UE ES S，由由于于E EB BS S的的多多语语言言，所所以以还还有有一一张张多多语语言言表表A AP PP PL LS SY YS S.F FNND D_ _L LO OO OK KU UP P_ _T TY YP PE ES S_ _T TL L。另另外外L Lo oo ok ku up ps s定定义义时时分分为为系系统统级级、用用户户级级、可可扩扩展展级级。对对于于系系统统级级L Lo oo ok ku up ps s是是不不允允许许修修改改的的。NNO O.T Ta ab bl le eNNa amme eD De es sc cr ri ip pt ti io o
15、n nNNo ot te e1APPLSYS.FND_LOOKUP_TYPES查找代码题头表2APPLSYS.FND_LOOKUP_VALUES查找代码行明细表3APPLSYS.FND_LOOKUP_TYPES_TL查找代码多语言表E E-R R D Di ia ag gr ra ammL Lo oo ok ku up ps s关关联联E E-R R图图8F Fr re eq qu ue en nt tl ly y-U Us se ed d S SQ QL LQ Qu ue er ry y L Lo oo ok ku up p根据类别查找Lookup的值select FLV.LOOKUP_CO
16、DE,FLV.MEANING,FLV.DESCRIPTIONfrom APPLSYS.FND_LOOKUP_VALUES flvwhere flv.lookup_type=VENDOR TYPE-查找代码类别and language=userenv（LANG）;Q Qu ue er ry y V Va al lu ue eS Se et tV Va al lu ue es s S Se et tD Da at ta a T Ta ab bl le eE EB BS S值值集集定定义义表表NNO O.T Ta ab bl le eNNa amme eD De es sc cr ri ip pt ti io on nNNo ot te e1APPLSYS.FND_FLEX_VALUE_SETS值集表2APPLSYS.FND_FLEX_VALUES_TL值表一般使用视图FND_FLEX_VALUES_VL3APPLSYS.FND_FLEX_VALUES值多语言表9E E-
