oracle EBS 学习笔记

1.在11.5.10下的Responsibility"InventoryVisionOperation(USA)",若要切换组织到V1.需要设置如下:方案：切换Responsibility到"OrderManagementSuperUser,VisionOperations(USA)",打开路径Inventory>Setup>Organiziton>OrganizationAccess,创建一行，填入:V1,Inventory,VisionOperations(USA)。然后保存。2.打开库存会计期:方案：Inventory>AccountingCloseCycle>InventoryAccountingPeriods,selectoneperiodandchangestatus.打开总账会计期：方案：GeneralLedgerSuperUser->Setup-->Open/CloseAccountingPeriods3.创建PO时,提示PORev已经存在:方案：打开路径Purchasing>Setup>Organizations>PurchasingOptions,在"PONumber"Generation处选择Automatic.4.做Inter-Orgtransfer事务时，如果输入的Item不被认可，但又确实存在.方案：检查该item是否已经分配到需要转移到的组织下。5.为有Serials属性控制的物料PickRelease时出错:totalSerialnumberdoesnotmatchtransactionquantity.方案：打开路径Inventory>Setup>parametsrsform，点击标签页Rev.lot....,设置AllocateSerials为yes6.做接收时，为Purchasingperiod打开GLdate：方案：Purchasing>Setup>Financials>Accounting>ControlPurchasingPeriods,查找当前的FiscalYear,然后设置该PeriodStatus为Open状态.7.执行一个SO的交货时,提示错误:APP-QA-16134:Youmustenterresultsonthemandatorcollectionplan(s):GeneralReceiving(M1)方案：打开菜单:tools>enterqualityresults8.做杂收时出现提示框："RequestQueued"方案：打开SystemProfile表单,设置如下的profile:查找TP%,然后选择"TP:INVTransactionprocessingmode",在site层和用户层输入值"On-lineprocessing".9.做杂收时提示需要Attribute:Error:MiscRcpt:APP-FND-00828:PleaseentertherequiredcontextfieldvalueinthelotAttributeflexfield.Thecontextfield(alsoknownasastructurefield)appearsasoneofthefirstsegmentsinyourflexfield.方案：若要移除该限制，需要设置DescripitiveFlex.打开路径Inventory->setup->Flexfield->Descriptive->Segments,查找标题"LotAttribute%",然后去掉勾选"FreezeFlexfieldDefinition"、"Required..."以及"Display...",点击Segments按钮,去掉勾选Enabled.最后勾选"FreezeFlexfieldDefinition",点击按钮"Compile".或者打开路径Inventory->setup->Flexfield->Descriptive->Segments,查找标题"AdditionalLineAttributeInformation",去掉勾选"FreezeFlexfieldDefinition",点击Segments按钮,去掉勾选Enabled.最后勾选"FreezeFlexfieldDefinition",点击按钮"Compile".10.做接收检验时，点击完按钮Inspection，出现的form名字是"InspenctDetails",而不是"EnterQualityResults".或者出现错误Error:APP-QA-16235:QualityResultscannotbeenteredbecausenoCollectionPlansapply.方案：设置Profile:查找用户MFG,和profileQA:POInspection,然后在Sizai"OraclePurchasing".11.做发运确认时,出现错误:ActualdeparturedateforstopM2-Boston:BostonisoutsidethecurrentinventoryperiodoforganizationW1-KansasCityDistribution.方案：打开库存会计期:Inventory>AccountingCloseCycle>InventoryAccountingPeriods,找到当前期间并打开.12.日期格式设置:登录application，到Preferences下(在web页面右上角)，然后找到Regional下的日期格式下拉框，选择需要的日期格式。13.做Orderimport时,检查请求的输出,发现错误"noordertype"。方案：打开路径Purchasing>Setup>Organizations>PurchasingOptions,在DocumentDefaults下,InternalRequisitionOrderType选择"Mixed"，然后保存.14.做Requisitionimport时,出现接口方面的问题。方案：首先检查masteritemform里的"Listprice"属性值，若为空，需要输入值.15.做接收时，如果系统提示GLdateofPurcasingisinactive方案：打开路径Purchasing->Setup->Finacials->Accounting->ControlPurchasingPeriods，找到当前期间，打开。16.OrderHeader/OrderLineprocessingconstraint设置：OrderManagement>Setup>Rules>Security>ProcessingConstraints,按F11进行查找，输入以下值：Applicaton=OrderManagementEntity=OrderLine然后按组合键Ctrl+F11查找。然后查找相应的行项目，去掉对应项目的勾选。如果想查看processingconstraint,提交一个request:ProcessingConstraintsListingReport，设置参数：Entity=OrderLineOperation=Cancel17.发运确认时，输入locator,出现错误:EntervalueinsegmentProjectbeforeenteringvalueinTasksegment.方案：若要移除该限制，需要设置KeyFlex.Inventory->Setup->Flexfield->Key->Segments,查找FlexfieldTitle"%StockLocator%",去掉勾选"FreezeFlexfieldDefinition",点击Segments按钮,去掉勾选Project和Task对应的Enabled复选框.然后勾选"Enable"和"FreezeFlexfieldDefinition"复选框,点击按钮"Compile".(最后，需要退出系统再重新打开浏览器登录Application)18.创建RMA申请单时,输入一行，弹出提示框:Failedtoresolveincompatibilitybetweenpricelists(RMA-101-1238654012)Duplicatepricelistlines:Healthcare-InternalandInternalPriceList.方案：打开路径OrderManagement>PriceLists>PriceListSetup,按照错误提示查找Name找到重复的pricelist"Healthcare-Internal",在ListLines标签页找到"AllItems"，然后单击菜单Edit>delete,保存.19.当取消orderline时,出现错误:YouarenotallowedtocancelOrderLinebecause:Linehasbeenpickconfirmed/staged.方案：打开路径OrderManagement>Setup>Rules>Security>ProcessingConstraints,按F11，输入Applocation=OrderManagement,Entity=OrderLine,按组合键Ctrl+F11进行查找。在Constraints栏,查找Operation=Cancel,UserAction=NotAllowed,然后在Conditions标签页查找ValidationEntity=OrderLine,ValidationTemplate=PickReleased,去掉复选框的勾选.保存.20.杂收时，generatelot,出现错误:APP-INV-05373:Failedtogeneratelotnumberautomatically.Pleasechecklotdefaultingcontrols.方案：打开organizationparameterfor，点击Revision,lot...标签页，设置lotdefaultingcontrols=nocontrol.21.快速发运SO时,输入deliverynumber,出现错误:CannotreadvalueforprofileoptionFND_DEVELOPER_MODEinroutine#Routine.方案：设置profile"FND:DeveloperMode"为No。22.设置PO或Receipt默认的OperatingUnit.方案：在user层级上设置profile:"MO:DefaultOperatingUnit"=VisionOperations25.创建Invoice,系统提示GLdateisrequired,pleaseopenpayablesperiod:方案：切换Responsibility到Payables,VisionOperations(USA),打开路径Accounting>ControlPayablesPeriods.输入以下值：Ledger=VisionOperations(USA)OperatingUnit=VisionOperations然后查找当前年份和期间，打开该会计期。26.为一个有PrespecifiedLocator属性控制的Item执行ReceivingTransaction时，无法保存,出现错误:Error:Valueshavenotbeenenteredforoneormorerequiredsegments.方案：首先，设置User层级上的profile"Flexfields:ValidateOnServer"为No；然后,打开路径Inventory->setup->Flexfield->Descriptive->Segments,查找标题"ReceivingTransactions",去掉勾选"FreezeFlexfieldDefinition",按Segments按钮.在globaldataelements下，移除每个segment，然后重新编译。最后，关闭浏览器再重新打开，登录Application。.27.ConcurrentManager当掉了最快捷的办法是找到Actual=Target=0的管理器，查出有pending状态的请求.打开路径Concurrent>Manager>Administrator，点击Request按钮，可以看到request.尝试着激活它，若失败了查找日志。28.在SO行项目Splitline或者改变数量时，出现提示：Note:ORA-06502:PL/SQL:numericorvalueerror:NULLindextablekeyvalueinpackageOE_DBI_UTILProcedureUpdate_DBI_log方案：设置profile"OM:DBIInstallation"=No29.ShippingTransactionForm上没有显示Additional标签页：方案：打开路径OrderManagement>Shipping>Setup>GrantsandRoleDefinitions>DefineRoles,创建newRole,在General标签页,勾选"ConfigureRegions"和"ConfigureButtons",点击按钮"EnableAll",保存。然后打开Grants,设置用户MFG给刚创建的Role，保存然后再打开路径OrderManagement>Shipping>Transactions,点击菜单"Folder>New",创建Folder"Additional",勾选"OpenasDefault","Public"以及"ShowAdditionalTabforLineDetails"。保存。点击菜单"Folder>ShowField...",选择"FromSourceline",点击菜单"Folder>Movedown"来调整位置,也可以同样显示出"ToSourceline"。最后，点击菜单"Folder>Save"。30.提示:Quantityonhandfailstosatisfyreservation方案：首先检查on-handqty,如果数量我为零,可以做杂收来填充数量。31.在SOform,选择一行项目,点击按钮"Configurator",没有Optionsform显示。方案：设置User层级上的profile:"OM:UseConfigurator"=No32.创建SO时，物料的UOM是DZ,提示:CouldnotfindapricelistinOrderedUOMDZandPrimaryUOMoftheitemXXX.方案：打开路径OrderManagement>Pricing>PriceLists>PricesListSetup,通过Name查找Corporate,然后在"ListLines"标签页新建一行,设置如下：ProductValue=itemname,UOM=DZ,输入UnitPrice值。如果出现提示"XXXitemandEanotonCorporate",需要设置ProductAttribute=AllItems,ProductValue=ALL.33.取消orderline时出错:Cancellationisnotqualifiedatthispoint.Quantity"0"isnotallowedforabookedorderifnotcancellation.Pleasedeletethelineinsteadorchangetheprocessingconstraintsetuptoqualifythecancellation.方案：打开路径OrderManagement>Setup>Rules>Security>ProcessingConstraints,按F11查找Applicaton=OrderManagement,Entity=OrderLine,然后启用"Cancel"，选择“RequiresReason„”。34.接收后无请求"ReceivingTransactionProessor"产生。方案：设置User层级上的profile：“RCV:ProcessingMode”=Immdiate或者Batch35.接收或退货时提示需要输入ContextvalueofLotattribute:方案：若要取消该限制，需要设置DescripitiveFlex。打开路径Inventory->setup->Flexfield->Descriptive->Segments,查找标题"LotAttribute%",去掉勾选"FreezeFlexfieldDefinition","Required...",及"Display...",然后点击Segments按钮，去掉勾选Enabled.最后，勾选"FreezeFlexfieldDefinition",点击按钮"Compile"重新编译。36.为Shipping运行接口程序方案：切换到Responsibility"ManufacturingandDistributionManager",打开路径OrderManagement>Shipping>Interfaces>Run,选择Singlerequest"InterfaceTripStop-SRS"，提交。37.设置登录后的起始Form页面Login>点击link"Preferences">在"StartPage"选择Responsibility和Page.点击Apply按钮,登出然后重新登录。或者设置profile:"ApplicationsStartpage",例如值为"MRPCHORG$$$MSC$$$MFG_AND_DIST_SUPER_USER_APS"，意为ManufacturingandDistributionManager里的ChangeOrganization。38.ICX:sessiontimeout这个profile设置你多长时间不操作，再用就需要重新登陆。分钟为计量单位。39.Reservation与AllocationReservationisforreservatingqty,Allocationisforspecifingwhichones,needserialnumbers.40.发运后，运行WorkflowBackgroundProcess以关闭orderline。方案：打开路径Inventory>WorkflowBackgroundEngine,或者Requestsform提交request从.Parameters:OrderType=OMOrderLine41.杂收时，对于有lot属性控制的item，点击按钮"GenerateLot"，系统没反应.方案：打开路径Inventory>Setup>parametsrsform>标签页Rev,Lot....,在"LotControl"框,设置Uniqueness=None,Generation=Atitemlevel,或者Uniqueness=CrossItems，Generation=Atorganizationlevel.42.更改EBS的标题头title:进入系统管理员Profile，查询%SiteName%，修改Site。43.InvoiceEntry输入框被禁用方案：设置User层级上的profile:“AP:UseInvoiceBatchControls”=No44.挑库发放SO的时候，orderline里的 计划 项目进度计划表范例计划下载计划下载计划下载课程教学计划下载 出货的scheduleshipdate必须为当天日期，然后在releaseSO的窗口中设置scheduleshipdate的范围，如果不设置，所有能出货的货物全部出货。45.取消“是否提交其他的请求”提示以下profile在安装时默认为：否(No)--修改为是(Yes)，可以在UserLevel上修改对应的profile如下:Concurrent:ShowRequestsSummaryAfterEachRequestSubmission(并发：提交每个请求后显示请求摘要)46.在接收窗口,Receiving>Receipts>SupplierandInternal为PO接收，Customers为客户退货Receiving>Returns>SupplierandInternal为采购退货47.创建RMA时,找不到referencedSO。方案：检查RMA的customer是否与referenceSO上的customer一致。若不一致，请更正。48.挑库后Backordered了，而没有处于pickconfirmed/staged状态。方案：检查Orgparameters表单上ATP,Pick...标签页上的pickdefaultingrule，设置为default值若要查看pickrule，打开路径Inventory>Setup>Rules>Picking49.接收时，ReceiptHeader窗口提示需要手工输入Receiptnumber.方案：打开路径Purchasing>Setup>Organizations>ReceivingOptions,打开ReceivingOptions页面,设置ReceiptNumberOptionsAction=Automatic。50.打开一个新窗口时不要关闭了其他form：方案：在Application主界面，选择菜单Tool>Closeotherforms,检查它是否处于未勾选状态。=====================以下为摘录的oracleebs应用笔记======================1howtosetupprinterstyle?Systemadministrator->Install->Style2useracreateb.table,defaulttablespaceusebsetup.3inatrigger,don'tneedtocommit,itwillcommitautomaticllywhenend,butitmustbecommittedinaprocedure.4howtousereportsorformsintheforms?aRun_Product(REPORTS,v_appl_path||v_appl_name,SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,NULL);bCall_Form(v_appl_path||v_appl_name,HIDE,NO_REPLACE,NO_QUERY_ONLY,pl_id);fnd_function.execute('MEWPOXPOEPO','Y','Y','PO_HEADER_ID='||:PO.po_header_id||'ACCESS_LEVEL_CODE=VIEW'||'POXPOEPO_CALLING_FORM=MEWITINQ');5howtogetprofilevalues?FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')6wyhcan'tiseechinaeseinPL/SQLDeveloper5.1?regedit,Oracle目录下的NLS_LANG健值简体中文的话改成SIMPLIFIEDCHINESE_CHINA.ZHS16GBK可能的编码：AMERICAN_AMERICA.ZHS16GBK11imodule:OMtable:OE_XXXXXowner:ONTSO_XXX表仍保留，但不使用。11andbeforemodule:OEtable:SO_XXXXXowner:OE8howtotestlocalformsandreportsinEBS11i?FORMS60_PATHD:\cmew_upg\erpform\lib;D:\cmew_upg\erpform\form9SELECT*FROMuser_objectsWHEREobject_nameLIKE'OE\_%'ESCAPE'\';10org_id-->org_name?SELECTL.DESCRIPTIONFROMHR_ALL_ORGANIZATION_UNITSO,HR_LOCATIONSLWHEREL.LOCATION_ID=O.LOCATION_IDANDO.ORGANIZATION_ID=XXXXXX;11应该是没有安装好的问题.下面有一个黄色的横条,就不能与系统外面的数据互相COPY了從正常的機子上複製identitydb.obj12whatistherelationbetweentheapplicationandthejinitiator?applicationJInitiator11.5.91.1.8.2411.5.41.1.8.1611.0.31.1.5.21.113howdotheformrunfirstin11i?form->consolewindow->PROGRESS_INDICATOR->PrimaryCanvas->PROGRESS_INDICATOR(thisisablankcanvas,onlyagraphicitem)先指向一个窗口，canvas表示为进度,一旦pre-formtrigger逻辑完成，就跳转到blockname窗口。由于pre-form逻辑很简单，所以一般PROGRESS_INDICATOR窗口不会出现。导航：inpre-formtrigger，app_window.set_window_position('BLOCKNAME','FIRST_WINDOW');blocknamewindow变成了第一个窗口。14howtotestformsin11i?fnd_message.set_string('Hello,world.');fnd_message.show;15whatiscanvasandwindow?一切显示以window为准，当window大于canvas时，canvas自动扩充显示；当window小于canvas时，canvas被切割16whenre-compileaform,howtoviewthenewresult?exittheoldformpageuntilarrivetothemenunavigator.17howtocallanotherforminaform?FND_FUNCTION.EXECUTE18whenmousemoveanotherrecordintheform,itwillfirewhen-new-record-instancetrigger.datablockleveltrigger,suchaswhen-new-block-instancetrigger,enterablock,itwillbefired.when-new-record-instance,enterarecord,itwillbefired.formleveltrigger,suchaswhen-new-form-instance,enteraform,itwillbefired.19inaform,whenaitemisthedatabaseitem,whenitscolumnnameisblank,item'snamedefaultaccrodwithdatabasecolumnname.20whenwillthereporttakeeffectaftertheparameterischanged?thereportwilltakeeffectafterreusingaresponsibility.21selectxxxxabcfromtable,thealiasabccan'tbeusedinWHEREclause.22howtousedirectXtotestsystem?start->run->dxdiag23howtoadjustareportoutputsize?Layoutmodel-->MainSection-->Property-->WidthandHeightMainReport:UnitofMeasurementselectinchorCentimeter换单位Format-->Layoutoption-->Rulers-->选rulerunit24whenneedrecompileareport?itwillberecompiledoncepl/sqlcodeismodified.itneedn'trecompilewhenadjustthelayoutandpropertyofthereport.25howisdifferentbetweencoaandaccountflexfield?whendefiningacoa,willusethesameaccountflexfield.26howdoIgetthetablenamebytheform?Help-->RecordHistory,cangetthetablenameusedbycertainfieldintheform.27howdoIgetaformname?Help-->AboutOracleApplications,view"CurrentForm"28查询内部请购单responsibility:shippingmenu:requisitions/requisitionssummary29howtomakealayoutforareport?1Reportproperty/UnitofMeasurement:InchCharacterMode/DesigninCharacterUnits:Y2LayoutModel/MainSection/CharacterMode:132*663Format/Layoutoptions/rulers/Units:CharacterCells1,1,Cellsize:6*9.27273Stardardprintstyle:landscape:132*66LANDSCAPE-HPLJ4132*57landwide:180*66landwide-HPLJ4180*5730where,group子句中，如果定义了表和列的别名，必须用表的别名和列的原名，orderby子句中没有规定，可以任意用。31howdoinqueryinformationaboutorg_idandorganization_id？org_id:hr_operating_unitsorganization_id:org_organization_definitions232OMandARsharethesamecustomers33intheDiscoverer,setauserprivilege,ifAdministrationisblank,whentheuserlogonthediscovereradministrationedition,systemwillaskaboutcreatingEUL;isadministrationisselected,userlogonwillnormally.ifNotselectSetPrivilege,usercannotPrivilege.34只需把view的权限授予一个用户，不需要对view的表再一一授权。35报表套打多页，页面下移1report的主体的上下距的设置2打印机的上下边距的设置36whatarestatuscodeforoeheaderandline?oe_order_headers_allflow_status_codein(entered,booked,cancelled,closed)oe_order_lines_allflow_status_codein(AWAITING_RECEIPT,AWAITING_RETURN,AWAITING_RETURN_DISPOSITION,AWAITING_SHIPPING,BOOKED,CANCELLED,CLOSED,ENTERED,FULFILLED,SHIPPED)37whatisflowaboutOM?1Entered2Booked:afterbooked,soline'sstatusis:Awaitingshipping,ReadytoRelease3releaseso:whenreleaseaso,itemsfromsubinventory1(Pickfrom)tosubinventory2(defaultstage)4shipconfirm:allreleasedsolinewillbeconfirmed.5runthereport"WorkflowBackgroundProcess",transferdatafromomtoarinterfacetable.afteritdone,solineisclosed.whenallsolineisclosed,thesoheaderisclosed.6arautoinvoice38releaseso的时候，orderline里的计划出货的scheduleshipdate必须修改为当天日期，然后在releaseso的窗口中设置scheduleshipdate的范围，如果不设置，所有能出货的货物全部出货。******************************************************************************39howtoqueryviewbasedclientenviroment?beginapps.fnd_client_info.set_org_context(p_org_id);end;最彻底的方案就是使用：beginfnd_global.APPS_INITIALIZE(user_id=>1130,resp_id=>50322,resp_appl_id=>660);end;******************************************************************************select*fromOE_TRANSACTION_TYPES.alloperationcanbedonewithinaSQLwindow.40inDiscoverer,ifafoldisfromadatabase,everyitemwillcreateaitemclassautomatically,ifafoldisfromacustomSQL,itmustbemanuallycreatedaitemclass.41created_by->fnd_user.user_idfnd_user.employee_id->per_all_people_f.person_id42whenshipconfirm,theordersthatonlysamedeliveryidcanbedeliveriedtogether.43inOEmenu,Orderorganizerisusedtoinquiresomeinformationsfororders,SalesOrdersisusedtocreateandchangeaorder.44在OM里，来源库，目的库，必须都属于同一个warehouse45oncepickarelease,everyorderlinewillcreateadeliverydetailidfromwsh_delivery_detailstable,butthereleaseactionwillcreateonlydeliveryname(delivery_id)fromwsh_new_deliveries46订单的最终状态：oeheader，oelines:closeddeliverystatus:closedpickstatus:shippedtransactionlinestatus:interfaced47salesordernumberisnumericcreatedbysystemautomaticallyandpurchaseordernumberischaracterinputmanually.48inPO,wheninputandsaveapurchaseorder,thepoheaderstatusis"incomplete"andchangeto"Approved"afteritpasstheapprove.ThePOnumberwillbecreatedautomaticallyifnoinputpo#manually.49Aftercopyingsalesorpurchaseorder,theneworderiscreatedandsavedautomatically.50howdocreatepoandsalesordernumber?purchaseordernumberiscreatedmanually,salesordernumberiscreatedautomatically.51thepostatusisincompletedwhenitsavedandchangetoapprovedafterapproved.52GL,AP,AR,INV,POhaveownperiod,itmustbeopenorcloseforeverymodule.OMhasnoownperiod.53item在主组织进行录入，然后分配给库存组织使用。主组织定义品号，库存组织打开会计期。库存组织不能定义新品号，但可以查询。54pickreleasehastwomethods.办法1：修改或者录入so的时候scheduledshipdate一定要填写适当的日期，releaseso的时候输入确定的日期范围，范围内的so都被release.办法2：scheduledshipdate不用输入具体日期，releaseso前先执行Auto-Createdeliveries，生成交货号，可以对多个so按Ctrl键同时选择。路径：ship/transaction/Auto-createdeliveries55employeeinformationsetupisonmenu:Setup/Organizations/Employees,byINVSuperUserresponsibilityifHRmoduleisabsent.56直发订单，不需releaseso,shipconfirm,但是需要做autoinvoice57howisdifferentbetweeninvoiceand"收据"？itisbyCUST_TRX_TYPE_IDap:ap_invoices_allar:ra_customer_trx_all58直发订单生成直发so后，导入请购单，根据生成的请购单，再自动生成PO59inPO,Receiving>Receipts>SupplierandInternal为PO接收，Customers为客户退货Receiving>Returns>SupplierandInternal为采购退货60internalcompanypoandso,收货方－>发货方－>收货方，先生成internalARinvoice，再生成internalcompanyAPInvoice61出货单由ra_customer_trx_all和ra_customer_trx_lines_all决定，line包含出货单物品内容。装箱单：由oe_order_headers_all,oe_order_lines_all决定组织：o.org_id=:P_org_idORol.ship_from_org_id=:P_org_id内部订单：同普通订单，oe_order_headers_all,oe_order_lines_all,订单行加qp_list_lines.list_header_id=XXXXXX请购单：po_requisition_headers_all，po_requisition_lines_all62oe_order_headers_allsold_from_org_id与org_id对比，是否自身的订单，还是内部直发sold_to_org_idar_customer.customer_idship_from_org_idwarehouse_id哪个仓库发货ship_to_org_idra_site_uses_all.site_use_idship_to_locationinvoice_to_org_idra_site_uses_all.site_use_idbill_to_location63po没有类似的sold_from_org_id，ship_from_org_id，只有一个org_id64invperiodsetup:AccountingCloseCycle/InventoryAccountingPeriodsPO/GL/AP/ARneedcontrolperiod,butOMhasnoperiod.65priceonOM,POandinvOM:有price_list,PO里面没有。oe_order_lines_all.price_list_id=qp_list_lines_v.LIST_HEADER_IDandol.inventory_item_id=ql.product_attr_valueql.operand=list.price订单头和订单行的price_list可以不同，订单行的输入价格受price_list约束。PO:采购单行上的price,list_price分别为po_lines_all中的unit_price,list_price_per_unit,这两个price都可以修改。unit_price×1.17(tax_code)就为含税单价，一般为pl.attribute1INV:item有自己的list_price_per_unit,market_price，表为mtl_system_items_b***********SO的单价是限死的，PO的单价是自己设的***********66itemtypeFG成品SA半成品P原材料OP???67被approve的PO还可以修改，修改后需要re-approve.OMbooked后，还可以modifythesolinesPOcorrections，只是对接收的更正，似乎只能增多，不能减少，减少用退货。退货可以选两种，一种退到supply,交易类型为delivery；一种退到receiver,交易类型为receiving68SO的退货接收分3步1做退货单的RMA类型的SO2退货接收PO/Receiving>Receipts>Customer3退货接收入库PO/Receiving>ReceivingTransaction>Customer第二步所做的接收只做地点接收，没有入库4WorkflowBackgroundengine后做autoinvoice，所生成的发票为：贷项通知书（Creditmemo):供应商对已开发票的货物或劳务，所开的红冲发票69PO一旦被approved,只能通过PurchaseordersummaryorRequisitionSummary来查看information，不能再打开？？？？PO的似乎可以，PR一旦approved，不能再open.70普通additemininventory,selectTransactions/MiscellaneousTransaction/Accountaliasreceipt71IntercompanyARinvoices和intercomapnyAPinvoices都在inv的职责下提交报表72在公司内部订单的时候，ShippingOperatingUnit是发货方，SellingOperatingUnit是收货方73普通直发订单，需要导入生成请购单，最后自动生成订单，做采购接收；内部订单，先手工做请购单，不需要生成采购单，直接做采购接收。因为内部订单接收方只有PR,没有PO，所以最后的AP发票无法做匹配，状态只能是：NeverValidatedAR:CreateintercompanyARInvoices后，还没有生成发票，运行autoinvoices，生成发票；同样的，AP：CreateintercompanyAPInvoices后，还需运行expensereportimport，才生成发票。intercompanyAR/AP的发票号应该一致74howdocallajspinEBSform?web.SHOW_DOCUMENT('http:/