ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle EBS应用笔记整理(一)

Oracle EBS应用笔记整理(一)

原创 Linux操作系统 作者:palmfuu 时间:2011-07-21 23:19:36 0 删除 编辑

Oracle EBS应用笔记整理(一)

   1. 在11.5.10下的Responsibility "Inventory Vision Operation(USA)", 若要切换组织到 V1. 需要设置如下:

  方案:切换Responsibility 到 "Order Management Super User, Vision Operations(USA)", 打开路径Inventory > Setup > Organiziton > Organization Access, 创建一行,填入: V1, Inventory, Vision Operations(USA)。然后保存。

  2. 打开库存会计期:

  方案:Inventory > Accounting Close Cycle > Inventory Accounting Periods, select one period and change status.

  打开总账会计期:

  方案:General Ledger Super User -> Setup --> Open/Close Accounting Periods

  3. 创建PO时, 提示PO Rev 已经存在:

  方案:打开路径Purchasing > Setup > Organizations > Purchasing Options

  , 在"PO Number " Generation处选择 Automatic.

  4. 做Inter-Org transfer事务时,如果输入的Item不被认可,但又确实存在.

  方案:检查该item 是否已经分配到需要转移到的组织下。

  5. 为有Serials属性控制的物料Pick Release时出错: total Serial number does not match transaction quantity.

  方案:打开路径Inventory > Setup> parametsrs form,点击标签页Rev. lot...., 设置Allocate Serials为yes

  6. 做接收时,为Purchasing period 打开GL date:

  方案:Purchasing > Setup > Financials > Accounting > Control Purchasing Periods, 查找当前的 Fiscal Year, 然后设置该Period Status 为Open状态.

  7. 执行一个SO的交货时, 提示错误: APP-QA-16134: You must enter results on the mandator collection plan(s): General Receiving(M1)

  方案:打开菜单: tools > enter quality results

  8. 做杂收时出现提示框:"Request Queued"

  方案:打开System Profile表单, 设置如下的profile:

  查找 TP%, 然后选择 "TP:INV Transaction processing mode", 在site层和用户层输入值 "On-line processing".

  9. 做杂收时提示需要Attribute:

  Error: Misc Rcpt: APP-FND-00828: Please enter the required context field value in the lot Attribute flexfield. The context field(also known as a structure field) appears as one of the first segments in your flexfield.

  方案:若要移除该限制,需要设置Descripitive Flex.

  打开路径 Inventory->setup->Flexfield->Descriptive->Segments, 查找标题 "Lot Attribute%", 然后去掉勾选 "Freeze Flexfield Definition"、"Required..."以及 "Display...", 点击Segments按钮, 去掉勾选 Enabled. 最后勾选 "Freeze Flexfield Definition", 点击按钮"Compile".

  或者

  打开路径 Inventory->setup->Flexfield->Descriptive->Segments, 查找标题 "Additional Line Attribute Information", 去掉勾选 "Freeze Flexfield Definition", 点击Segments按钮, 去掉勾选 Enabled. 最后勾选 "Freeze Flexfield Definition", 点击按钮"Compile".

  10. 做接收检验时,点击完按钮Inspection,出现的form名字是 "Inspenct Details", 而不是 "Enter Quality Results".

  或者出现错误 Error:

  APP-QA-16235: Quality Results cannot be entered because no Collection Plans apply.

  方案:设置Profile: 查找用户MFG, 和profile QA:PO Inspection, 然后在Sizai"Oracle Purchasing".

  11. 做发运确认时, 出现错误: Actual departure date for stop M2- Boston:Boston is outside the current inventory period of organization W1 - Kansas City Distribution.

  方案:打开库存会计期:

  Inventory > Accounting Close Cycle > Inventory Accounting Periods, 找到当前期间并打开.

  12. 日期格式设置:

  登录application,到Preferences 下(在web页面右上角),然后找到Regional下的日期格式下拉框,选择需要的日期格式。

  13. 做Order import时, 检查请求的输出, 发现错误"no order type"。

  方案:打开路径 Purchasing > Setup > Organizations > Purchasing Options, 在Document Defaults下, Internal Requisition Order Type选择"Mixed",然后保存.

  14. 做Requisition import时, 出现接口方面的问题。

  方案:首先检查 master item form里的"List price"属性值,若为空,需要输入值.

  15.做接收时,如果系统提示 GL date of Purcasing is inactive

  方案:打开路径 Purchasing->Setup->Finacials->Accounting->Control Purchasing Periods,找到当前期间,打开。

  16. Order Header / Order Line processing constraint 设置:

  Order Management > Setup > Rules > Security > Processing Constraints, 按 F11 进行查找,输入以下值:

  Applicaton = Order Management

  Entity = Order Line

  然后按组合键 Ctrl + F11查找。然后查找相应的行项目,去掉对应项目的勾选。

  如果想查看processing constraint, 提交一个request: Processing Constraints Listing Report,设置参数:

  Entity = Order Line

  Operation = Cancel

  17. 发运确认时,输入locator,出现错误: Enter value in segment Project before entering value in Task segment.

  方案:若要移除该限制,需要设置 Key Flex.

  Inventory->Setup->Flexfield->Key->Segments, 查找Flexfield Title "%Stock Locator%", 去掉勾选"Freeze Flexfield Definition", 点击Segments按钮, 去掉勾选Project 和 Task对应的 Enabled 复选框. 然后勾选"Enable"和"Freeze Flexfield Definition" 复选框, 点击按钮 "Compile". (最后,需要退出系统再重新打开浏览器登录Application)

  18. 创建RMA 申请单时, 输入一行,弹出提示框:

  Failed to resolve incompatibility between price lists(RMA-101-1238654012) Duplicate price list lines: Healthcare - Internal and Internal Price List.

  方案:打开路径 Order Management > Price Lists > Price List Setup, 按照错误提示查找Name找到重复的 price list "Healthcare - Internal", 在List Lines标签页找到"All Items" ,然后单击菜单 Edit > delete, 保存.

  19. 当取消order line时, 出现错误:

  You are not allowed to cancel Order Line because:

  Line has been pick confirmed/sed.

  方案:打开路径 Order Management > Setup > Rules > Security > Processing Constraints, 按F11,输入 Applocation= Order Management, Entity=Order Line,按组合键 Ctrl+ F11 进行查找。在Constraints栏, 查找Operation = Cancel, User Action=Not Allowed, 然后在 Conditions 标签页查找 Validation Entity=Order Line, Validation Template = Pick Released, 去掉复选框的勾选. 保存.

  20. 杂收时,generate lot, 出现错误:

  APP-INV-05373: Failed to generate lot number automatically. Please check lot defaulting controls.

  方案: 打开 organization parameter for,点击Revision,lot...标签页,设置

  lot defaulting controls = no control.

  21. 快速发运SO时, 输入delivery number, 出现错误:

  Cannot read value for profile option FND_DEVELOPER_MODE in routine #Routine.

  方案: 设置profile "FND: Developer Mode" 为 No。

  22. 设置PO或 Receipt默认的 Operating Unit.

  方案: 在user层级上设置profile: "MO: Default Operating Unit" = Vision Operations

  25. 创建Invoice, 系统提示 GL date is required, please open payables period:

  方案: 切换Responsibility 到Payables, Vision Operations(USA), 打开路径 Accounting > Control Payables Periods. 输入以下值:

  Ledger = Vision Operations(USA)Operating Unit= Vision Operations

  然后查找当前年份和期间,打开该会计期。

  26. 为一个有Prespecified Locator属性控制的Item执行 Receiving Transaction时,无法保存, 出现错误:

  Error: Values have not been entered for one or more required segments.

  方案: 首先,设置User层级上的profile "Flexfields:Validate On Server" 为 No;

  然后, 打开路径Inventory->setup->Flexfield->Descriptive->Segments, 查找标题"Receiving Transactions", 去掉勾选"Freeze Flexfield Definition", 按Segments按钮. 在global data elements 下,移除每个segment ,然后重新编译。最后,关闭浏览器再重新打开,登录Application。.

  27. Concurrent Manager当掉了

  最快捷的办法是找到Actual=Target=0的管理器,查出有 pending状态的请求.

  打开路径Concurrent > Manager > Administrator,点击Request 按钮,可以看到request. 尝试着激活它,若失败了查找日志。

  28. 在SO行项目Split line或者改变数量时,出现提示

  Note: ORA-06502: PL/SQL: numeric or value error: NULL index table key value in package OE_DBI_UTIL Procedure Update_DBI_log

  方案: 设置 profile "OM: DBI Installation" = No

  29. Shipping Transaction Form上没有显示Additional标签页:

  方案: 打开路径Order Management > Shipping > Setup > Grants and Role Definitions > Define Roles, 创建new Role, 在General 标签页,勾选 "Configure Regions" 和 "Configure Buttons", 点击按钮"Enable All", 保存。 然后打开Grants,设置用户MFG给刚创建的Role,保存

  然后再打开路径Order Management > Shipping > Transactions, 点击菜单 "Folder > New", 创建Folder"Additional", 勾选 "Open as Default", "Public" 以及 "Show Additional Tab for Line Details"。保存。

  点击菜单 "Folder > Show Field...", 选择"From Source line", 点击菜单"Folder > Move down" 来调整位置, 也可以同样显示出"To Source line"。最后,点击菜单"Folder > Save"。

  30. 提示: Quantity on hand fails to satisfy reservation

  方案: 首先检查on-hand qty, 如果数量我为零, 可以做杂收来填充数量。

  31. 在SO form, 选择一行项目, 点击按钮 "Configurator", 没有Options form. 显示。

  方案: 设置User层级上的profile: "OM: Use Configurator" = No

  32. 创建SO时, 物料的UOM 是 DZ, 提示: Could not find a price list in Ordered UOM DZ and Primary UOM of the item XXX.

  方案: 打开路径Order Management > Pricing >Price Lists > Prices List Setup, 通过Name查找Corporate, 然后在"List Lines"标签页新建一行,设置如下:

  Product Value = http://blog.soso.com/qz.q/item name, UOM = DZ, 输入Unit Price值。

  如果出现提示 "XXX item and Ea not on Corporate", 需要设置Product Attribute= All Items, Product Value = http://blog.soso.com/qz.q/ALL.

  33. 取消order line时出错:

  Cancellation is not qualified at this point. Quantity "0" is not allowed

  for a booked order if not cancellation. Please delete the line instead or

  change the processing constraint setup to qualify the cancellation.

  方案: 打开路径Order Management > Setup > Rules > Security > Processing Constraints, 按F11查找 Applicaton = Order Management, Entity = Order Line, 然后启用 "Cancel" ,选择"Requires Reason"。

  34. 接收后无请求"Receiving Transaction Proessor" 产生。

  方案:设置User层级上的profile: "RCV: Processing Mode" = Immdiate 或者 Batch

  35. 接收或退货时提示需要输入 Context value of Lot attribute :

  方案:

  若要取消该限制,需要设置Descripitive Flex。

  打开路径 Inventory->setup->Flexfield->Descriptive->Segments, 查找标题"Lot Attribute%", 去掉勾选 "Freeze Flexfield Definition", "Required...", 及"Display...", 然后点击Segments 按钮, 去掉勾选 Enabled. 最后, 勾选 "Freeze Flexfield Definition", 点击按钮"Compile"重新编译。

  36. 为Shipping运行接口程序

  方案:切换到 Responsibility "Manufacturing and Distribution Manager", 打开路径Order Management > Shipping > Interfaces > Run, 选择Single request "Interface Trip Stop - SRS",提交。

  37. 设置登录后的起始Form页面

  Login > 点击link "Preferences" > 在"Start Page"选择 Responsibility 和 Page. 点击Apply 按钮, 登出然后重新登录。

  或者设置 profile: "Applications Start page", 例如值为 "MRPCHORG$$$MSC$$$MFG_AND_DIST_SUPER_USER_APS" ,意为Manufacturing and Distribution Manager里的Change Organization 。

  38. ICX:session timeout

  这个profile设置你多长时间不操作,再用就需要重新登陆。分钟为计量单位。

  39. Reservation 与 Allocation

  Reservation is for reservating qty, Allocation is for specifing which ones, need serial numbers.

  40. 发运后,运行Workflow Background Process 以关闭order line。

  方案:打开路径 Inventory > Workflow Background Engine, 或者Requests form提交request从.

  Parameters: Order Type = OM Order Line

  41. 杂收时,对于有 lot 属性控制的item,点击按钮"Generate Lot" ,系统没反应.

  方案:打开路径 Inventory > Setup> parametsrs form. > 标签页 Rev,Lot...., 在"Lot Control"框, 设置Uniqueness = None, Generation = At item level, 或者Uniqueness = Cross Items ,Generation = At organization level.

  42. 更改EBS的标题头 title: 进入系统管理员Profile, 查询 %Site Name%, 修改Site。

  43. Invoice Entry输入框被禁用

  方案:设置User层级上的profile: "AP: Use Invoice Batch Controls" = No

  44. 挑库发放SO的时候,order line里的计划出货的schedule ship date必须为当天日期,然后在release SO的窗口中设置schedule ship date的范围,

  如果不设置,所有能出货的货物全部出货。

  45. 取消"是否提交其他的请求"提示

  以下profile在安装时默认为:否(No)--修改为是(Yes),可以在User Level上修改

  对应的profile如下:

  Concurrent: Show Requests Summary After Each Request Submission

  (并发:提交每个请求后显示请求摘要)

  46. 在接收窗口, Receiving>Receipts>Supplier and Internal为PO接收,Customers为客户退货

  Receiving>Returns>Supplier and Internal为采购退货

  47. 创建 RMA时, 找不到 referenced SO。

  方案: 检查RMA 的customer是否与reference SO 上的customer一致。若不一致,请更正。

  48. 挑库后Backordered 了,而没有处于pick confirmed/sed状态。

  方案: 检查Org parameters 表单上 ATP, Pick...标签页上的pick defaulting rule,设置为default值

  若要查看pick rule,打开路径 Inventory > Setup > Rules > Picking

  49. 接收时,Receipt Header窗口提示需要手工输入 Receipt number.

  方案: 打开路径 Purchasing > Setup > Organizations > Receiving Options, 打开Receiving Options页面, 设置 Receipt Number Options Action = Automatic。

  50. 打开一个新窗口时不要关闭了其他form:

  方案:在Application主界面,选择菜单 Tool > Close other forms, 检查它是否处于未勾选状态。

  =====================以下为摘录的oracle ebs 应用笔记======================

  1 how to set up printer style?

  System administrator->Install->Style.

  2 user a create b.table,default tablespace use b setup.

  3 in a trigger,don't need to commit,it will commit automaticlly when end,but it must be committed in a procedure.

  4 how to use reports or forms in the forms?

  a Run_Product(REPORTS,v_appl_path||v_appl_name,SYNCH RONOUS,RUNTIME,FILESYSTEM,pl_id,NULL);

  b Call_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');

  5 how to get profile values?

  FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')

  6 wyh can't i see chinaese in PL/SQL Developer 5.1?

  regedit,Oracle目录下的NLS_LANG健值简体中文的话改成SIMPLIFIED CHINESE_CHINA.ZHS16GBK

  可能的编码:AMERICAN_AMERICA.ZHS16GBK

  11i module:OM table:OE_XXXXX owner:ONT SO_XXX表仍保留,但不使用。

  11 and before module:OE table:SO_XXXXX owner:OE

  8 how to test local forms and reports in EBS 11i?

  FORMS60_PATH

  D:\cmew_upg\erpform\lib;D:\cmew_upg\erpform\form.

  9 SELECT * FROM user_objects WHERE object_name LIKE 'OE\_%' ESCAPE '\';

  10 org_id --> org_name?

  SELECT L.DESCRIPTION FROM HR_ALL_ORGANIZATION_UNITS O, HR_LOCATIONS L WHERE L.LOCATION_ID = O.LOCATION_ID AND O.ORGANIZATION_ID = XXXXXX;

  11 应该是没有安装好的问题.下面有一个黄色的横条,就不能与系统外面的数据互相COPY了

  从正常的机子上复制identitydb.obj

  12 what is the relation between the application and the jinitiator ?

  application JInitiator

  11.5.9 1.1.8.24

  11.5.4 1.1.8.16

  11.0.3 1.1.5.21.1

  13 how do the form. run first in 11i?

  form->console window->PROGRESS_INDICATOR->Primary Canvas->PROGRESS_INDICATOR (this is a blank canvas,only a graphic item)

  先指向一个窗口,canvas表示为进度,一旦pre-form. trigger逻辑完成,就跳转到blockname窗口。由于pre-form逻辑很简单,所以一般PROGRESS_INDICATOR窗口不会出现。

  导航:in pre-form. trigger,app_window.set_window_position('BLOCKNAME', 'FIRST_WINDOW'); blockname window变成了第一个窗口。

  14 how to test forms in 11i?

  fnd_message.set_string('Hello,world.');

  fnd_message.show;

  15 what is canvas and window?

  一切显示以window为准,当window大于canvas时,canvas自动扩充显示;当window小于canvas时,canvas被切割

  16 when re-compile a form,how to view the new result?

  exit the old form. page until arrive to the menu navigator.

  17 how to call another form. in a form?

  FND_FUNCTION.EXECUTE

  18 when mouse move another record in the form,it will fire when-new-record-instance trigger.

  data block level trigger,such as when-new-block-instance trigger,enter a block,it will be fired.

  when-new-record-instance,enter a record,it will be fired.

  form. level trigger,such as when-new-form-instance,enter a form,it will be fired.

  19 in a form,when a item is the database item,when its column name is blank,item's name default accrod with database column name.

  20 when will the report take effect after the parameter is changed?

  the report will take effect after reusing a responsibility.

  21 select xxxx abc from table,the alias abc can't be used in WHERE clause.

  22 how to use directX to test system?

  start->run->dxdiag

  23 how to adjust a report output size?

  Layout model-->Main Section-->Property-->Width and Height

  Main Report:Unit of Measurement select inch or Centimeter 换单位

  Format-->Layout option-->Rulers-->选ruler unit

  24 when need recompile a report?

  it will be recompiled once pl/sql code is modified.

  it needn't recompile when adjust the layout and property of the report.

  25 how is different between coa and account flexfield?

  when defining a coa,will use the same account flexfield.

  26 how do I get the table name by the form?

  Help-->Record History,can get the table name used by certain field in the form.

  27 how do I get a form. name?

  Help-->About Oracle Applications,view "Current Form"

  28 查询内部请购单

  responsibility:shipping

  menu:requisitions/requisitions summary

  29 how to make a layout for a report?

  1 Report property/Unit of Measurement:Inch

  Character Mode/Design in Character Units:Y

  2 Layout Model/Main Section/Character Mode:132*66

  3 Format/Layout options/rulers/Units:Character Cells

  1,1,Cell size:6*9.27273

  Stardard print style.

  landscape:132*66 LANDSCAPE - HPLJ4 132*57

  landwide:180*66 landwide-HPLJ4 180*57

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24838271/viewspace-702789/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2011-07-21

  • 博文量
    5
  • 访问量
    9794