Oracle EBS Notes

摘要： Understanding and Using HRMS Security in Oracle HRMSProduct:Oracle Human Resources Minimum Version:11.5.9An Oracle White PaperAbstractUnderstanding and Using HRMS Security in Oracle HRMSDocument HistoryAuthor : Steve CooperCreate Date : 04-OCT-2006Last Update Date : 18-JUN-2008Expiration Date : Oth. 阅读全文

摘要： I had to provide data to auditors on theInternal & Purchase Requisitions created by usersPurchase Orders created for the requisitions (inventory and non inventory items)Receiving transactions with PO and Requisition informationI have given the queries here as could be useful. All data has been t 阅读全文

摘要： Following are some of the most frequently used queries in oracle apps order management:Order header infoSelect * from oe_order_headers_all ooh where order_number= :p_order_number Operating unit info select * from hr_operating_units where organization_id=oe_order_headers_all.org_id Order type infose. 阅读全文

摘要： Consignment 寄存一般是指卖方把货物存放在买方所属仓库，消耗后结帐。库存水平控制和货物的物理管理都由买方负责。这是目前很多大卖场通行的做法。典型的VMI一般也 是指卖方把货物存放在买方附近的仓库（可以是买方、卖方或者第三方仓库），消耗后结帐。但库存水平控制和货物的物理管理都由卖方负责。生产型企业在推广VMI采购项目时，都要根据自己产品行业特点选择适合的一种或者多种操作模式，很可能这两种都会用到。 那么寄售和VMI 分别有什么特点和作用呢？ 寄售协议规定了有关寄售的条件和具体做法，其主要内容如下： 双方的基本关系。寄售人和代销人之间的关系，是一种委托代理关系。货物在出售前所有权仍... 阅读全文

摘要： AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.AD_APPLIED_PATCHES holds information about the "distinct" Oracle Applications patches that have been applied. If 2 patches happen to have 阅读全文