ITPub博客

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

Oracle EBS应用笔记整理

Linux操作系统 作者:coco1 时间:2014-01-22 15:19:49 1 删除 编辑

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的单价是自己设的
***********

66 item type
FG 成品
SA 半成品
P 原材料
OP ???

67 被approve的PO还可以修改,修改后需要re-approve.
OM booked后,还可以modify the so lines

PO corrections,只是对接收的更正,似乎只能增多,不能减少,减少用退货。退货可以选两种,一种退到supply,交易类型为delivery;一种退到receiver,交易类型为receiving

68 SO的退货接收分3步
1 做退货单的RMA类型的SO
2 退货接收 PO/Receiving>Receipts>Customer
3 退货接收入库 PO/Receiving>Receiving Transaction>Customer 第二步所做的接收只做地点接收,没有入库
4 Workflow Background engine后做autoinvoice,所生成的发票为:贷项通知书(Credit memo):供应商对已开发票的货物或劳务,所开的红冲发票

69 PO一旦被approved,只能通过Purchase order summary or Requisition Summary来查看information,不能再打开????PO的似乎可以,PR一旦approved,不能再open.

70 普通add item in inventory,select Transactions/Miscellaneous Transaction/Account alias receipt

71 Intercompany AR invoices和intercomapny AP invoices都在inv的职责下提交报表

72 在公司内部订单的时候,Shipping Operating Unit是发货方,Selling Operating Unit是收货方

73 普通直发订单,需要导入生成请购单,最后自动生成订单,做采购接收;内部订单,先手工做请购单,不需要生成采购单,直接做采购接收。因为内部订单接收方只有PR,没有PO,所以最后的AP发票无法做匹配,状态只能是:Never Validated

AR:Create intercompany AR Invoices后,还没有生成发票,运行autoinvoices,生成发票;同样的,AP:Create intercompany AP Invoices后,还需运行expense report import,才生成发票。intercompany AR/AP的发票号应该一致

74 how do call a jsp in EBS form?
web.SHOW_DOCUMENT('http://cmew07.bj.ch.mew.com:8002/OA_HTML/NAISQTS/repQuoteSel0.jsp?REQID=100');

75 report显示的列错位如何解决?
在字符模式里调layout,然后把item的宽度固定

76 销售发票号,发票号,发票号码
销售发票号:ra_customer_trx_all invoice_number 系统内
发票号:系统外
发票号码:系统外

77 what is the interfaces to import item,item category and bom?
item:              mtl_system_items_interface
item category:         mtl_item_categories_interface
item:             mtl_item_categories_interface
parent bom:         bom_bill_of_mtls_interface
inventory bom:         bom_inventory_comps_interface
COST             CST_ITEM_CST_DTLS_INTERFACE

78 如果多组织的item为同一个,导入时可一次性导入;cost只能分别导入;category因为各组织一般不相同,所以也分开来导入。

79 cost update
1 先手工录入或者导入Pending,然后做Costing/Item costs/Standare cost update/Update Costs,把成本从pending转换成Frozen,Frozen为正式使用的成本。创建一个ITEM后,系统会自动生成一个Frozen类型的空的cost。Actual类型的cost一般不使用。
一个成品由半成品和若干原材料构成,成本分材料费,加工费等。COST_ELEMENT_ID为费用种类,1为材料费。

80 how to distinguish a so's delivery status?
select meaning from wsh_lookups where LOOKUP_TYPE='PICK_STATUS'

Backordered
Shipped
Cancelled
Interfaced
Not Ready to Release
Ready to Release
Released to Warehouse
Not Applicable
Staged/Pick Confirmed

81 leagal entity:select name from hr_all_organization_units
operating_unit_code:select organization_code from mtl_parameters

82 sql*plus script
1 ';'和' /'表示结束,两者作用相同,有一个就可以,不能重复。
2 在一个sql语句中不能有空格,空格会中断该SQL;在多个SQL之间可以有任意多个空格。

83 sql中,一旦表a的记录为空,a的所有的条件必须为外连接,无论其是否和其他的表关联。

84 1 SOB,OU via a profile option attached to a responsibility
2 ap/ar/po/om的操作都在Operating Unit(OU)层上。
3 Inv/BOM/WIP/MRP/Engineering/Capacity/Purchase receiving都在Inventory Organization(inv org)上操作。

85 how many types is organization classifications?
Businesss group
HR Organization

GRE/Legal Entity

Operation Unit
Inventory Organization

86 what is different between Distribution and SCM?
1 每一个LE/OU都上了Disctribution后,和supplier,user通过EDI等结合起来,形成一个完整的系统,叫SCM,Distribution is a subset of SCM.
2 同一个LE下不同的OU,在11.5.9后才可以通过内部往来做OM/PO,11.5.8都不行。
3 不同的LE之间只能通过EDI,i-P???,i-store,Fax等手段进行业务往来。

87 SOB不分组织,journal只分SOB,不分组织。

88 many people can't be find in HR module,they are in GL Super user responsibility,Setup/Employees/Enter

89 a key flexfield用一个特定的表来存储各种组合的规范,系统中能用的是structure,它是key flexfield下的子集。相同key flexfield下的不同的structure,利用flexfield所用的application table中的structure column来区分。
define a key flexfield:application developer responsibility/Flexfield/Key/Register
define a structure:Flexfield/Key/Segments

90 a po vendor and a ap vendor is same.
po_vendors.vendor_id=po_vendor_sites_all.vendor_id
po vendor不分组织,分SOB;po site分组织;
ar customer也是在site上分组织
ap_invoice,ap_invoice_distributions都分组织

91 标准流程不保存Item的月末盘点数,只能通过客户化表来实现。

92 两个或者多个视图进行关联可能非常慢,替代办法:创建临时中间表,速度可极大提高。

93 mtl_item_categories.inventory_item_id同mtl_system_items_b相关联。
然后,mtl_item_categories同mtl_category_sets_tl,mtl_category_b相关联。

94 import items,first import master item,then import other all organization items(可一次导入,every organization must have a data copy,only organization id different)
after import items,then import category,must delete 000.00.00类型的category(automatically created when import item),then import new category.
1 category can't be updated directly.
2 item can be updated directly,use "update" transaction type when import.

95 The report is developed by character mode,the view result is same as print,it may be different from preview in EBS 11i.
报表设计布局可能和系统预览的效果布局不一致,但应该和打印出来的布局一致。

96 if i use template form,i can't close it,message 'at first block',how to fix it?
modify the form. level trigger "WHEN-WINDOW-CLOSED"

if :system.event_window = 'XXXXXXXX' then
exit_form;
else
app_standard.event('WHEN-WINDOW-CLOSED');
end if;

97 in standard form,om unit price include tax,po unit price exclude tax.
sales order含税,po不含税

98 what is different between canvas and window in a form?
1 window的大小可以比canvas大,可以比canvas小,item甚至可以不在window的范围里。runtime的时候,canvas自动的调整布局,适应window.
2 form中window为透明的,canvas不透明,有窗口色。
3 item必须在canvas的范围内,否则报错。
4 only stacked canvas has viewport,大小为stacked的大小。

99 org_id是OU,organization_id为库存组织,org_organization_defination表里分别对应organization_id,operating_unit
master_organization没有ou

100 Price in om and invoice
OM line
unit_selling_price:unit price with tax
unit_list_price:the operand of qp_list_line
OM中没有不含税的单价

Invoice
gross_unit_selling_price:unit price with tax 含税价 (也可取:UNIT_SELLING_PRICE * ( 100 + X.TAX_RATE ) * 0.01)
Decode ( vat.tax_rate,0,trxl.unit_selling_price,trxl.unit_standard_price) unit price without tax 不含税价 ??????????
似乎不对!!!经测试,unit_selling_price是不含税单价,unit_standard_price为含税单价.

amount需要line和tax的金额相加
invoice form里显示的unit_price,amount都是含税的


101 sql:
1 create table t1 as [(]select ................[)] 有as
2 insert into t1 [(]select ...................[)]    无as

102 If you specify a hidden ID column in addition to your value column,
the report parameter window passes your hidden ID value, instead of
the value from the value column, to your report.
值集定义的时候,一旦定义了ID,就只传ID的值,不再传Value
一般只在report的参数定义时定义ID,别的key or description flexfield都不允许使用定义ID的value set

103 how to register a table with Oracle Application Object Library?
1 create a synonym for the private table with apps schema
2 grant select on xxx.table to apps

104 the special arguments (bind variables) in the where clause in the value set incluede:
1 :block.field
2 :$PROFILES$.option_name(case 大小写)
3 :$FLEX$.value_set_name

105 po_vendors          vendor_name     不分OU
po_vendor_sites_all      vendor_address 分OU

106 订单行状态分析
1after booked a so,oe_order_lines_all.flow_status_code:AWAITING_SHIPPING
此时wsh_delivery_details 分别对应每个订单行,生成记录。 delevery_detail_id,source_header_id,source_line_id有数据
now wdd.released_status='R', throuth select * from wsh_lookups where lookup_type = 'PICK_STATUS',wdd released status =>'Ready to Release'
wsh_delivery_assignments now 有数据,当时没有delivery_id

2 只有pick release成功后,wsh_delivery_assignments才会生成一个delivery_id,wsh_new_deliveries生成数据,delivery_name=delivery_id

只要进行相应的操作,wdd.released_status都会有相应的值。

107 what is EUL,BA,drill in discoverer?
1 A user can create a EUL named as itself,it may create some EULs for other users.The EUL's name is same as the user's name.
所以一个用户只能有一个属于自己的EUL,但可grant access to Public,创建EUL的时候无法指定EUL的名字。
2 a user can delete EUL owned by itself only.
3 after creating EUL,the first BA can be simply created.we can insert a blank BA.
4 用conditions生成的paramwter,都无法用item_class,只有用Tools/parameters,才能使用item_class,在查询的时候可以用LOV查询参数.

108 what is different between internal name and display name in workflow?
internal name: used in workflow internal programs,usually named as English
display name:used in workflow user,usually named as Chinese words

109 if the template.fmb can't be closed,then changed list:
Form. level trigger: when-window-closed
if :system.event_window = 'BLOCKNAME' then
exit_form;
else
app_standard.event('WHEN-WINDOW-CLOSED');
end if;

110 if form. will excute DML action,Property/Advanced Database/DML Data Target Type,DML Data Target Name must not be blank.

111 A table may be outer joined to at most one other table.
a=b(+) and c=b(+) 不允许,because table b is outer joined to two other table.

a=b(+) and b=c(+)可以,但是当b is null后,b,c的记录都为null行

112 how to draw a frame. include old item in report?
1 draw a frame. include old item
2 select the frame. and express 'F8'

113 sql tune
Oracle sql optimize rule: "From table" from right to left,"Where clause" from down to up.
1 记录少的,simple,和多个表关联的table放在from的最后,做为driving table.
2 table和table join条件放在where的最前面,单个表的条件放在where的最后面。SQL先根据最后的条件,过滤掉了大部分记录,然后再做记录间的关联,所以速度比较快。
3 尽量避免做全表的搜索,计算函数等放在=的右边,不要在表的列上做计算,这样可以利用column上的index,一旦column上做了任何计算,index无法再用。

ORACLE采用自下而上的顺序解析WHERE子句,根据这个原理,表之间的连接必须写在其他WHERE条件之前, 那些可以过滤掉最大数量记录的条件必须写在WHERE子句的末尾.

114 how to start to use workflow in PL/SQL?
1 create     wf_engine.createprocess(itemtype,itemkey,process,user_key);
2 initiate
wf_directory.getusername(.....);
wf_engine.setitemattrnumber(...);
wf_engine.setitemattrtext(....);
3 startup wf_engine.startprocess(itemtype,item_key);

115 what is different about three user tables?
1 fnd_user                         ERP用户
2 per_all_people_f         HR职员,员工
3 hz_parties                     客户

fnd_user.employee_id = per_all_people_f.person_id
per_all_people_f.party_id = hz_parties.party_id

ERP用户可能不是HR员工,HR员工可能不是ERP用户,员工可能是客户

ar_customers is a view from table hz_parties.

116 how to get flex value description?
by the view fnd_flex_values_vl

117 report里,动态的条件限制:
1 add a user parameter p_xxx,use &p_xxx in where clause.
2 add a report global formula,return 'where clause string'

118 how to disable save function in a form?
form. level trigger:when_new_block_instance 触发器中使用app_special.enable('SAVE',PROPERTY_OFF);

119 how to execute NULL in sum,count,max and so on functions in the group clause?
1 sum,count,max group functions(集合函数) ignore NULL value,value is NOT NULL
2 非集合函数和NULL运算,value = NULL

120 how to use multi-form. window?
profile:Self Service Personal Home Page mode
Framework only->Personal Home Page

121 how to control the access to Help/Diagnostics/Examing without apps's password?
profile:Utilities:Diagnostics

122 The username and password are not match case in application 11i.

123 what is the relationship between invoice and check?
a check may pay many invoices,a invoice may be paid by many checks,check and invoice must be associated by payment(ap_invoice_payment)
payment amount is from ap_invoice_payment.amount and not from ap_checks_all.amount

124 ap_bank_branchs.bank_branch_id = ap_bank_accounts_all.bank_branch_id
1 create a bank and bank branch
2 create several bank account under a bank branch
3 create several payment documents under a bank account
when create a payment,first select a account,then select a document

125 which profile will be used for session timeout control?
ICX:Session Timeout

126 how to use the parameter of host report?
p_program_name=$0
p_sqlpwd=$1
p_usr_id=$2
p_usr_name=$3
p_req_id=$4

127 in sql and sql/plus statement,';' function is same as '/',两个不能同时出现,否则run doubly.
pl/sql,must end with '/'

128 profile MO: Operating Unit    org_id

129 tkprof focupgd_ora_13975_APPS.trc focupgd_ora_13975_APPS.out explain=apps/apps2dev

130 how to sum in sql*plus report?
BREAK ON REPORT
COMPUTE SUM OF column1 column2 ON REPORT

131 how to create information to output and log in 11i?
sql*plus report
output: select * from xxxx
log:

pl/sql report
output:FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'XXXXXX');
log:FND_FILE.PUT_LINE(FND_FILE.LOG,'XXXXXXX');

132 how to separately commit?
PROCEDURE P_1 AS PRAGMA AUTONOMOUS_TRANSACTION;

133 /app/prd/comn/admin/out report cache for Application Report
此目录是Application Report产生报表文件,供最终用户查询及打印。建议在系统硬盘上保存90天,以方便用户。如果IT人员需清理90天以前报表,必须确保备份成功并永久保存,便于满足用户提出的恢复报表请求

摘自 http://hi.baidu.com/helloorcl/blog/item/b133deedd5aedd2f63d09fd0.html

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

请登录后发表评论 登录
全部评论

注册时间:2013-03-06

  • 博文量
    152
  • 访问量
    206276