flex税税前抵扣是什么意思税?每年扣几次?

ASICS 亚瑟士 男士 Matflex 4 黑色运动鞋 270元+税费29元_尚品全球购优惠_什么值得买
当前位置:
ASICS 亚瑟士 男士 Matflex 4 黑色运动鞋
&&&270元+税费29元
更新时间: 16:33
鼠标移到标签上方,
尝试关注标签~
值友爆料原文:ASICS 亚瑟士 男士 Matflex 4 黑色运动鞋,售价270元,税费29元,有需要可以看一下~
什么值得买是一家中立的消费门户网站,好价信息来自热心值友爆料和商家自荐,经小编人工审核或小值机器人智能判断后发布。促销折扣可能随时变化,请值友们购买前注意核实。
我要举报:
请选择举报理由:
信息涉及黄色,反动内容
虚假优惠信息
已有 1用户参与
微信号:smzdm_smzdm
全部好价:人气超高的全部好价聚集了海量信息,承载了新鲜、好玩、有趣的产品,不仅买的实惠,还能发现生活的美好。
赞16评论23
赞24评论49
热门优惠券
已领: 27478 张
已领: 26361 张
已领: 36741 张
已领: 74310 张
已领: 3917 张
Lynk & Co 领克 01(三天使用权)
群晖 DS218+ NAS & SkyNAS + 西数4TB红盘*2
Apple 苹果 HomePod 智能音箱
Jabra Elite 65t 捷波朗 臻律 无线蓝牙音乐耳机
赞196评论167
赞18评论70
赞20评论51
收藏0评论0
收藏1评论2
收藏1评论0
收藏0评论0
收藏1评论0
收藏0评论0
收藏1615评论242
收藏890评论106
收藏686评论29
扫一下,分享更方便,购买更轻松限10码:SKECHERS 斯凯奇 Skech-Flex Power Alley 男款运动鞋*2双 ¥355.62+¥42.32含税直邮(约¥398)_亚马逊中国优惠_什么值得买
当前位置:
SKECHERS 斯凯奇 Skech-Flex Power Alley 男款运动鞋*2双
&&&¥355.62+¥42.32含税直邮(约¥398)
好价信息来自热心值友爆料和商家自荐,经小编人工审核或小值机器人智能判断后发布。
更新时间: 11:24
鼠标移到标签上方,
尝试关注标签~
值友“苍茫天涯我滴爱”爆料原文:目前亚马逊海外购黑色款10码报价177.81元,Prime会员购买两双可以免邮,需要预交42.32元税费,含税直邮到手约398元,合199元/双。
拼单好价可入。
什么值得买是一家中立的消费门户网站,好价信息来自热心值友爆料和商家自荐,经小编人工审核或小值机器人智能判断后发布。促销折扣可能随时变化,请值友们购买前注意核实。
我要举报:
请选择举报理由:
信息涉及黄色,反动内容
虚假优惠信息
已有 6用户参与
微信号:smzdm_smzdm
全部好价:人气超高的全部好价聚集了海量信息,承载了新鲜、好玩、有趣的产品,不仅买的实惠,还能发现生活的美好。
赞16评论23
热门优惠券
已领: 4388 张
已领: 1450 张
已领: 0 张
已领: 0 张
已领: 27477 张
Lynk & Co 领克 01(三天使用权)
群晖 DS218+ NAS & SkyNAS + 西数4TB红盘*2
Apple 苹果 HomePod 智能音箱
Jabra Elite 65t 捷波朗 臻律 无线蓝牙音乐耳机
赞196评论167
赞18评论70
赞20评论51
收藏0评论0
收藏1评论2
收藏1评论0
收藏0评论0
收藏1评论0
收藏0评论0
收藏1615评论242
收藏890评论106
收藏686评论29
扫一下,分享更方便,购买更轻松Oracle&EBS应用笔记整理&(转自IT++&flyingkite)
*****************************************************
Author: Flyingkite
http://space.itpub.net/?7434747
*****************************************************
=====================以下50条笔记为本人亲自整理======================
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
, 在"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
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".
做接收检验时,点击完按钮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
方案:打开路径
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-) 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/staged.
方案:打开路径 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" 为
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
首先,设置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 &
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 = item name, UOM = DZ, 输入Unit
如果出现提示 "XXX item and Ea not on Corporate",
需要设置Product Attribute= All Items,& Product
Value = 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 或者
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
方案:打开路径 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/staged状态。
方案: 检查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?
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?
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\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 =
应该是没有安装好的问题.下面有一个黄色的横条,就不能与系统外面的数据互相COPY了
從正常的機子上複製identitydb.obj
12 what is the relation between the application and the jinitiator
application&&&
JInitiator
11.5.9&&&&&&&&&&
11.5.4&&&&&&&&&&&&
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.
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
20 when will the report take effect after the parameter is
the report will take effect after reusing a responsibility.
21 select xxxx abc from table,the alias abc can't be used in WHERE
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
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
it needn't recompile when adjust the layout and property of the
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
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
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
system will ask about creating EUL;is administration is
selected,user logon will normally.if Not select Set
Privilege,user
can not Privilege.
只需把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?
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?
apps.fnd_client_info.set_org_context(p_org_id);
最彻底的方案就是使用:
fnd_global.APPS_INITIALIZE(user_id =&1130 ,resp_id
=& 50322,resp_appl_id =&660 );
******************************************************************************
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.
在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.
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
由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 =
内部订单:同普通订单,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
po没有类似的sold_from_org_id,ship_from_org_id,只有一个org_id
64 inv period setup:Accounting Close Cycle/Inventory Accounting
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约束。
采购单行上的price,list_price分别为po_lines_all中的unit_price,list_price_per_unit,这两个price都可以修改。unit_price&1.17(tax_code)就为含税单价,一般为pl.attribute1
item有自己的list_price_per_unit,market_price,表为mtl_system_items_b
***********
SO的单价是限死的,PO的单价是自己设的
***********
66 item type
被approve的PO还可以修改,修改后需要re-approve.
OM booked后,还可以modify the so lines
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是收货方
普通直发订单,需要导入生成请购单,最后自动生成订单,做采购接收;内部订单,先手工做请购单,不需要生成采购单,直接做采购接收。因为内部订单接收方只有PR,没有PO,所以最后的AP发票无法做匹配,状态只能是:Never
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
item:&&&&&&&&&&&&&
mtl_system_items_interface
category:&&&&&&&&
mtl_item_categories_interface
item:&&&&&&&&&&&&
mtl_item_categories_interface
bom:&&&&&&&&
bom_bill_of_mtls_interface
bom:&&&&&&&&
bom_inventory_comps_interface
COST&&&&&&&&&&&&
CST_ITEM_CST_DTLS_INTERFACE
如果多组织的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
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
/'表示结束,两者作用相同,有一个就可以,不能重复。
在一个sql语句中不能有空格,空格会中断该SQL;在多个SQL之间可以有任意多个空格。
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?
每一个LE/OU都上了Disctribution后,和supplier,user通过EDI等结合起来,形成一个完整的系统,叫SCM,Distribution
is a subset of SCM.
同一个LE下不同的OU,在11.5.9后才可以通过内部往来做OM/PO,11.5.8都不行。
不同的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
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都分组织
标准流程不保存Item的月末盘点数,只能通过客户化表来实现。
两个或者多个视图进行关联可能非常慢,替代办法:创建临时中间表,速度可极大提高。
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
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
app_standard.event('WHEN-WINDOW-CLOSED');
97 in standard form,om unit price include tax,po unit price exclude
sales order含税,po不含税
98 what is different between canvas and window in a form?
window的大小可以比canvas大,可以比canvas小,item甚至可以不在window的范围里。runtime的时候,canvas自动的调整布局,适应window.
form中window为透明的,canvas不透明,有窗口色。
3 item必须在canvas的范围内,否则报错。
4 only stacked canvas has
viewport,大小为stacked的大小。
org_id是OU,organization_id为库存组织,org_organization_defination表里分别对应organization_id,operating_unit
master_organization没有ou
100 Price in om and invoice
unit_selling_price:unit price with tax
unit_list_price:the operand of qp_list_line
OM中没有不含税的单价
gross_unit_selling_price:unit price with tax 含税价
(也可取:UNIT_SELLING_PRICE * ( 100 + X.TAX_RATE ) *
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都是含税的
1 create table t1 as [(]select ................[)] 有as
2 insert into t1 [(]select
...................[)]&&&
102 If you specify a hidden ID column in addition to your value
the report parameter window passes your hidden ID value, instead
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
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
po_vendors&&&&&&&&&
vendor_name&&&&
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
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.
用conditions生成的paramwter,都无法用item_class,只有用Tools/parameters,才能使用item_class,在查询的时候可以用LOV查询参数.
108 what is different between internal name and display name in
internal name: used in workflow internal programs,usually named as
display name:used in workflow user,usually named as Chinese
109 if the template.fmb can't be closed,then changed list:
Form level trigger: when-window-closed
if :system.event_window = 'BLOCKNAME' then
app_standard.event('WHEN-WINDOW-CLOSED');
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
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.
记录少的,simple,和多个表关联的table放在from的最后,做为driving
2 table和table
join条件放在where的最前面,单个表的条件放在where的最后面。SQL先根据最后的条件,过滤掉了大部分记录,然后再做记录间的关联,所以速度比较快。
尽量避免做全表的搜索,计算函数等放在=的右边,不要在表的列上做计算,这样可以利用column上的index,一旦column上做了任何计算,index无法再用。
ORACLE采用自下而上的顺序解析WHERE子句,根据这个原理,表之间的连接必须写在其他WHERE条件之前,
那些可以过滤掉最大数量记录的条件必须写在WHERE子句的末尾.
114 how to start to use workflow in PL/SQL?
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?
fnd_user&&&&&&&&&&&&&&&&&&&&&&&&
per_all_people_f&&&&&&&&
HR职员,员工
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
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
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
125 which profile will be used for session timeout
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
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
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
此目录是Application
Report产生报表文件,供最终用户查询及打印。建议在系统硬盘上保存90天,以方便用户。如果IT人员需清理90天以前报表,必须确保备份成功并永久保存,便于满足用户提出的恢复报表请求
以上网友发言只代表其个人观点,不代表新浪网的观点或立场。

我要回帖

更多关于 多耐福duraflex扣具 的文章

 

随机推荐