My Oracle Support Banner

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 03, 2019

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!


In this Document
Symptoms
Changes
Cause
Solution
  Latest Patches for Financials for EMEA
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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