在创建分类账（Oracle General Ledger 会计科目设置程序）出错

在创建分类账（ Oracle General Ledger  会计科目设置程序）出错。

**Starts**12-10-2016 02:42:00

**SQL error and free**12-10-2016 02:42:01

FDPSTP 中存在 ORACLE 错误 12018

 

原因：由于 ORA-12018: 在创建 "APPS"."GL_ACCESS_SET_LEDGERS" 的代码时出现以下错误

ORA-00600: 内部错误代码, 参数: [kkzdgdefq], [1], [], [], [], [], [], [], [], [], [], []

ORA-06512: 在 "SYS.DB12-10-2016 02:42:01 ORA-06512: 在 "SYS.DB12-10-2016 02:42:01

解决步骤：

Please reproduce the issue in your TEST instance, and implement following steps in TEST instance firstly:

1. Connect as APPS user to database

 

2. Drop the existing Materialized View

drop MATERIALIZED view GL_ACCESS_SET_LEDGERS;

 

3. Check whether the Materialized view is dropped properly or not:

select * from all_objects

where object_name like 'GL_ACCESS_SET_LEDGERS';

-- This should give 0 records.

 

4. Change directory to $GL_TOP/patch/115/sql

 

5. Connect to database as APPS user and execute the following at the sql prompt

@glvaslmv.sql

该部分因为系统glvaslmv.sql文件不能正确建立物化视图（文件不完整）

手工建立物化视图

首先建立预建表

-- Create table

create table GL_ACCESS_SET_LEDGERS

(

ACCESS_SET_ID NUMBER(15),