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.

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

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