My Oracle Support Banner

Allocation with Large Static Table Driver Fails with ORA- 14552: cannot perform a DDL, commit or rollback inside a query or DML (Doc ID 2554048.1)

Last updated on OCTOBER 11, 2019

Applies to:

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

Symptoms

In Oracle Financial Services Profitability Management (PFT), when attempting to run an Allocation with a large Static Table Driver, the Allocation fails with the following ORA-14552 error in the Allocation Engine log:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [12] - ofetch(),
   ofen() SQL Function: [4] -
SELECT Oracle Error: ORA- 14552: cannot perform a DDL, commit
or rollback inside a query
or DML ORA- 06512: at "<ATOMIC USER>.FSI_CREATE_STATIC_TABLE_VIEW", line
   83 ORA- 06502: PL/ SQL: numeric
or value error ORA- 06512: at
   "ATOMIC.FSI_CREATE_STATIC_TABLE_VIEW", line 49 Driver Function:
   drv_oci::FetchNext() SQL Statement:
SELECT FSI_CREATE_STATIC_TABLE_VIEW (103469.000000)
FROM DUAL

As a result of this error, you cannot process this large Static Table Driver Allocation.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.