OWB 11.2.0.1 Data Chunking Mapping Deployment Fails With PLS-00201: identifier 'DBMS_APPLY.INITIALIZE' must be declared (Doc ID 1383630.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Deployment of an OWB 11.2.0.1 mapping with data chunking option fails with:

Error: PLS-00201: identifier 'DBMS_APPLY.INITIALIZE' must be declared
Line: 4190 Text: DBMS_APPLY.INITIALIZE(x_owner=>l_table_owner, x_table=>l_table_name, x_by_rowid=>true, x_task=>l_task_name);

Error: PL/SQL: Statement ignored
Line: 4190 Text: DBMS_APPLY.INITIALIZE(x_owner=>l_table_owner, x_table=>l_table_name, x_by_rowid=>true, x_task=>l_task_name);

Error: PLS-00201: identifier 'DBMS_APPLY.CHUNK_TABLE_BY_ROWID' must be declared
Line: 4192 Text: DBMS_APPLY.CHUNK_TABLE_BY_ROWID(x_task => l_task_name, x_batch_size => l_chunk_size);

Error: PL/SQL: Statement ignored
Line: 4192 Text: DBMS_APPLY.CHUNK_TABLE_BY_ROWID(x_task => l_task_name, x_batch_size => l_chunk_size);

Error: PLS-00306: wrong number or types of arguments in call to 'RUN_TASK'
Line: 4238 Text: DBMS_PARALLEL_EXECUTE.RUN_TASK (task_name => l_task_name, sql_stm => l_sql_stmt, language_flag => DBMS_SQL.NATIVE, parallel_level => l_parallel_level);

Error: PL/SQL: Statement ignored
Line: 4238 Text: DBMS_PARALLEL_EXECUTE.RUN_TASK (task_name => l_task_name, sql_stm => l_sql_stmt, language_flag => DBMS_SQL.NATIVE, parallel_level => l_parallel_level);

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms