R12: JG: (JGZZVSPB) EMEA VAT : Selection Process - Performance Issue ORA-01652: Unable to extend temp segment by 128 in tablespace TMP
(Doc ID 2358849.1)
Last updated on FEBRUARY 08, 2018
Applies to:Oracle Financials for EMEA - Version 12.1.3 and later
Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Spanish Localizations for AR
EMEA VAT : Selection Process - performance issue and finish with error due to:
Exception in OTHERS ZX_AR_EXTRACT_PKG.execute_dynamic_sql_strg : ORA-12801: error signaled in parallel query server P00
ORA-01652: Unable to extend temp segment by 128 in tablespace TMP
As per <Bug 27331596>
The dynamic where clause is not using AND and OR correctly
NULL date parameters must always be used in AND clause
and not in OR clause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!