有没有熟悉Oracle iProcurement的筒子？怎么看到detail approval group？

qqyang

做一个内审项目的时候碰到这个问题，是关于Oracle iProcurement的。我要调查的是iProcurement下面的审核金额的限制按道理是否in line with公司财务policy的规定。

iProcurement系统是跟HRIS对接的，利用HRIS的阶层架构，配给合适的审核权限给每一个用户。但这个审核权限又会因为每个用户的职责不同而跟HR架构有所差异。如果一个HR架构上的职位之前曾经attach一个iProcurement role，那以后任何人被assign到这个职位，都会自动配给这个role，但如果这个职位从未曾assign过任何approver role，而现在需要他作为approver存在，则需要procurement department人工assign一个approver role给他，以后这个approver role也将继续随着这个HR架构下的position存在了。

这个流程的风险在于，如果某个新HR架构下的职位被人工assign一个approver role，那这个approver role的审核层级有可能是错的，而因为曾经assign给某个职位的approver role也可能因为该职位职责的变化而变得不合时宜。

所以，我需要：1、display all approver roles available under iProcurement；2、display all users under each of the role。

个人认为，对于Oracle这样的数据库，应该不难去develope这样的报告，但IT application那边第一次回答我就是敷衍我说没有current report function in this area.  

请教各位搞Oracle的TZ，这个report是不是很难实现？如果很难，那我可能要改变审计方法了。

希望大家多提建议和意见，谢谢谢谢！:si79

qqyang

all Oracle Approvals are related back to the Position Title (Job Role) in the Position Hierarchy in Oracle. This is maintained by HR.

For an employee to be able to approve a requisition in Oracle the following needs to occur.

1) An Employee needs to be assigned to a Position Title (Job Role) within the Oracle Position Hierarchy.
2) An 'Approval Assignment' is given to Position Title (Job Role), which then links the 'Approval Group' to the role that the employee is assigned to.

Employee--------> Position Title (Job Role)<---------Approval Assignment  (with linked Approval Group)

It all hinges on the Position Title (Job Role)

The only report I can see you obtaining would be from HR showing all active employees and their job descriptions. You would then have to cross reference that in Oracle to the Approval Group assigned to that role.

As far as I am aware, there is no report that contains all of the data you require.

mmmggg

Even Oracle doesn't provide the report you want straight away, you may just enquiry the tables where the approval information stored in the background database. You may research the link below to understand the background database of Oracle ERP to know which tables you're after. Doc-link -> http://www.oracle.com/technology/documentation/applications.html

[ 本帖最后由 mmmggg 于 2007-11-13 21:06 编辑 ]

qqyang

是不是搞完这个，我就差不多可以算个赤脚Oracle consultant了？好像潭子很深哦。