Parallel DML not specified in table or improper entry in table Errors Running PFT Allocations with Parallel Enabled (Doc ID 1917660.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.1.0.3, after enabling DML Parallel Processing for PFT engine, in allocation debug execution log the following errors occur:

ERROR

Module Logging OFS Access module data: Parallel DML not specified in table
or improper entry in table

Module Logging OFS Access module data: PARALLEL PROCESSING LIMITATION:: Parallel processing cannot be
enabled since SOURCE/ DRIVER has same table as debit/ credit

This error is confusing as the following statements enabling parallelism at session level were previously executed :

ALTER SESSION SET PARALLEL_DEGREE_POLICY = AUTO
ALTER SESSION FORCE PARALLEL QUERY

Furthermore, fsi_result_queue shows that tasks seems to be executed on four threads which is according to the setup from FSI_PARALLEL_PARAMETERS:

  JOB_NUM RESULT_TYPE RESULT_MESSAGE
1 OELPMINFO_Task1_40009517_EXEC_20130930_1 1 Allocation Complete in 00:00:05.
2 OELPMINFO_Task1_40009517_EXEC_20130930_1 2 FSI_D_LOAN_CONTRACTS
3 OELPMINFO_Task1_40009517_EXEC_20130930_1 3 Records Affected : 0
4 OELPMINFO_Task1_40009517_EXEC_20130930_1 4 Success
5 OELPMINFO_Task1_40009517_EXEC_20130930_4 1 Allocation Complete in 00:00:04.
6 OELPMINFO_Task1_40009517_EXEC_20130930_4 2 FSI_D_LOAN_CONTRACTS
7 OELPMINFO_Task1_40009517_EXEC_20130930_4 3 Records Affected : 0
8 OELPMINFO_Task1_40009517_EXEC_20130930_4 4 Success

The setup for parallel enabled was done as follows:

FSI_PARALLEL_PARAMETERS
  
PROCESS_ENGINE_CD PARALLEL_QUERY PARALLEL_DML PARALLEL_DEGREE PARALLEL_DEGREE _POLICY
1 0 FORCE ENABLE 4 AUTO

FSI_SQL_HINT_OPTIONS was also properly set:
SYS_ID_NUM PROCESS_ENGINE_CD FILTER_ON_HINT DML_HINT TREE_FILTER_HINT PERCENT_DIST_HINT
40009517 0 /*+ parallel(a, 8) */ /*+ parallel(TARGET, 8) */

The issue can be reproduced at will with the following steps:

1.  Enable parallel DML by updating fsi_parallel_parameter
2.  Run allocation
3. Check sessions on the database

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