定义组织时报 APP-PER-52803

纵横四海

路径为：
HR管理员－》工作结构－》组织－》说明

英文环境为：
Error message:APP-PER-52803:Your business group does not match your cecurity profile



参考文档：
主题:  Setup Steps for Creating an Organization
http://bbs.erp100.com/thread-20188-1-1.html

纵横四海

找到了资料，是因为：HR: Security Profile没有正确设置。

但是我在系统管理员界面配置HR: Security Profile时为什么不能选择其他业务组？
该配置文件只能选择：Setup Business Group
奇怪了。继续研究

以下为相关的检索ＳＱＬ：

1. 
   
2. SELECT DISTINCT b.responsibility_name,
   
3.                 PROFILE_OPTION_NAME,
   
4.                 a.USER_PROFILE_OPTION_NAME
   
5.   FROM FND_PROFILE_OPTIONS_VL    a,
   
6.        fnd_responsibility_tl     b,
   
7.        FND_PROFILE_OPTION_VALUES fpov --, per_security_profiles psp
   
8. WHERE a.USER_PROFILE_OPTION_NAME like 'HR：安全配置文件'
   
9.    AND a.application_id = b.application_id --AND
   
10.    AND TO_CHAR(b.RESPONSIBILITY_ID) = TO_CHAR(fpov.LEVEL_VALUE)
    
11.    AND a.application_id = fpov.LEVEL_VALUE_APPLICATION_ID
    
12.    AND a.profile_option_id = fpov.profile_option_id
    

复制代码

纵横四海

name：　PER_SECURITY_PROFILE_ID
User Profile name:HR: Security Profile

SQL="SELECT S.SECURITY_PROFILE_NAME \"Security Profile\",
S.SECURITY_PROFILE_ID,
'PER_BUSINESS_GROUP_ID',
S.BUSINESS_GROUP_ID,
O.NAME \"Business Group\"
INTO :VISIBLE_OPTION_VALUE,
ROFILE_OPTION_VALUE,
:DERIVED_NAME,
:DERIVED_VALUE,
null
FROM PER_SECURITY_PROFILES S,
PER_BUSINESS_GROUPS O
WHERE O.BUSINESS_GROUP_ID (+) = S.BUSINESS_GROUP_ID
ORDER BY S.SECURITY_PROFILE_NAME"
COLUMN=" \"Security Profile\"(*), \"Business Group\"(*)"
HEADING=" \"*PER:HR_ML_SECURITY_PROFILE\"(*), \"*PER:HR_ML_BUSINESS_GROUP\"(*)"

纵横四海

please follow Note 401930.1 Default Security Profiles Are Not Created when New Business Groups A
re Setup

以下是Oracle同时让我运行的三个ＳＱＬ：
1)select trigger_name,
status
from user_triggers
where table_name='HR_ORGANIZATION_INFORMATION'

check if hr_org_info_ari is missing or disable .

TRIGGER_NAME STATUS
1 HR_ORG_INFO_BRI DISABLED
2 HR_ORGANIZATION_INFORMATIO_OVN DISABLED
3 HR_ORG_INFO_ARI DISABLED
4 HR_PA_MAIN_ORG_INFO_HIST_BRI DISABLED
5 HR_PA_MAINTN_ORG_HIST_BRI DISABLED
6 HR_PA_MAINTN_ORG_HIST_BRU DISABLED
7 HR_PA_MAINTN_ORG_HIST_BRD DISABLED
8 HR_ORGANIZATION_INFORMATIO_WHO DISABLED



2) select name,
business_group_id
from per_business_groups;

1 Setup Business Group 0
2 HZD业务组 241

3) select security_profile_id,
business_group_id,
security_profile_name,
view_all_flag
from per_security_profiles;

1 0 0 Setup Business Group Y

纵横四海

主题:  Default Security Profiles Are Not Created when New Business Groups Are Setup
   文档 ID:  注释:401930.1  类型:  PROBLEM
   上次修订日期:  05-DEC-2006  状态:  PUBLISHED
Applies to:
Oracle Human Resources - Version: 11.5.10.2
This problem can occur on any platform.
PERWSSCP
Symptoms
On 11.5.10.2 in Production:
Created a Business Group Organization
EXPECTED BEHAVIOR
When a Business Group is created, a default Security Profile should be created.
STEPS
The issue can be reproduced at will with the following steps:
Global Super HRMS Manger
Work Structures -> Organization -> Description
Global Super HRMS Manger
Security -> Profile
Changes
It is unknown what caused this issue.
Cause
The issue is caused by the following setup: the trigger, hr_org_info_ari , is missing.
This issue was posted on the HR Forum and development suggested running the following scripts to
determine the cause:
1) select trigger_name,
status
from user_triggers
where table_name='HR_ORGANIZATION_INFORMATION'
2) select name,
business_group_id
from per_business_groups
3) select security_profile_id,
business_group_id,
security_profile_name,
view_all_flag
from per_security_profiles
Solution
To implement the solution, please execute the following steps:
1. Log into sqlplus and run: $PER_TOP/patch/115/sql/petrorgi.sql
will recreate the trigger.
2. Recreate the business groups once the trigger is enabled to create the view all
profiles.
3. Retest the issue.
4. Migrate the solution as appropriate to other environments.

纵横四海

参考上文的Solution问题已经解决。

bigmang

在R12中,我碰到相同的问题,需要在Profile中设置:
1. HR:Security Profile >
site                                         Responsibility
xxx Business Group                xxx Business Group

2. HR:Business Group >
site                                         Responsibility
xxx Business Group                xxx Business Group

grace9411

追加新疑问：在EBS12R中，我用Inventory Super User, Progress S&L和自定义XXX_INV（注：application, menu, data group, request group）职责进入定义BG，为什么在XXX_INV中报错APP-PER-52803，而在Inventory Super User, Progress S&L却不存在这种情况？相类似的事情,当然它们的menu与request group是不同的，Global HRMS Manager(Application:Human Rwsourcess, Data Group:standard, Menu:GLB SHRMS Navigator,  Request Group:Global SHRMS Reports & Process)；  HRMS, Progress Admin S&L(Application:Human Rwsourcess, Data Group:standard, Menu:US SHRMS Navigator,  Request Group:US SHRMS Reports & Processes)，在这里是Global HRMS Manager报错APP-PER-52803，而HRMS, Progress Admin S&L中一切正常，这个问题是怎么回事？

雏鸟

同问，请大侠指点~