oracle ebs 应用

oracle ebs 应用

标签：音乐 to and how so it  分类：VB,VB.NET

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,SYNCHRONOUS,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

30 where,group子句中，如果定义了表和列的别名，必须用表的别名和列的原名，order by子句中没有规定，可以任意用。

31 how do inquery information about org_id and organization_id？
org_id          :hr_operating_units
organization_id     :org_organization_definitions2

32 OM and AR share the same customers

33 in the Discoverer,set a user privilege,if Administration is blank,when the user logon the discoverer administration edition,
system will ask about creating EUL;is administration is selected,user logon will normally.if Not select Set Privilege,user
can not Privilege.

34 只需把view的权限授予一个用户，不需要对view的表再一一授权。

35 报表套打多页，页面下移
1 report的主体的上下距的设置
2 打印机的上下边距的设置


36 what are status code for oe header and line?
oe_order_headers_all
flow_status_code in (entered,booked,cancelled,closed)

oe_order_lines_all
flow_status_code in (AWAITING_RECEIPT,AWAITING_RETURN,AWAITING_RETURN_DISPOSITION,AWAITING_SHIPPING,
BOOKED,CANCELLED,CLOSED,ENTERED,FULFILLED,SHIPPED)

37 what is flow about OM?
1 Entered
2 Booked:after booked,so line's status is:Awaiting shipping,Ready to Release
3 release so:when release a so,items from subinventory1(Pick from) to subinventory2(default stage)
4 ship confirm:all released so line will be confirmed.
5 run the report "Workflow Background Process",transfer data from om to ar interface table.
after it done,so line is closed.when all so line is closed,the so header is closed.
6 ar autoinvoice

38 release so的时候，order line里的计划出货的schedule ship date必须修改为当天日期，然后在release so的窗口中设置schedule ship date的范围，
如果不设置，所有能出货的货物全部出货。

******************************************************************************
39 how to query view based client enviroment?
begin
apps.fnd_client_info.set_org_context(p_org_id);
end;

最彻底的方案就是使用：
begin
fnd_global.APPS_INITIALIZE(user_id =>1130 ,resp_id => 50322,resp_appl_id =>660 );
end;
******************************************************************************

select * from OE_TRANSACTION_TYPES.
all operation can be done within a SQL window.

40 in Discoverer,if a fold is from a database,every item will create a item class automatically,if a fold is from a custom SQL,it must be manually created a item class.

41 created_by -> fnd_user.user_id
    fnd_user.employee_id -> per_all_people_f.person_id

42 when ship confirm,the orders that only same delivery id can be deliveried together.

43 in OE menu,Order organizer is used to inquire some informations for orders,Sales Orders is used to create and change a order.

44 在OM里，来源库，目的库，必须都属于同一个warehouse

45 once pick a release,every order line will create a delivery detail id from wsh_delivery_details table,but the release action will create only delivery name(delivery_id) from wsh_new_deliveries

46 订单的最终状态：
oe header，oe lines:closed
delivery status:closed
pick status:shipped
transaction line status:interfaced

47 sales order number is numeric created by system automatically and purchase order number is character input manually.

48 in PO,when input and save a purchase order,the po header status is "incomplete" and change to "Approved" after it pass the approve.The PO number will be created automatically if no input po # manually.

49 After copying sales or purchase order,the new order is created and saved automatically.

50 how do create po and sales order number?
purchase order number is created manually,sales order number is created automatically.

51 the po status is incompleted when it saved and change to approved after approved.

52 GL,AP,AR,INV,PO have own period,it must be open or close for every module.OM has no own period.

53 item在主组织进行录入，然后分配给库存组织使用。主组织定义品号，库存组织打开会计期。库存组织不能定义新品号，但可以查询。

54 pick release has two methods.
办法1： 修改或者录入so的时候scheduled ship date一定要填写适当的日期，release so的时候输入确定的日期范围，范围内的so都被release.
办法2：scheduled ship date不用输入具体日期，release so前先执行Auto-Create deliveries，生成交货号，可以对多个so按Ctrl键同时选择。路径：ship/transaction/Auto-create deliveries

55 employee information setup is on menu :Setup/Organizations/Employees,by INV Super User responsibility if HR module is absent.

56 直发订单，不需release so,ship confirm,但是需要做autoinvoice

57 how is different between invoice and "收据"？
it is by CUST_TRX_TYPE_ID

ap:ap_invoices_all
ar:ra_customer_trx_all

58 直发订单
生成直发so后，导入请购单，根据生成的请购单，再自动生成PO

59 in PO,Receiving>Receipts>Supplier and Internal为PO接收，Customers为客户退货
Receiving>Returns>Supplier and Internal为采购退货

60 internal company po and so,收货方－>发货方－>收货方，先生成internal AR invoice，再生成internal company AP Invoice

61 出货单由ra_customer_trx_all和ra_customer_trx_lines_all决定，line包含出货单物品内容。
    装箱单：由oe_order_headers_all,oe_order_lines_all决定 组织：o.org_id = :P_org_id OR ol.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_all
   
62 oe_order_headers_all
sold_from_org_id 与org_id对比，是否自身的订单，还是内部直发
sold_to_org_id     ar_customer.customer_id
ship_from_org_id warehouse_id 哪个仓库发货
ship_to_org_id     ra_site_uses_all.site_use_id ship_to_location
invoice_to_org_id ra_site_uses_all.site_use_id     bill_to_location

63 po没有类似的sold_from_org_id，ship_from_org_id，只有一个org_id

64 inv period setup:Accounting Close Cycle/Inventory Accounting Periods
PO/GL/AP/AR need control period,but OM has no period.

65 price on OM,PO and inv
OM:有price_list,PO里面没有。
oe_order_lines_all.price_list_id=qp_list_lines_v.LIST_HEADER_ID and ol.inventory_item_id = ql.product_attr_value
ql.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.attribute1

INV:
item有自己的list_price_per_unit,market_price，表为mtl_system_items_b

***********
SO的单价是限死的，PO的单价是自己设的
***********