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:

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

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