My Oracle Support Banner

Unable To Create Assets From The AP (ORA-01652 FUSION_TEMP) (Doc ID 2379052.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Assets - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to use the Accounts Payable module to create Assets using "Create Mass Additions", the customer is getting errors.

ERRORS
-----------------------
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
ORA-20001: Application error ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP occurred while performing operation Insert into FA_MASS_ADDITIONS_GT with parameters {PARAMETERS} in package ->AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADD

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Payables -> Invoices
2. Go to Tasks -> Create Mass Additions
3. Select Accounting Date and Asset Book
4. Click on Submit (process is created)
5. Navigate to Schedule Processes and find your process
6. Process status ends in error. See log



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!


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