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 FEBRUARY 03, 2019
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)
In Oracle Financial Services Profitability Management (PFT) 220.127.116.11, after enabling DML Parallel Processing for PFT engine, in allocation debug execution log the following errors occur:
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:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document