ORACLE HR中如何更改已有的法规代码（ legislation code ）？

纵横四海

Setup Business Group是缺省的business group，其法规代码 （legislation code ）是united states,币种是美元。
如何更改法规代码？




参考帖：
（这个答案是我用鲜血换回来的）一个全新的系统安装好后，需要进行如下几项工作！
http://bbs.erp100.com/thread-20127-1-1.html

纵横四海

帖一个oracle的解释：
      The Legislation Code determines the startup data you can access and the contents of some legislation-specific windows.

          Attention: Selecting the correct legislation code is essential for the correct functioning of Oracle HRMS. You cannot change the legislation code after entering employees against the Business Group.

纵横四海

这是一个全新系统，启用HRMS需要注意几项工作：

1. Apply the latest HRMS Family Pack (11i.HR_PF.K.Rup2 (Patch 5337777)

2. Apply the hrglobal patches for Global and China from Note 145837.1

3. Run DataInstall for Global HR, China HR and China Payroll

4. Apply $PER_TOP/patch/115/driver/hrglobal.drv

5. If you want to use Setup BG for China, then change the legislation, currency and key flexfields before creating any employee

6. Else, create a separate business group for china and attach it to the HR:Business Group and HR:Security Profile

纵横四海

Business Groups
A business group is the highest level of organization and the largest grouping of employees across which you may report. Oracle Human Resources includes a predefined organization named Setup Business Group. We recommend that you modify the definition of this predefined business group rather than defining a new one. If you define a new business group instead of modifying the predefined Setup Business Group, you need to set the HR: Security Profile profile option to point the security profile for the new business group. Oracle Human Resources automatically creates a security profile with the business group name when you define a new business group. Oracle Human Resources incorporates all other organizations you specify into the business group you define. See: Setting Up Security in Oracle HRMS You use the Organization window to retrieve the predefined Setup Business Group and change its name to the name of your business group to create your business group. The business group you define here appears in the list of values when you set up the HR: Security Profile profile option. A business group is a special classification of an organization, so you also need to specify its organization type, location, and whether it is an internal or external organization. It is also essential to select the correct legislation code for a business group for correct functioning of Oracle Human Resources. You cannot change the legislation code after entering employees in a business group. See also: Entering Business Group Information

Attention: Employees, organizations, and other entities are partitioned by business group. If you set up more than one business group, your data will be partitioned accordingly. In addition, classifying an organization as a business group is not reversible. Be sure to plan your business group setup carefully. For more information, refer to the Oracle Human Resources User's Guide.

You must also specify required business group information. Note that even though you must fill in a value for every segment in the Business Group Flexfield, Oracle Projects uses only the following information:

• Short name

• Employee Number Generation

• Job Flexfield Structure

• Project Burdening Organization Hierarchy

For each Business Group, you specify a Project Burdening Organization Hierarchy and Version. Oracle Projects uses the Organization Hierarchy/Version to determine the default Burden Multiplier when compiling a Burden Schedule. See: Burden Schedules

You must define the Organization Hierarchy before you associate it with a Business Group (see: Organization Hierarchy).

Oracle Human Resources links the predefined Job Flexfield structure to your business group.



Entering Business Group InformationThe Business Group Information window is an example of a flexfield structure. The first window you see displays the information in a condensed format. Click the field to open the full window, which labels each segment of the flexfield.
To enter Business Group information:

1. In the Organization window, query the Business Group if it does not already appear there. In the Organization Classifications region, select Business Group, choose the Others button, and select Business Group Information.

2. Click in a field of the Additional Organization Information window to open the Business Group Information window.

3. You can enter a short name for the Business Group. Release 10 does not use this name. It is provided for compatibility with earlier releases, where it appeared in the header line of each form.

4. Select the method of creating identifying numbers for employees and applicants. The choices are:

• automatic number generation

• manual entry

• automatic use of the national identifier (for example, the social security number in the US, and the NI number in the UK). This option is available for employees only.

Attention: Once you save your method, you cannot later change to either of the automatic options. You can only change to manual entry.

5. Select the names of the key flexfield structuresyou want to use in this Business Group.

6. Select the appropriate Legislation Code and default currency.

The Legislation Code determines the startup data you can access and the contents of some legislation-specific windows.

Attention: Selecting the correct legislation code is essential for the correct functioning of Oracle HRMS. You cannot change the legislation code after entering employees against the Business Group.

7. You can enter a Minimum and Maximum Working Age for the Business Group. When you enter or hire employees, you receive a warning if the person's age is outside this range.

8. Save your work.

Note: The Fiscal Year Start field is not used in Oracle Human Resources.

纵横四海

oracle 工程师让我运行了一下的脚本
SELECT DECODE(hli.legislation_code
,null,'Global'
,hli.legislation_code)                legCode
, hli.application_short_name                  asn
, hli.status status, last_update_date
FROM hr_legislation_installations hli
where hli.status = 'I';
这是结果：
LEGCODE        ASN        STATUS        LAST_UPDATE_DATE       
1        Global        PER        I               
2        GB        CM        I               
3        AU        PER        I               
4        AU        PAY        I               
5        CN        PER        I               
6        CN        PAY        I

gaoyiming

如果你刚刚设置完, 系统还是空的, 此业务组下面也没有员工等信息, 是可以直接在业务组设置界面修改的, 如果已经有了数据, 要想修改 也可以, 通过update 的sql 就可以修改, 修改完毕之后, 重启应用, 到目前为止 update 表 还没有发现问题, 但是不建议这样操作,

建议 : 重新创建一个新的业务组

纵横四海

用于更新数据库的一个方法：
hr_org_information_pkg.Update_Row

稍后更新详细的执行方法。

captain

期待四海的更新

windkid

刚好遇到这个问题，请求四海哥援助，如何后台更新呢？