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 MARCH 18, 2024
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.
Symptoms
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
Changes
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
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!