EMEA VAT Selection Process Does Not Select AR data: ZX.TRL.ZX_EXTRACT_PKG.execute_dynamic_sql_strg "-12801: ORA-12801: error signaled in parallel query server P015 ORA-01652: unable to ext" (Doc ID 1519066.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Financials Common Country - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance 22-Oct-2014***

Symptoms

EMEA VAT: Selection Process does not select AR data. The following error occurs during the execution:

ZX.TRL.ZX_EXTRACT_PKG.execute_dynamic_sql_strg "-12801: ORA-12801: error signaled in parallel query server P015
ORA-01652: unable to ext"

This happens only for the first period "open" (e.g. the first period after the last processed in final mode).

In this case, the start date passed to the TRL engine is intentionally to null (while it is passed with a value for any later period)
So, the error is raised when the start date is passed to null to the TRL.

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